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.
 

Need help with ImportXML and google docs
Author
Previous Topic Next Topic
Sakuma Ogunuchi
#1 - 2012-06-17 03:31:42 UTC
Hello!

I'm trying to make a spreadsheet that adds up all the sales my corp has made in a given month. The problem is I'm not so savvy on Xpath.

I tried:

=Importxml("http://api.eveonline.com/corp/WalletTransactions.xml.aspx?keyID=123&vCode=123abc&characterID=123&rowCount=2000","eveapi/result/rowset/row[transactiontype=sell]")

But what i get is an error saying query did not return any data. What am I doing wrong?

Thanks in advance,
Sakuma.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-06-17 04:49:46 UTC
Sakuma Ogunuchi wrote:
Hello!

I'm trying to make a spreadsheet that adds up all the sales my corp has made in a given month. The problem is I'm not so savvy on Xpath.

I tried:

=Importxml("http://api.eveonline.com/corp/WalletTransactions.xml.aspx?keyID=123&vCode=123abc&characterID=123&rowCount=2000","eveapi/result/rowset/row[transactiontype=sell]")

But what i get is an error saying query did not return any data. What am I doing wrong?

Thanks in advance,
Sakuma.



First, use https, not http. Just good practice to use it, when it's available.

Then, stick a slash on the front of the xpath, an @ before the attribute name, and quote the value.
/eveapi/result/rowset/row[@transactionType='buy']


Might do what you want.


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Sakuma Ogunuchi
#3 - 2012-06-17 05:18:49 UTC
It still gets a query did not return any data. Will continue banging my head against it.