topic Re: ADLS Gen 2 Connection creation using Fabric REST API in Data Engineering

ADLS Gen 2 Connection creation using Fabric REST API

rahul-biswas_le — Wed, 22 Jan 2025 09:20:46 GMT

I want to create a connection to ADLS Gen 2 using Fabric Rest API. Can anyone please share an example of how to construct the request body for the API call for this scenario? I have managed to get this, but this is erroring out at the Server end.

import requests

# Define the API endpoint and bearer token

api_url = "https://api.fabric.microsoft.com/v1/connections"

# Define the request body

request_body = {

"connectionDetails":

# Add your connection details here

{

"type": "AzureDataLakeStorage",

"creationMethod": "AzureDataLakeStorage", # What do I give for creationMethod?

"parameters": [

{

"dataType": "Text",

"name": "server",

"value": "https://XXXXXXXXX.dfs.core.windows.net",

{

"dataType": "Text",

"name": "fullPath",

"value": "optraroot"

}

"connectivityType": "ShareableCloud", # Connectivity type as specified

"credentialDetails": {

"connectionEncryption": "NotEncrypted",

"credentialType": "ServicePrincipal",

"credentials": {

"servicePrincipalClientId": "XXXXXXXXX",

"servicePrincipalSecret": "XXXXXXXXXXXX",

"tenantId": "XXXXXXXXX",

"singleSignOnType": "None",

"skipTestConnection": True,

'gatewayId': None,

"displayName": "My Connection", # Replace with the desired display name (max 200 chars)

"privacyLevel": "None", # Replace with the appropriate privacy level

}

@Connections - Create Connection - REST API (Core) | Microsoft Learn

Re: ADLS Gen 2 Connection creation using Fabric REST API

Anonymous — Fri, 24 Jan 2025 11:25:13 GMT

Hi @rahul-biswas_le,

Thank you for reaching out in Microsoft Community Forum.

providing the documents which might you assist you in creating a connection to ADLS Gen 2 using Fabric Rest API.
Azure Data Lake Storage Gen2 REST API reference - Azure Storage | Microsoft Learn
Set up your Azure Data Lake Storage Gen2 connection - Microsoft Fabric | Microsoft Learn

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and select "Yes" if it was helpful. help other members find it more easily.

Regards,
Pavan.

Re: ADLS Gen 2 Connection creation using Fabric REST API

KrishnaPaudel — Fri, 24 Jan 2025 22:45:19 GMT

Here is the sample request body that worked for me with Workspace Identity as authentication.
Try changing the auth to SPN in your case. Hope this helps.

{ "displayName": "FHE_TestEndPoint", "connectivityType": "ShareableCloud", "connectionDetails": { "creationMethod": "AzureDataLakeStorage", "type": "AzureDataLakeStorage", "parameters": [ { "dataType": "Text", "name": "server", "value": "https://sampleadls.dfs.core.windows.net" }, { "dataType": "Text", "name": "path", "value": "sampleadlscontainer" } ] }, "privacyLevel": "Organizational", "credentialDetails": { "credentials": { "credentialType": "WorkspaceIdentity" }, "connectionEncryption": "NotEncrypted", "skipTestConnection": false, "singleSignOnType": "None" }, "allowDatasourceThroughGateway": false }

Re: ADLS Gen 2 Connection creation using Fabric REST API

Anonymous — Thu, 30 Jan 2025 04:52:57 GMT

Hi @rahul-biswas_le,

Thank you for reaching out in Microsoft Community Forum.

Thank you @KrishnaPaudel for the helpful response.

As suggested by Krishnapaudel, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

Re: ADLS Gen 2 Connection creation using Fabric REST API

Anonymous — Tue, 04 Feb 2025 05:28:33 GMT

Hi @rahul-biswas_le,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.

Regards,
Pavan.

Re: ADLS Gen 2 Connection creation using Fabric REST API

Anonymous — Fri, 07 Feb 2025 07:18:54 GMT

Hi @rahul-biswas_le,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as "Accept as Solution" and give 'Kudos' if you found it helpful.

Regards,
Pavan.