'In Azure Data Factory how to read XML response

As I am new to ADF, looking for the right way to read/accept XML response from an API.

Tried the following activities using copy activity,

  • Rest, linked service. Linked service connection is successful but while previewing the error, enter image description here

  • HTTP, linked service. Linked service connection is successful but while previewing the error, enter image description here

  • OData, linked service. failed to connect to the linked service Error: Failed to create odata connection to RequestUrl. enter image description here

It would be helpful if someone could share a doc or reference on how XML API response can be consumed in the ADF.

apiodataazure-data-factorycopy-activity


Solution 1:[1]

As per official documentation, REST connector only support response in JSON.

enter image description here

EDIT -

Unfortunately XML response is not supported. You can use an ADF Custom activity to transform the XML programmatically.

Refer - https://social.msdn.microsoft.com/Forums/azure/en-US/68c41a5d-4cd3-4f61-8cbf-c9d86909ce80/adf-v2-pull-from-rest-api-that-returns-xml?forum=AzureDataFactory

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions