Forum Discussion
Guidance Needed on Microsoft Fabric API Integration with Salesforce for total value Data Sync.
Hi Team,
We are working on an integration between Microsoft Fabric and Salesforce.
Requirement:
We need to pull some totals value from Microsoft Fabric/Data Lake into Salesforce.
We would like guidance on the best API/service approach for fetching data from Microsoft Fabric.
Could you please help with:
- Recommended API/service to access Fabric Lakehouse/Warehouse data externally
- Whether REST APIs are available for querying Lakehouse/Warehouse tables/views
Any documentation references or recommended approaches would be appreciated.
Thanks!
Hi harsh_chandra ,
Thank you for reaching out to the Microsoft fabric community forum.Fabric does have a Lakehouse REST API, but it’s mainly for management tasks like creating a Lakehouse, listing tables, or uploading files. It doesn’t support running SQL queries directly.
For querying data, the recommended option is the SQL analytics endpoint that comes with every Lakehouse/Warehouse. You can connect using ADO.NET, JDBC, or ODBC with Microsoft Entra ID authentication.
If your integration (like Salesforce) needs REST/JSON, a common approach is to build a small wrapper service (for example, an Azure Function or API Management layer) that queries Fabric via the SQL endpoint and exposes the results as REST.
Kindly refer to the below documentation links for better understanding:Manage a lakehouse with the REST API - Microsoft Fabric | Microsoft Learn
Warehouse Connectivity - Microsoft Fabric | Microsoft Learn
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Teams.Hi harsh_chandra,
If you're trying to pull data out of Fabric data stores, a REST API is not what you're looking for.
There is a GraphQL API that you can set up to expose data, or you can connect directly to the SQL Endpoint to pull data.
https://learn.microsoft.com/en-us/fabric/data-engineering/api-graphql-overview
4 Replies
Hi harsh_chandra ,
Thank you for reaching out to the Microsoft fabric community forum.Fabric does have a Lakehouse REST API, but it’s mainly for management tasks like creating a Lakehouse, listing tables, or uploading files. It doesn’t support running SQL queries directly.
For querying data, the recommended option is the SQL analytics endpoint that comes with every Lakehouse/Warehouse. You can connect using ADO.NET, JDBC, or ODBC with Microsoft Entra ID authentication.
If your integration (like Salesforce) needs REST/JSON, a common approach is to build a small wrapper service (for example, an Azure Function or API Management layer) that queries Fabric via the SQL endpoint and exposes the results as REST.
Kindly refer to the below documentation links for better understanding:Manage a lakehouse with the REST API - Microsoft Fabric | Microsoft Learn
Warehouse Connectivity - Microsoft Fabric | Microsoft Learn
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Teams.- tayloramy
Super User
Hi harsh_chandra,
If you're trying to pull data out of Fabric data stores, a REST API is not what you're looking for.
There is a GraphQL API that you can set up to expose data, or you can connect directly to the SQL Endpoint to pull data.
https://learn.microsoft.com/en-us/fabric/data-engineering/api-graphql-overview
Hi harsh_chandra,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.Hi harsh_chandra,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.