magicParseXML help

Hello,

 

I am running into an issue where I cannot import an XML file that contains more that one set of records. 

For example, a single record that has 3 columns imports fine:

 

var test = httprequest.get('https://www.w3schools.com/xml/note.xml')
datagrid.magicParseXML(test);

 

However, if I try to import something with multiple records it creates only one line and times out importing

var test = httprequest.get('https://www.w3schools.com/xml/cd_catalog.xml')
datagrid.magicParseXML(test);

 

I feel like I need to loop through each XML entry, but I am not sure how to do this.

 

Thanks in advance for any help. 

 

 

Comments

  • Jarvis
    Jarvis Contributor

    Hi @user05220.

    I'm not sure how you're trying to bring in the XML data, but I would recommend using the XML Advanced connector in the appstore: http://knowledge.domo.com?cid=xmladvanced

     

    The connector has options to specifiy parameters to help parse through your data more efficiently, so I think that may help you!

This discussion has been closed.