Web Activity gives Error Code 2108....but same API call works fine in Postman

Question

Web Activity gives Error Code 2108....but same API call works fine in Postman

Paul R 96

I've searched forums for days, but cannot find answer to this problem.

*I have a simple GET API call that works fine in Postman, but my Web Activity fails with Error Code 2108:

Error calling the endpoint 'https://app.triblio.com/api/reports/account_metrics'. Response status code: ''. More details: Exception message: 'The format of value '1618415703' is invalid.'. No response from the endpoint. Possible causes: network connectivity, DNS failure, server certificate validation or timeout.

*The error refers to value '1618415703', which a header item called date. The value is a Epoch Timestamp. (that value is from a few days ago, but still works fine in Postman. When I use current Epoch Timestamp, I get the same error).

*There are three headers required to authenticate: date, token, and signature. When I remove one of those headers, I get an "Unauthorized" error....so I know that it is connecting to the URL successfully.

*Per other forum suggestions, I have increased the timeout but I think that is unrelated because the Web Activity fails almost instantly. In Postman, the API calls takes 3 seconds to run.

*I have also experimented with adding in a Linked Service that calls that same URL, but that didn't seem to make a difference.

Thank you for any help; I'm watching for replies so that I can respond quickly to follow-up questions.

89362-code.txt

Paul R 96 Reputation points

2021-04-20T04:44:59.19+00:00
Similar question elsewhere here, but no clear answer....but possible clue that the Linked Service is somehow might be related:

https://social.msdn.microsoft.com/Forums/azure/en-US/0f233f17-8c07-4dc5-9104-cb862c959f04/my-data-factory-v2-pipelines-stopped-sending-post-commands-with-web-activities-error-2108?forum=AzureDataFactory

Similar question on Github, but no answer:

https://github.com/MicrosoftDocs/azure-docs/issues/38069
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-21T20:05:00.197+00:00

Hello @Paul R ,
Thanks for the ask and using the Microsoft Q&A platform . Thanks for the very descriptive ask and also sharing the different things which you tried , that always help.
Can you please check if you can call any other API where you do not need to pass the date header ? I tried to use the API mentioned myself , but i dont think triblio had any concept of free account .

What I have done is I have also reached out to internal team and to see if I can get some help on this .

Also please send an email to azcommunity@microsoft.com with the below details .

Subscription ID:
Subject : Attn Himanshu
Activity runid :
Please let me know once you have done the same.

Thanks
Himanshu
Paul R 96 Reputation points

2021-04-24T21:11:02.303+00:00

Hello @HimanshuSinha ;
Thank you so much for the response...I'm emailing you directly with the details.

But to answer your one question here: I have tried many other API calls where I do not need to pass an Epoch Datetime, and they all work fine.

Most API calls require a date range so that you don't get an overwhelming amount of data. My other API calls that require date range in the body or as a parameter work fine.

For some reason, the Epoch datetime is confusing the Web Activity, even though it appears as a string and doesn't look like a date. In my case here, the Epoch Datatime is used as part of the authentication, and not used as part of the actual data request.

Paul

Answer accepted by question author

1 additional answer

Your answer

Paul R 96 Reputation points

2021-04-20T04:44:59.19+00:00

Similar question elsewhere here, but no clear answer....but possible clue that the Linked Service is somehow might be related:

https://social.msdn.microsoft.com/Forums/azure/en-US/0f233f17-8c07-4dc5-9104-cb862c959f04/my-data-factory-v2-pipelines-stopped-sending-post-commands-with-web-activities-error-2108?forum=AzureDataFactory

Similar question on Github, but no answer:

https://github.com/MicrosoftDocs/azure-docs/issues/38069
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-21T20:05:00.197+00:00

Hello @Paul R ,
Thanks for the ask and using the Microsoft Q&A platform . Thanks for the very descriptive ask and also sharing the different things which you tried , that always help.
Can you please check if you can call any other API where you do not need to pass the date header ? I tried to use the API mentioned myself , but i dont think triblio had any concept of free account .

What I have done is I have also reached out to internal team and to see if I can get some help on this .

Also please send an email to azcommunity@microsoft.com with the below details .

Subscription ID:
Subject : Attn Himanshu
Activity runid :
Please let me know once you have done the same.

Thanks
Himanshu
Paul R 96 Reputation points

2021-04-24T21:11:02.303+00:00

Hello @HimanshuSinha ;
Thank you so much for the response...I'm emailing you directly with the details.

But to answer your one question here: I have tried many other API calls where I do not need to pass an Epoch Datetime, and they all work fine.

Most API calls require a date range so that you don't get an overwhelming amount of data. My other API calls that require date range in the body or as a parameter work fine.

For some reason, the Epoch datetime is confusing the Web Activity, even though it appears as a string and doesn't look like a date. In my case here, the Epoch Datatime is used as part of the authentication, and not used as part of the actual data request.

Paul

Answer 1

Himanshu wrote me and said:

"We did had discussed internally this issue and we aggreged that mostly the header is passed as string in WebActivity whereas Postman it is integer/long."

Conclusion: it appears that WebActivity is doing something to a piece of data that I don't intend for it to do (treating it as a string).

I'm going to close this issue because it doesn't seem like there's a way to get around this problem in Web Activity. Personally, my workaround will be to make the API call using Powershell, and I'll call that Powershell script from within Data Factory.

Answer 2

Jagjeet Singh Makhija 10 Microsoft Employee

Most of us face this err while try to open URL:

User's image

Above issue is resolved now we can easily pass the cookie values from one web component to another web component using Azure Data Factory below is the screenshots to demonstrate.

Passing Web2 component cookie values to Web3 component.

Need to set this in the header section with the given expression.

User's image

Set the reference of cookie values in Web2 component.

User's image

Passed the reference of cookie values to Web3 component and attach with the given URL section in settings.

User's image

Below URL accessed using cookie value passed to this Web3 component.

User's image

Hope this will help Azure community to fix this issue.

Article published by - Jagjeet Makhija

Charles Wigington 0 Reputation points

2023-08-30T14:45:00.5033333+00:00

This worked for me! thank you so much!!

Share via

Web Activity gives Error Code 2108....but same API call works fine in Postman

1 additional answer

Your answer