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] How to import Current Balance?
Author
Previous Topic Next Topic
Battle On
Jita Exiles Productions
Goonswarm Federation
#1 - 2012-11-25 20:44:55 UTC  |  Edited by: Battle On
Hi,

I wanna start experimentating with the API stuff and google docs but every time go to

=ImportXML("https://api.eveonline.com/char/AccountBalance.xml.aspx?keyID=123&vCode=123&characterID=123", "/eveapi/result/rowset/row[@balance]")

to see my information, but all i get is the basic "XML does not return info" error.

Please someone help?



Its a valid key and code, the "123" are just to protect my personal info.

Please someone help
Best Regards,
Battle On

Jita Exiles Productions is RECRUITING

Join -JXT- Public for more information
Rene Krych
Gemeinschaft interstellarer Soeldner
#2 - 2012-11-27 02:26:32 UTC
Battle On wrote:
Hi,

I wanna start experimentating with the API stuff and google docs but every time go to

=ImportXML("https://api.eveonline.com/char/AccountBalance.xml.aspx?keyID=123&vCode=123&characterID=123", "/eveapi/result/rowset/row[@balance]")

to see my information, but all i get is the basic "XML does not return info" error.

Please someone help?



Its a valid key and code, the "123" are just to protect my personal info.

Please someone help
Best Regards,
Battle On


I would do it this way:

ʺ//rowset[1]/row/@balance"

Anyways, your fault is your xpath. With row[@balance], you "search" a row that has the item "balance", but do not say what item you want to read out.

...... row/@balance fixes it.
Battle On
Jita Exiles Productions
Goonswarm Federation
#3 - 2012-11-27 08:55:23 UTC
Rene Krych wrote:
Battle On wrote:
Hi,

I wanna start experimentating with the API stuff and google docs but every time go to

=ImportXML("https://api.eveonline.com/char/AccountBalance.xml.aspx?keyID=123&vCode=123&characterID=123", "/eveapi/result/rowset/row[@balance]")

to see my information, but all i get is the basic "XML does not return info" error.

Please someone help?



Its a valid key and code, the "123" are just to protect my personal info.

Please someone help
Best Regards,
Battle On


I would do it this way:

ʺ//rowset[1]/row/@balance"

Anyways, your fault is your xpath. With row[@balance], you "search" a row that has the item "balance", but do not say what item you want to read out.

...... row/@balance fixes it.


Thank you, this fixed it! =D
do you perhaps have a page where all these syntax is explained? (W3 or something)?
Because i couldnt find it anywhere..

Best Regards,
Battle On

Jita Exiles Productions is RECRUITING

Join -JXT- Public for more information
Rene Krych
Gemeinschaft interstellarer Soeldner
#4 - 2012-11-27 12:40:09 UTC