Importing live SIMS data as XML to Google spreadsheet
I'm having real difficulties using the =importXML function on google docs.
I can import example data from wikipedia using the importHTML function no problem:
I've exported data from SIMS using the commandreporter and the plan is to use the Google Secure Data Connector to import the XML into SIMS
my sample XML is below.
Is it possible to import this data live into google docs?
I'm trying things like
but keep getting 'could not parse XML' errors.
I can use the =importdata function on the same URL, and the XML checks out to be valid so I'm not sure where I'm going wrong. Any suggestions?