topic Re: Passing a bearer token to copy data action using GET in Pipelines

Passing a bearer token to copy data action using GET

smeetsh — Thu, 02 May 2024 23:54:17 GMT

Hi All,

Not a question, but something I ran into, as I am just picking up MS Fabric, pipelines etc.

I needed to use web request, to get an access token that is valid for 30 minutes. Next I needed to use that token as a bearer token to do a follow up API call to get actual data , there didn't seem to be that much info around, when I tried to google it. Eventually I found a you tube video, that told me what i needed to know. (linked below). Things like apikeys and other credentials will of course vary on the API yo are trying to use.

This is my flow.

Step 1
Do your web request

Step 2 link the Web and copy data action

Step 3 In the copy data action set it up as follows:

As you can see the value of the Authorization header is dynamic, with in my case, the following expression:

Bearer @{activity('Get access token').output.access_token}

The part ".access_token" depends on the json you get returned, in my case it was a very flat structure with no above array.

{

"token_type": "BearerToken",

"issued_at": "xxx",

"salesforce_id": "xxx",

"access_token": "xxx",

"application_name": "xxx",

"scope": "refresh_token full",

"expires_in": "xxx"

}

Above you can see where i got the parameter access_token from. If this array had been nested in for instance another array called "data" then the value would have been data.access_token in stead of just access_token.

I hope this is usefull info to share here. The video I got this from you can find here .

Cheers

Hans

Re: Passing a bearer token to copy data action using GET

Anonymous — Fri, 03 May 2024 03:09:21 GMT

Hi smeetsh ,

Thanks for using Fabric Community.
Can you please confirm whether this is a question or just sharing the knowledge across the Community?
As I understand you are just sharing the knowledge across the Community.

Re: Passing a bearer token to copy data action using GET

smeetsh — Sun, 05 May 2024 20:35:17 GMT

Good morning,

Yes just sharing knowledge, since it wasn't so straightforward to find as I thought it would be

Cheers

Hans

Re: Passing a bearer token to copy data action using GET

0simmis0 — Sun, 05 Jan 2025 07:16:26 GMT

Thank you!

Re: Passing a bearer token to copy data action using GET

Krupps — Fri, 28 Aug 2026 14:56:46 GMT

You should not put a token in directly, instead use @concat('Bearer ', activity('Get Auth Token').output.access_token)

Re: Passing a bearer token to copy data action using GET

smeetsh — Sun, 30 Aug 2026 21:12:44 GMT

Which is exactly what id did