Mapping of XML file in Azure Data Factory

Occasional Contributor


I'm trying to do mapping of XML file from HTTP connector in Azure Data Factory, now the issue is that in a single column some rows are there as an Object and others as a node.

1st screen shot


2nd screen shot



Here, in 1st screen shot the customer-work-region is an object and in the another one it is a node.

If we do the mapping according to one case, then we get an error and if we select "Skip Incompatible Rows"  we are loosing some data.


So is there any other way by which we can get data without any data loss?

0 Replies