Azure Data Factory - Pagination rule failed

Question

Dear All,

I was trying retrieve more than 5000 records from DYNAMICS 365 CE/CRM using azure data factory via REST API. Sample records returned from the Rest call as below:

I am using the pagination rule in the Azure Data Factory. The setting as below:

However I receiving below error:

Rest call failed with client error, status code 415 UnsupportedMediaType, please check your activity settings.

Request URL: https://xxxx.xxx.xxxx.com/api/data/v9.2/$metadata#contacts

Response: {"error":{"code":"0x80060888","message":"A supported MIME type could not be found that matches the acceptable MIME types for the request."}}

How to fix it?

Answer 1

It seems like the response content type isn't supported. Supported response content type is 'application/json

As mentioned in the error, could you please check the response from other clients like your browser or POSTMAN ?

If your request includes a body (like a POST or PATCH request), make sure the Content-Type header is set correctly to match the format of the data you are sending.

Answer 2

Hi CY,

Thank you for posting query in Microsoft Q&A platform.

From error message it seems, you are not setting contentType header value as application/json. Kindly try same. Also you can take the @odata.context URL to postman and do manual api call and see if its getting response correctly.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.