@alpabuddhabhatti Thank you for the clear explaination, i have a similar requirement with complex XML with multiple array type in it could you please explain how to deal in the case when we have multiple arrays in the XML payload
Hi Pratap, that's ok to have multiple array. You need to use branch task for each array and unrolled array and then you can union then if you needed or store separately in different table or file .
@@alpabuddhabhatti-Thank you for the clear explaination, i have a similar requirement with complex XML with multiple array type in it could you please explain how to deal in the case when we have multiple arrays in the XML payload
Hi, thanks for your video. The only thing it doesn't explain is how to ensure the Flatten component has multiple layers - can you advise on this please? I've added extra unroll layers but it I still only have one flatten component.
@@alpabuddhabhatti Hey thanks for coming back, I actually managed to fix it. By adding 2 extra Sinks, I was able to see the extra Flatten components as expected.
Hi @avinashnadimpalli1044, XML or XLSX as sink is not possible directly using ADF. However you can use Custom Activity such as Azure Function or Python with ADF for that. 2 days ago
@@alpabuddhabhatti I have sent an email.Kindly check. Also could you please provide your thoughts on below. How to handle below kind of kind in ADF, I am getting xml files from source as below I am unable to do mapping for these fields as they are attribute id's and also want to send only few fileds to rest api in Sink. Could you please provide your inputs here.
@alpabuddhabhatti
Thank you for the clear explaination, i have a similar requirement with complex XML with multiple array type in it could you please explain how to deal in the case when we have multiple arrays in the XML payload
Hi Pratap, that's ok to have multiple array. You need to use branch task for each array and unrolled array and then you can union then if you needed or store separately in different table or file .
if you need more information then let me know.
Thanks for sharing. Very handy.
I am glad to know that Ferruccio Guicciardi
Very Useful 👌
Thank you sykam reddy
@@alpabuddhabhatti-Thank you for the clear explaination, i have a similar requirement with complex XML with multiple array type in it could you please explain how to deal in the case when we have multiple arrays in the XML payload
Hi, thanks for your video. The only thing it doesn't explain is how to ensure the Flatten component has multiple layers - can you advise on this please? I've added extra unroll layers but it I still only have one flatten component.
Thank you for questions. I did not get your point. Can you please give an example or email me with sample file and your desired output?
@@alpabuddhabhatti Hey thanks for coming back, I actually managed to fix it. By adding 2 extra Sinks, I was able to see the extra Flatten components as expected.
Have you done anything like Json to XML in ADF ? If yes please share how to do
Hi @avinashnadimpalli1044, XML or XLSX as sink is not possible directly using ADF. However you can use Custom Activity such as Azure Function or Python with ADF for that.
2 days ago
@@alpabuddhabhatti Thankyou for your response.Really helpful.If possible can you help with blogs or videos if you have done any
Sure @@avinashnadimpalli1044. Can you please schedule a 15-30 minutes team meeting and you explain your scenarios. I will try to help you.
@@alpabuddhabhatti I have sent an email.Kindly check. Also could you please provide your thoughts on below.
How to handle below kind of kind in ADF, I am getting xml files from source as below I am unable to do mapping for these fields as they are attribute id's and also want to send only few fileds to rest api in Sink. Could you please provide your inputs here.
MISS
ANJINA
PURJA
@@avinashnadimpalli1044 - it is possible. May be you have done some small mistake. I have just replied to your Email.