Convert XML data to Google Sheet

[hiteshkkk]

I have a API Query which returns response in XML which I wish to add as row to Google Sheets.

The responses can have multiple rows.

How do I do that?

I tired iterator but I think the response is not valid array for it.

Please guide.

 

[PabblyMember3]

Pabbly Connect already accept and simplifies the XML responses. Could you please share your workflow URL where you are getting the XML array.

 

[hiteshkkk]

This is secured access to NSE Mutual Funds platform and the URL is

https://www.nsenmf.com/NMFIITrxnService/NMFTrxnService/IINDETAILS

The response is attached in this thread.

 

[Pabblymember11]

Hey @hiteshkkk

As of now, XML is only supported on our webhook triggers and currently not available on the action events of the application.

 

[hiteshkkk]

Any ETA for the same?

 

[Pabblymember11]

Hey @hiteshkkk

We will notify you once we started supporting the XML in the action events.