Azure Data Factory copy data from REST API fails

Emerson Fernandes da Silva 1 Reputation point
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.
6,706 questions

1 answer

Sort by: Oldest
Most helpful Newest Oldest
  1. svijay-MSFT 5,121 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.