Forum Discussion
FABRIC API REST
Hello,
I need to know whitch dwh et fabric items i have in my workspace. How can i use the fabric api rest for that ?
Thanks
Hi BenLyon ,
Thank you for reaching out to the Microsoft Fabric Community.
To find data warehouse extract-transform items in your Microsoft Fabric workspace, you can use the List Items API. This lets you pull a list of items in your workspace and filter by type — like DataPipeline or Dataflow. You just need to send a GET request to https://api.fabric.microsoft.com/v1/admin/items, including your workspace ID and item type in the URL, like this:
GET https://api.fabric.microsoft.com/v1/admin/items?workspaceId={your_workspace_id}&type=DataPipeline
Make sure you have the right permissions — either as a Fabric admin, Office 365 Global admin, or using a service principal and include the correct API permissions (Tenant.Read.All or Tenant.ReadWrite.All).
The response will give you useful details like the item’s ID, type, and status. If you have a lot of items, the API supports pagination to handle bigger lists.
As lbendlin shared a documentation it explains this API and how to set it up. You can check it out here for more details.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
5 Replies
Hi BenLyon ,
Thank you for reaching out to the Microsoft Fabric Community.
To find data warehouse extract-transform items in your Microsoft Fabric workspace, you can use the List Items API. This lets you pull a list of items in your workspace and filter by type — like DataPipeline or Dataflow. You just need to send a GET request to https://api.fabric.microsoft.com/v1/admin/items, including your workspace ID and item type in the URL, like this:
GET https://api.fabric.microsoft.com/v1/admin/items?workspaceId={your_workspace_id}&type=DataPipeline
Make sure you have the right permissions — either as a Fabric admin, Office 365 Global admin, or using a service principal and include the correct API permissions (Tenant.Read.All or Tenant.ReadWrite.All).
The response will give you useful details like the item’s ID, type, and status. If you have a lot of items, the API supports pagination to handle bigger lists.
As lbendlin shared a documentation it explains this API and how to set it up. You can check it out here for more details.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi BenLyon ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi BenLyon ,
I wanted to follow up on our previous suggestions regarding issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.