May 11, 2020 09:00 PM
I’m fetching XML data text() but am running into a dead end when trying to find a way to parse the data. I tried using domparser and a few different functions I found on StackOverflow but most seem to require a non-native library. Does anyone have any suggestions on either how to parse XML in vanilla javascript or how to convert XML into JSON?
For reference when using
let parser = new DOMParser();
I get “ReferenceError: DOMParser is not defined”
May 11, 2020 09:20 PM
maybe try a simple function like this:
/**
* Simple XML parser
* @param {String} xml
* @return {Object}
*/
function parseXML(xml) {
var beg = -1;
var end = 0;
var tmp = 0;
This file has been truncated. show original
May 13, 2020 07:22 AM
That worked for me once I realized it was parsing it into an object where I could use keys to get what I need. Thanks!
Sep 23, 2020 11:08 AM
I found that this function doesn’t always parse data from the XML correctly, especially if there are characters like ‘<’ in the data itself.
Do you have any other recommendations on how to parse XML using another method?
Oct 24, 2022 06:46 AM
For anyone from Google, you can try using the free Data Fetcher extension to import a remote XML file to Airtable.