Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
Error "The 'Authorization' header is missing" when using web activity in ADF to access Key Vault values
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 14.000000000000002%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sharon
60
Reputation points
Hi,
This post is written to ask for help on an issue we ran into when following https://medium.com/analytics-vidhya/azure-data-factory-access-microsoft-graph-api-3bbab165eb40 to access Graph API using ADF. The link will be super useful in understanding the context of the question.
An unexpected error populated at the beginning for the web activity to extract the key vault secret firstly saying link missing API version, after updated the API version at the end of URL a new error pop up as 400 Bad Request without further details on what exactly the error is. By following https://the.agilesql.club/2021/03/adf-error-trying-to-debug-pipeline-badrequest/ we were able to find the root cause by the network tab using chrome dev tools as shown below:
{"error":{"code":"AuthenticationFailed","message":"Authentication failed. The 'Authorization' header is missing."}}
Since both errors are not alarmed in the medium instruction mentioned at beginning, can anyone help us to solve this issue to get the pipeline work? If this is not the way you think is the best practice to access Graph API using ADF, any other similar detailed instruction shared is extremely appreciated.
Many thanks and happy holidays in advance!
Azure Data Factory
{count} votes
-
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator2023-12-21T03:49:09.35+00:00 Hey,
can you please provide the screenshot and details of the web activity w.r.t key vault fetch aspect for which you are getting the error.
Also, the best way to fetch data is using Managed Identity rather than using SP
-
Sharon 60 Reputation points
2023-12-21T21:34:15.3966667+00:00 Thank you for responding!
The screenshot is attached.
And once we click the management link at the right bottom corner, the link will show below authentication fail message
-
Sharon 60 Reputation points
2023-12-21T21:37:05.84+00:00 Thank you for the response!
is the screen shot, once we clicked the botton right management azure link in the blue square block the following error message pop up
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator2024-01-02T20:13:07.1766667+00:00 Hello,
Per the error message, the authentication token is not being passed correctly.
Did you provide graph API access to ADF. if not, check this article.
and check whether authentication token is valid and has not expired.
Please check this troubleshooting document for the authorization errors.
Also, please check this blog post.
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2024-01-05T00:30:44.4833333+00:00 I am checking to see if you had a chance to look into the above response.
-
Sharon 60 Reputation points
2024-01-30T00:34:37.6633333+00:00 thank you BhargavaGunnam-MSFT for following up! I was off when the response was posted, working on it now. Will keep you updated in the thread!
-
Sharon 60 Reputation points
2024-01-31T22:47:25.9733333+00:00 Hi BhargavaGunnam-MSFT, Thank you for answering and following up! Was out of office when the response is posted and just got back, will work on it and let you know how it goes
Sign in to comment
Sign in to answer