Is fabric providing any GraphAPI for fetching table data?

Question

I have uploaded some csv data on fabric, for this i created workspace and in workspace i create lakehouse, then in this lakehouse i upload a file and then change this file into table, now i want to fetch this tables data using graph api. i can't use odbc driver because this is not feasible way for my project, I am trying to find any fabric graph api if fabric is provided.

Answer 1

Hi Nakul Prajapati ,

Thanks for reaching out to Microsoft!

For now, from a Graph API perspective, it is possible to fetch the table using the Graph API

GET /me/drive/items/{id}/workbook/tables/{id|name}

Get TableRow : GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index} retrieve the index and values of the row

Get TableColumn : GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name} retrieves the index and values of the column.

You can refer to the following documentation for more details: Fetch tables using Graph API.

Note: This API supports only delegated permissions.

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.