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

Question

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

Answer 1

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.

Answer 2

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.