May 06 2022
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?