Loop xml files content to pipeline variable and pass to azure function in each iteration

sankon437 1 Reputation point
2022-08-11T14:54:34.46+00:00

Loop xml files content to pipeline variable and pass to azure function as body in each iteration.

Look up activity has some size limitation, thats one issues i am dealing with and it is modifying the xml content when passed to azure function.

whats the best approach

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,515 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-08-12T16:24:07.86+00:00

    Hi @sankon437 ,

    Thanks for posting query in Microsoft Q&A Platform.

    Since data is in file we should consider using Lookup activity to read data from it. and then pass that data to Foreach activity to iterate over it. Inside Foreach activity you can use azure function.

    What kind of issue you are facing? kindly same your sample file data also implementation details along with error details so that we can try to reproduce and help better.


  2. sankon437 1 Reputation point
    2022-09-21T16:47:25.407+00:00

    Sorry late reply, i had issues replying to my own thread, lookup activity is not much helpful it is adding extra text which Azure function is not liking, we went with alternate approach of handling differently. Thanks for your suggestion.

    0 comments No comments