How to set additional headers in Data Store Read Settings?

Question

I am trying to import a schema based on a REST API call. In order to call this API, I need to send additional headers.

The syntax that I have tried so far is

"Authorization":"Bearer sometoken"
and
'Authorization':'Bearer sometoken'

Is there some other syntax that the data store read settings is expecting?

Answer 1

Hi @Abhijit Shrikhande ,

Apologies for the inconvenience you had to face.

Kindly check the below syntax to add the additional header : @{concat('Authorization: Bearer ', activity('GetBearerToken').output.access_token)} . This would convert the input string as : "Authorization: Bearer <AccessToken>"

Hope it helps. If this is not the solution you implemented, I would request you to share the solution with the community so that it would be helpful for the community members facing similar issues .

If the suggested response helped you, please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.
Looking forward to your response. Thankyou.

Answer 2

Hi @Abhijit Shrikhande ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

Since you have already resolved the issue you were facing while trying to make a REST API call using azure data factory pipeline , I understand while trying to import schema you are getting error to provide headers.

You could consider using REST API dataset to point to a REST API URL and make the API call using Copy data activity. Or, you can directly provide the REST API URL inside Web activity to make the API call. Inside the web activity or copy activity , we have the option to provide additional headers.

For more details , kindly check :
Web activity in ADF
Copy and transform data from and to a REST endpoint by using Azure Data Factory

If this is not how you resolved your issue, I would encourage you to kindly share your workaround so that it would be helpful for the community members facing similar issues . Thankyou in advance for your efforts in doing so. Looking forward to your response.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators