Azure Data Factory - Pagination rule failed

CY 0 Reputation points
2023-11-26T14:38:59.1066667+00:00

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:

Screenshot

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

paging

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,674 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,148 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 19,706 Reputation points
    2023-11-27T19:29:05.92+00:00

    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.

    0 comments No comments

  2. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2023-11-29T06:02:11.5466667+00:00

    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.