Azure Synapse -- How do I submit OAuth2 access token in a Data Flow?
13:29 07 Aug 2026

Pipeline in two steps, get token, then submit request for data

So this is what my basic make-it-work setup looks like currently. The first call is successful. I get an access_token from it. So in step number two I want to pull data from the source using that access token. But I can't figure out how to attach it so that the source machine recognizes it for what it is. My setup is this –

Example of how the token is being attached.

It creates request, and it includes the access token in the Additional Headers section, like this --

{
"source": {
"type": "RestSource",
"httpRequestTimeout": "00:01:40",
"requestInterval": "00.00:00:00.010",
"requestMethod": "GET",
"additionalHeaders": {
"Token_Added": "Authorization: Bearer yf7VinFqG1UFjlYHeVq7v-bbU3U03ulSK1IjN-IJKHpDCbopDQU1bBY3Kji_oUsY8arzqiFWreBp7scHg"
},
"paginationRules": {
"supportRFC5988": "true"
}
},
"sink": {
"type": "DelimitedTextSink",
"storeSettings": {
"type": "FileServerWriteSettings"
},
"formatSettings": {
"type": "DelimitedTextWriteSettings",
"quoteAllText": true,
"fileExtension": ".txt"
}
},
"enableStaging": false
}

The token is being included. But it has the "additionalHeaders" wrapper around it and the "Token_Added" title on the particular header item, that I don't want to put there but can't leave blank.

The machine at the destination provided by the Data Source issues an error --

"Failure happened on 'Source' side. ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 401 Unauthorized, please check your activity settings.\nRequest URL: https://api.usix.postur.cloud/api/v2/users . \nResponse: {\"message\":\"No authentication bearer token specified in authorization header.\",\"code\":\"authentication.required\",\"status\":401 . . . .

So it's not capturing the access_token

Has anyone done this successfully? I can GET or POST, though I can't get either to work because of this same issue. I found an example on the Internet that in theory works, but it's with an older version of Synapse with a different set of options for the Copy command, so I can't duplicate it.

How do I send an authorization with the RESTful request? I'm open to other approaches.

azure-pipelines