Convert XML data to Google Sheet

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.

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

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.

Hey @hiteshkkk

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

Any ETA for the same?

Hey @hiteshkkk

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