These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

My EVE

 
  • Topic is locked indefinitely.
 

Anyone Familiar with Google Sheets?

Author
Niska Delor
Special Technical Operations
#1 - 2015-03-23 05:01:43 UTC
I'm trying to create a list of item types dropped or destroyed in a system and import the data into Google Sheets.

The following API is my starting point, and it works well enough when I post it into my browser:
https://zkillboard.com/api/system/30001161/no-attackers/group/26/pastSeconds/604800/xml/

That api lists all cruisers destroyed in HED-GP in the last week.

What I need help with is the xpath arguments for the Google sheets function, "IMPORTXML" to list the items dropped, which I believe are in the element "row" and the attribute "typeID".

I've been trying this, but it doesn't work:

=IMPORTXML("https://zkillboard.com/api/system/30001161/no-attackers/group/26/pastSeconds/604800/xml/", "//row/@typeID")

I reviewed the tutorial here, http://www.w3schools.com/xpath/xpath_syntax.asp, but it doesn't work even when I insert wild cards into the arguments to parse. I either get a message stating that I could not fetch the URL, or it says it can't parse the data.

Can anyone tell me why this isn't working and what I need to do to fix it?

Thank you.