Fabric REST API for Delta Tables

[alirng]

Hi,

We're building an internal webapp using nodejs and it requires reading data from delta tables within our microsoft Fabric lakehouses. Is there a GET request built for this task? 

The post request for Load Table does not seem to be working for delta tables via the documentation. 

[v-veshwara-msft · Accepted solution]

Hi @alirng ,

Thanks for reaching out to the Microsoft Fabric Community.

At this time, there is no built-in REST API available to directly query or retrieve data from Delta tables stored in a Fabric Lakehouse. The existing Fabric REST APIs do not support reading Delta table contents using a GET request.

However, Microsoft Fabric provides GraphQL endpoint that supports querying data from Lakehouses and Warehouses through the SQL analytics layer. You can refer to the documentation here:
Microsoft Fabric API for GraphQL overview - Microsoft Fabric | Microsoft Learn

Alternatively, if your application strictly requires REST access, one possible approach is to build a custom API using Azure Functions. This involves reading the Parquet files behind the Delta tables stored in OneLake and exposing them via your own REST endpoints.

Here's this approach in more detail here: Microsoft Fabric Lakehouse Data via REST API

Hope this helps. Please reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @alirng ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft]

Hi @alirng ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @alirng ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.