Forum Discussion

SreejaKarra's avatar
SreejaKarra
Regular Visitor
2 years ago

Getting data from Lakehouse using Onelake API

Hi,  I'm new to MS Fabric and I'm having some trouble getting data from onelake API, I have Tables and files inside Lakehouse able get data when using files endpoint but when using tables endpoint n...
one lake
Expiscornovus's avatar
Expiscornovus
Most Valuable Professional
2 years ago

Hi SreejaKarra,

 

Just to double check, you are using Postman to test this retrieval/integration. The goal is to integrate with another system, I presume?

 

I just had a look at this myself. I can also only get a 200 response from the Table (I am using a Power Automate cloud flow for this with an Entra Id preauthorized Invoke an HTTP request action).

 

Although the Tables endpoint is listed in the parity documentation I am not enterily sure if this is supported or if it just needs additional headers (or some other additional configuration):

https://learn.microsoft.com/en-us/fabric/onelake/onelake-api-parity

 

 

I also see that in the Fabric REST API endpoints only listing of tables is supported, not the actual retrieval of rows:

https://learn.microsoft.com/en-us/rest/api/fabric/lakehouse/tables

 

Hopefully this helps a bit?

 

 

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi SreejaKarra 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.


Thanks.