topic Re: Fabric REST API - List Data Pipelines - Unauthorized in Pipelines

Fabric REST API - List Data Pipelines - Unauthorized

Acroustique — Tue, 01 Apr 2025 11:31:29 GMT

Hello,

I'm trying to get a list of pipelines using this:

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?

lbendlin — Tue, 01 Apr 2025 12:22:31 GMT

Not the only inconsistency in the API responses.

Acroustique — Wed, 02 Apr 2025 07:28:47 GMT

Thanks! I just wanted to double-check that I wasn't missing something before submitting a support ticket!

Acroustique — Wed, 02 Apr 2025 14:34:19 GMT

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/workspaces

Then, I assumed I could get the list of pipelines within those workspaces using:

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/dataPipelines

As 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=dataPipeline

Documentation here: