Azure Data Factory copy data from REST API fails

Emerson Fernandes da Silva 6 Reputation points
2021-11-17T19:40:20.637+00:00

I’m trying to copy data from a REST API. I’m using Self-Hosted integration runtime and the API referenced is located inside an on-premises network.
I got “Connection successful” when “Test Connection” for linked service (REST), although it takes about 2 minutes.
But I’ve got error running copy data activity.
Error code: 2200
Failure type: User configuration issue
Details: Failure happened on 'Source' side. ErrorCode=UserErrorInvalidPaginationRule,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Invalid PaginationRule, RuleKey=supportRFC5988, RuleValue=true,Source=Microsoft.DataTransfer.ClientLibrary,'

No problem calling same API from browser using Swagger.

Any clue?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,263 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. svijay-MSFT 5,241 Reputation points Microsoft Employee
    2021-11-18T10:34:52.517+00:00

    Hello @Emerson Fernandes da Silva ,

    Thanks for the question and using MS Q&A platform.

    Looking at the error - it looks like you have defined the pagination rule and the pagination rule appears incorrect.

    150624-image.png

    From the error again - the erroring key appears to be supportRFC5988 - Have you set the pagination rule for your copy activity at your end ?

    150587-image.png

    Update :

    If the above is not the case, from my research - it appears there was an issue with similar behavior in the older version of the self hosted integration runtime (SHIR). Request you to update to a recent version of the SHIR and check the behavior at your end.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.