Guidance Needed on Microsoft Fabric API Integration with Salesforce for total value Data Sync.

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