Forum Discussion
Fabric REST API - List Data Pipelines - Unauthorized
Hello,
I'm trying to get a list of pipelines using this:
Items - List Data Pipelines - REST API (DataPipeline) | Microsoft Learn
This is the behaviour I have noticed:
Workspace contains pipelines -> Status 200 OK
Workspace does NOT contain pipelines -> Status 401 Unautorized
Surely it should be 200 regardless of the content? Has anyone else noticed this? Is this a known issue?
Not the only inconsistency in the API responses.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
3 Replies
Not the only inconsistency in the API responses.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .Thanks! I just wanted to double-check that I wasn't missing something before submitting a support ticket!
It turns out I got confused with what the service principal can and cannot access!
I first got a list of workspace ids using:GET https://api.fabric.microsoft.com/v1/admin/workspacesThen, I assumed I could get the list of pipelines within those workspaces using:
GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/dataPipelinesAs it happens, the service principal had access to the workspaces containing pipelines but not the other ones (hence the confusion).
Now I know that I need to run an admin API call to get all pipelines from all workspaces (regardless of individual workspace permissions), such as:
GET https://api.fabric.microsoft.com/v1/admin/items?type=dataPipelineDocumentation here:
https://learn.microsoft.com/en-us/rest/api/fabric/admin/items/list-items
