This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(246.4, 50%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Hello,
I am in the process of designing a pipeline of writing back to api using endpoint of SAP.
I was able to do a post call and get the needed resultset from postman.
While the same end point is giving unauthorised error in adf.
I am not sure if this is a network error
I am generating a token which I am passing as a header value in post call.
BODY has the {}
Do I have to select something in authentication
![](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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Hi @N2120
Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!
It looks like you're encountering an unauthorized error (2108) when trying to call the SAP API from Azure Data Factory (ADF). This can happen for several reasons, here are some steps to troubleshoot and resolve the issue:
Authentication Mode - In ADF Web Activity, make sure the Authentication type is set to None if you're manually passing a token in the headers. In the Headers section, include your token.
Token Generation - Double-check the token you’re generating, ensure the token is valid and not expired at the time of the API call. Confirm that the token generation process in ADF matches the one in Postman (e.g., all required parameters, headers, and body fields are being sent).
Body and Headers - Verify that the Body and Headers in the Web Activity exactly match what you used in Postman. Ensure the Content-Type is explicitly set to application/json in the headers.
API URL and Parameters - Ensure the API URL in ADF matches the one tested in Postman, including query parameters and case sensitivity. Double-check for any extra spaces or formatting issues in the URL or headers.
Network Access - If the SAP API is hosted on a private network or behind a firewall, you’ll need to: Use a self-hosted Integration Runtime (IR) or Enable Managed Virtual Network (VNet) in ADF. If you're unsure, you can test connectivity from ADF to the API using tools like curl or nslookup.
Error Output - Check the Output of the Web Activity in ADF for the detailed error message. Sometimes, the error might hint at missing headers, incorrect tokens, or network-related issues.
Please refer to MS Q&A thread - ADF error accessing webservice with security token addressing similar issue as it might offer some insights.
For more details, please refer the Microsoft documentation: Troubleshoot Azure Data Factory and Synapse pipelines
I hope this information helps. Please do let us know if you have any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thanks for your email. But none of this is working.
I was able to pull the token and csrf token generated in postman and pass it in adf but still got the same unauthorized error.
Thanks for your email. But none of this is working.
I was able to pull the token and csrf token generated in postman and pass it in adf but still got the same unauthorized error.
Thank you for the update!
Glad to hear that you were able to pull the token and CSRF token in Postman and pass them into ADF. Since you're still encountering the unauthorized error, here are a few advanced troubleshooting steps you can follow:
Session Management - Some systems require an initial request to obtain a session before other requests are authorized. Check if there’s a need for any pre-request or session initialization that might be handled differently in Postman.
Consistency Across Environments - Verify that the environment variables or parameters used in Postman are set correctly in ADF. Ensure there are no hardcoded values in Postman that might differ in ADF.
Header Configuration - Double-check your headers for any discrepancies. Make sure the Authorization header includes the correct token type (e.g., Bearer) and the CSRF token header is correctly named and formatted.
API Endpoint and Method - Ensure that the API endpoint and HTTP method (e.g., POST, GET) in ADF exactly match those used in Postman. Any slight variation can lead to authorization issues.
Logging and Monitoring - Enable detailed logging in ADF to capture the full request and response. This can provide insights into whether the request is being altered or if additional headers are required.
SAP API Specifics - Review any specific SAP API requirements or limitations regarding tokens and headers. Some APIs have specific requirements that must be adhered to for programmatic access.
Firewall and IP Restrictions - Confirm that there are no IP restrictions or firewall rules blocking requests from ADF. If necessary, whitelist the IP address range used by ADF.
I hope this information helps.
Thank you.
Following up to see if the above suggestion was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
None of this worked. I was able to use this link, use answer given by Jagjeet Singh Makhija. pass cookie as header and pass value specified in link and make the post call work https://learn.microsoft.com/en-us/answers/questions/363643/web-activity-gives-error-code-2108-but-same-api-ca
I was able to make the unauthorized error go away by following the answer given by Jagjeet Singh Makhija in this link
I passed cookie as header in web activity and value specified here and it was able to complete post call successfully.
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.
Issue:
I am in the process of designing a pipeline of writing back to api using endpoint of SAP.
I was able to do a post call and get the needed resultset from postman.
While the same end point is giving unauthorised error in adf.
I am not sure if this is a network error
I am generating a token which I am passing as a header value in post call.
BODY has the {}
Do I have to select something in authentication
Solution:
Adding the cookie as a header in Web Activity resolved the issue, and my POST call is now successful.
"Thank you, @Jagjeet Singh Makhija, your solution worked perfectly. I appreciate your help!"
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
I hope this information helps. Please do let us know if you have any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Following up to see if the above suggestion was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.