Azure Data Factory copy data from REST API fails

Emerson Fernandes da Silva 1 Reputation point

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.
6,706 questions
No comments
{count} votes

1 answer

Sort by: Oldest
  1. svijay-MSFT 5,121 Reputation points Microsoft Employee

    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.


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


    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.