A list of tables via API does not contain view tables and detailed properties

[jwryu]

i've got a list of tables in my Lakehouse using API and the response is as below.

however, there are needs to identify what are the shortcut tables. also view tables are need to be shown in the list. 

i know there is Get shortcut API(https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/get-shortcut?tabs=HTTP#shor...) but i am not sure how to use it in my case,,,

is anyone please help? 

Best regards

{
"continuationToken": "+RID:~HTsuAOseYicH-GcAAAAAAA==#RT:1#TRC:1#ISV:2#IEO:65567#QCF:8#FPC:AgKfAZ8BnwEEAAe8eoA=",
"continuationUri": "https://api.fabric.microsoft.com/v1/workspaces/f089354e-8366-4e18-aea3-4cb4a3a50b48/lakehouses/41ce0...",
"data": [
{
"type": "Managed",
"name": "Table1",
"location": "abfss://f089354e-8366-4e18-aea3-4cb4a3a50b48@onelake.dfs.fabric.microsoft.com/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/Tables/Table1",
"format": "Delta"
}
]
}

[nilendraFabric · Accepted solution]

Hi @jwryu 

You’re correct that the List Tables API response doesn’t include view tables or detailed properties like whether a table is a shortcut. To address your needs, you’ll need to use a combination of APIs and potentially some additional processing. Here’s how you can approach this:
1. For shortcut tables:
• Use the Get Shortcut API for each table in your list to determine if it’s a shortcut.

https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/get-shortcut
• You’ll need to make separate API calls for each table, using the workspace ID, item ID (Lakehouse ID), and table name.
2. For view tables:
• Unfortunately, the current List Tables API doesn’t include view tables in its response.
• You might need to use a different approach, such as querying the Lakehouse directly using SQL, to get a complete list including views.
3. To combine this information:
• Start with the List Tables API to get your initial list.

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

• For each table, make a Get Shortcut API call to check if it’s a shortcut.
• Use a separate method (like SQL querying) to get view tables and merge this information with your list.

please give kudos and accept the solution if this is helpful.

thanks