Azure Data Factory Copy Activity Only Importing First Row of XML file

49 Views Asked by At

I have an XML file that I am importing into a SQL table using an Azure pipeline data copy activity. The file imports fine, but only imports the very first row into the SQL table. It does not import all the records

XML file example

Mapping as follows:

Copy Activity Mapping

I have done some research and according to one forum, the mapping syntax should be changed.
Currently the mapping is

$['queues']['queue'][0]['Field'][0]['value']

It is suggested the the mappings are changed to reference the actual field name.

$['queues']['queue'][0]['@queue_date'][0]['value']

This does not rectify the issue. Only the first record in the XML file imports.

0

There are 0 best solutions below