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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Google docs XMl import help
Author
Previous Topic Next Topic
thebeastlybeast Ownsuinamarr
Dank Fitters
#1 - 2015-12-15 21:54:01 UTC  |  Edited by: thebeastlybeast Ownsuinamarr
Hi all iv been searching the internet to try find a solution to a problem i have been having when trying to import data into google docs.

what i want to achieve is to pull the Moon information from the system.

Here is the API web Page https://www.fuzzwork.co.uk/api/mapdata.php?solarsystemid=30004279&format=xml

I have the ID number and i want to pull the Itemname

E.g.

I have Item id 40270989
I want it to pull back the item name which would be Ahraghen VII - Moon 11

iv been using the importxml on google docs to pull other information but never the in way of using it to look up other information in the same webpage

The formula have been trying different variations of is

=IMPORTXML("https://www.fuzzwork.co.uk/api/mapdata.php?solarsystemid=30004279&format=xmll","//row[@itemid=40270989]/@itemname")

Any help in this matter will be much appreciated
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2015-12-16 11:13:24 UTC
=IMPORTXML("https://www.fuzzwork.co.uk/api/mapdata.php?solarsystemid=30004279&format=xml","//row[itemid='40270989']/itemname")

@ is for attributes, in this case itemid and itemname are not attributes

http://www.w3schools.com/xsl/xpath_syntax.asp was helpful :)

(and I need to add support for that to importxml2 script, works more reliably than importxml)
thebeastlybeast Ownsuinamarr
Dank Fitters
#3 - 2015-12-16 12:51:27 UTC
Thank you so much for your help much appreciated.
I will definitely read through the w3school page😀