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.
 

import from character standings in spreadsheet
Author
Previous Topic Next Topic
Samuel Sachs
#1 - 2017-01-16 23:26:44 UTC
Hi,

i know the xml api is not rly state of the art anymore but i still use it for many spreadsheets, atm i am working on a character information spreadsheet and have a little problem with the xpath syntax and i hope someone is knowing a solution.

=importxml("https://api.eveonline.com/char/Standings.xml.aspx?keyID=5910425&vCode=Sq68mQM4eQf9tL2vyVWVjkCq5m4GAg690vNCWkRH62skgbm08x1qs9OVd8aZz4Hd", "eveapi/result/rowset[@name='factions']/row/@standing")


"eveapi/result/rowset[@name='factions']/row/@standing")

The api call works as you can check and see below but the xpath i use here seems wrong but i have no clue why:

https://api.eveonline.com/char/Standings.xml.aspx?keyID=5910425&vCode=Sq68mQM4eQf9tL2vyVWVjkCq5m4GAg690vNCWkRH62skgbm08x1qs9OVd8aZz4Hd

The api is open for this char, its ok, just a random char i use.

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Blacksmoke16
Resilience.
#2 - 2017-01-16 23:47:37 UTC
You are missing the 'characterNPCStandings' in your xpath.

This works as well:

//rowset[@name='factions']/row/@standing
Samuel Sachs
#3 - 2017-01-17 00:18:41 UTC
Blacksmoke16 wrote:
You are missing the 'characterNPCStandings' in your xpath.

This works as well:

//rowset[@name='factions']/row/@standing



I dont understand the part with 'characterNPCStandings' but 
//rowset[@name='factions']/row/@standing
[/quote]
worked very well for me, thank you Attention

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Blacksmoke16
Resilience.
#4 - 2017-01-17 00:26:07 UTC
If you look at the structure in your original xpath.

"eveapi/result/rowset[@name='factions']/row/@standing"

The structure from outermost node to inner most is:

eveapi Arrow result Arrow characterNPCStandings Arrow rowset Arrow row

You have the eveapi and result but skipped the characterNPCStandings.
Samuel Sachs
#5 - 2017-01-18 22:39:49 UTC
Ah now i understand what you meant.

Is there a way to import LP from a char ?

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Blacksmoke16
Resilience.
#6 - 2017-01-18 23:15:14 UTC
I'm pretty sure there is a CREST endpoint for that? However i never used it so not sure if it is a thing or even implemented.

If it is you would have to get into SSO and tokens however.