Need help: Automating Connection creation via REST API

[ritikesh]

Hi,

I'm using the Data Pipeline resource inside fabric and the Salesforce connector to connect to a salesforce system. The first time i do this, I'm supposed to create a connection via my org account, i can give access to this connection to other members as well. I'm looking to automate this connection creation process via Fabric's REST API. The documentation mention Get, List, Create, etc APIs but after doing certain PoCs on them, i found only SQL connections and connections Salesforce Systems are not listed.
Has anyone done this before or has any insights.

Please let me know.

Thanks

[v-tsaipranay · Accepted solution]

Hi @ritikesh ,

Thank you for reaching out to the Microsoft Fabric Community.

Automating the creation of Salesforce connections in Microsoft Fabric via REST API isn’t fully supported at the moment. While the API allows for creating SQL and some other connections, Salesforce connections don’t appear to be manageable via the API yet. Currently, they need to be set up manually through the UI in Dataflow Gen2 or data pipelines.

For now, the best approach is to create the connection manually and then share access with other users as needed. You can refer to the official documentation for setting up Salesforce connections: Salesforce Objects Connector in Microsoft Fabric

I’d also recommend providing feedback to Microsoft, as more user requests could encourage them to enhance the API. You can share your feature requests or ideas through this link for consideration: Fabric Ideas - Microsoft Fabric Community. 

If you need any further assistance, please feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-tsaipranay]

Hi @ritikesh ,

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 it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @ritikesh ,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thankyou.

[v-tsaipranay]

Hi @ritikesh ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.