Forum Discussion
Programmatically Create Fabric Data Pipeline Cloud Connection
- 10 days ago
Hi CoulterJames2,
It is possible. The creationMethod is the type of connection to create. If you look at the examples in the documentation,
POST https://api.fabric.microsoft.com/v1/connections { "connectivityType": "ShareableCloud", "displayName": "ContosoCloudConnection", "connectionDetails": { "type": "SQL", "creationMethod": "SQL", "parameters": [ { "dataType": "Text", "name": "server", "value": "contoso.database.windows.net" }, { "dataType": "Text", "name": "database", "value": "sales" } ] }, "privacyLevel": "Organizational", "credentialDetails": { "singleSignOnType": "None", "connectionEncryption": "NotEncrypted", "skipTestConnection": false, "credentials": { "credentialType": "Basic", "username": "admin", "passwordReference": { "connectionId": "4399ab2c-7551-4c0e-8aa7-18fc2f217626", "secretName": "some-secret" } } }, "allowUsageInUserControlledCode": true }You can see that for this example, this is a SQL Server connection, and the CreationMethod is SQL.
Here is another API to list all the supported CreationMethods:
https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/list-supported-connection-types?tabs=HTTP
Hi CoulterJames2,
For cloud connections, only the owner can see them. So whatever crednetials you used to send the POST request is the account that can manage them, even as a fabric admin you cannot see someone's cloud connections.
I recommend using the REST API to also share the connection with yourself so you can see them, but editing them will need to be done only through the API using the credentials that created the connection.
Hi tayloramy yes, I realised this was the reason and then had to add a role assignment using my own credentials. Thanks for the help.