Forum Discussion

Scott_Powell's avatar
Scott_Powell
Icon for Helper V rankHelper V
3 years ago

Newbie help with Pipeline copy from Web API that uses header token

Hi, I'm (completely) new to data pipelines - I come from a Power BI world so I know dataflows not pipelines.   I'm trying to use a COPY activity to copy data from a web API. From PowerShell I'm abl...
General Question
Need Help
pipelines
ajarora's avatar
ajarora
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Who mints this token ? If its an AAD token, is that a user token belonging to you ? or a SPN token, belonging to an AAD enterprise App, (or MSI/UAMI flavor of identities) ?

Scott_Powell's avatar
Scott_Powell
Icon for Helper V rankHelper V
3 years ago

Sorry you're asking questions above my knowledge level! All I can say is we reach out to this vendor and say "we need a token to hit your APIs", and then somehow we get this very long, very ugly string that when we stick in the header using the PowerShell code above it works.

 

The URL is hosted by the vendor, not in Azure or Google or anything as far as I know.

 

Hope this helps and sorry I don't know more!

Scott

  • ajarora's avatar
    ajarora
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Good enough, thanks. Unfortunately I dont see any workaround for now in Fabric.

    Please submit an idea to support new auth type in Rest connection (via auth headers ?), if there isnt one already. 

  • ScottPowellECU's avatar
    ScottPowellECU
    Icon for Advocate II rankAdvocate II
    3 years ago

    Will do - thank you!

    Scott