Getting data from Lakehouse using Onelake API

[SreejaKarra]

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 not getting a error or data just a blank page. 

Attaching the image, which contains the details of how I'm generating the token for Authentication.

Passing the generated token able to get data from files endpoint

Passing the same generated token getting a blank response when using table endpoint

Any tips would be appreciated. Thanks In advance

[Expiscornovus]

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]

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.

[v-cboorla-msft]

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 .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

[SreejaKarra]

Hi, We didn't get any solutions for accessing data from tables inside one lake. As @Expiscornovus is also not sure about it in the comment, any help would be appreciated. Thanks.