DataFactory RESTAPI 406 not Acceptable

Question

DataFactory RESTAPI 406 not Acceptable

Hello,

I have a problem with the Source in DataFactory with REST API.

I get the following error:

Failure happened on 'Source' side. ErrorCode=RestSourceCallFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The HttpStatusCode 406 indicates failure. Request URL: https://xxxxx Response payload:{"type":"/doc/v1/errors#AC001","title":"The requested format cannot be returned","status":406,"identifier":"949bdf27-aa49-48b2-95f2-62914efb3bce","code":"AC001","extraInfo":{"message":"HTTP 406 Not Acceptable"}},Source=Microsoft.DataTransfer.ClientLibrary,'

When i open it with Postman or Curl i don't have any issue.

Also when i choose in DataFactory Source is HTTP then i get values from the GET request.. but my prefer get out to REST API for pagerules.

Can anybody help me?

HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-21T21:03:14.55+00:00

Hello @Robbert van der Kooi | Hestronic BV ,
Thanks for the ask and using the Microsoft Q&A platform .One difference which I can see is the default encoding which is set in HTTP but not in REST . The API which you are calling does it expect a default encoding ?

Please do let me know how it goes .
Thanks
Himanshu
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-27T18:39:34.077+00:00

Hello @Robbert van der Kooi | Hestronic BV ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-05-03T19:04:29.103+00:00

Hello @Robbert van der Kooi | Hestronic BV ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Anonymous

2021-09-11T19:11:04.717+00:00

I have exactly the same problem. I tried to add headers Accept-Language and Accept-Charset but it didn't work either. The error message just switched to french after I added Accept-Language:fr.
It would be nice to understand why it doesn't work

1 answer

Your answer

HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-21T21:03:14.55+00:00

Hello @Robbert van der Kooi | Hestronic BV ,
Thanks for the ask and using the Microsoft Q&A platform .One difference which I can see is the default encoding which is set in HTTP but not in REST . The API which you are calling does it expect a default encoding ?

Please do let me know how it goes .
Thanks
Himanshu
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-04-27T18:39:34.077+00:00

Hello @Robbert van der Kooi | Hestronic BV ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2021-05-03T19:04:29.103+00:00

Hello @Robbert van der Kooi | Hestronic BV ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Anonymous

2021-09-11T19:11:04.717+00:00

I have exactly the same problem. I tried to add headers Accept-Language and Accept-Charset but it didn't work either. The error message just switched to french after I added Accept-Language:fr.
It would be nice to understand why it doesn't work

Answer 1

I am also facing exactly the same issue.

My API works from Web activity but doesn't work from the Rest Datasource of Copy Activity.

It was working initially and after a week when I tried it suddenly it fails with error 406. If I add Http Json data source adding additional headers Content type, Ocp-Apim-Subscription-Key and Authorization with Bearer token is so difficult to format it doesn't work too.

Json data from web activity added separately is also difficult to format and pass to azure sql table.

Failure happened on 'Source' side. ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 406 NotAcceptable, please check your activity settings.

Request URL: 8***/.

Response: ,Source=Microsoft.DataTransfer.ClientLibrary,'

Share via

DataFactory RESTAPI 406 not Acceptable

1 answer

Your answer