CODEWITHSUNDEEP
xmlxpathgoogle-apps-scriptgoogle-sheets
BlubQ
BlubQ

Reputation: 13

Extract data from XML with ImportXML and XPath

What I'm trying to do is to extract data from this XML using Google Spreadsheets:

XML File

Now I thought that this would be an easy task and decided to use the ImportXML() function with following XPath sting:

- =IMPORTXML("https://api.eveonline.com/map/FacWarSystems.xml.aspx", "//row[@owningFactionID='500002']")

Which, in theory should return every entry in the document where the owningFactionID is 500002.

Problem is that I only get #N/A in the Google Spreadsheet (Empty).

If someone could help with what I'm doing wrong here I'd be very grateful.

Upvotes: 1

Views: 440

Answers (1)

Jordan Rhea
Jordan Rhea

Reputation: 1206

Your query is correct, but the row elements that are being returned are empty. I assume you want to see the attributes on each row. You need to use something like: 

=IMPORTXML("https://api.eveonline.com/map/FacWarSystems.xml.aspx","//row[@owningFactionID='500002']/@*")

Upvotes: 2

Related Questions