The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Hi @alirng ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.
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.
Hi @alirng ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
15 | |
14 | |
11 | |
6 | |
6 |