Forum Discussion

KBD's avatar
KBD
Helper III
1 year ago
Solved

pipeline Copy Activity JSON file with multiple documents - Mapping

Hello All:   I am making no progress on this issue so I will put out to you good folks. We are in this situation because Data Factory has issues with attributes that start with special characters....
Need Help
Pipeline
  • justinjbird's avatar
    justinjbird
    1 year ago

    Wasn't clear from your description where you intend to send the data or what your specific issue was. But I attempted this using the example file and send it to a lakehouse table.

     

    You have to set set up a collection reference which is the array you want to iterate over. In your structure that would be `$['value']` from there you map the columns relative to the collection path. Screenshot of my mapping...

     

     

    27 rows copied from the example file...

     

    If you are trying to send it somewhere else should be similar principle. Note in the example I also added an additional column `runDTS` for debug.

     

     

     

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi KBD 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

 

Thanks and regards