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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Google Spreadsheet API Import
Author
Previous Topic Next Topic
Regnar Avastum
#1 - 2014-10-30 13:31:11 UTC
Hi there,

I seem to have hit a wall with a spreadsheet I'm currently working on. I am trying to simply import my wallet transactions into a google spreadsheet using something like this:

=IMPORTXML(" https://api.eveonline.com/char/WalletJournal.xml.aspx?keyID=X&vCode=X&characterID=X","/eveapi/result/rowset//row/@date")

Now, the import seems to work fine as it accurately imports my last 50 transactions. The problem is that, it only imports the last 50 transactions :)). I do not understand why this is the case since as to my understanding it should import at least the last 1000 entries.

Any ideas?

Thanks!

♔ ℜegnar's High-End Spreadsheets ♔™
Vladdy Tepes
The Scope
Gallente Federation
#2 - 2014-10-30 14:11:21 UTC
&rowCount=2560
Regnar Avastum
#3 - 2014-10-30 14:28:36 UTC  |  Edited by: Regnar Avastum
Vladdy Tepes wrote:
&rowCount=2560


Great, thanks. That seems to bring in more data, however I think I'm still missing something. I tried it with two different characters and it doesn't provide data older than 05.10. Do you know what the hard limit on import is, in rows and age?

Also, can I for example condition to only import certain data rows based on transaction type or other parameters?

Mersi :)

♔ ℜegnar's High-End Spreadsheets ♔™
Vladdy Tepes
The Scope
Gallente Federation
#4 - 2014-10-30 17:19:55 UTC
Yes, there is a date limit, not sure what it is off the top of my head.

https://neweden-dev.com/Char/WalletTransactions
Regnar Avastum
#5 - 2014-11-02 00:33:45 UTC
Vladdy Tepes wrote:
Yes, there is a date limit, not sure what it is off the top of my head.

https://neweden-dev.com/Char/WalletTransactions


Thanks mate, the link has proved useful

♔ ℜegnar's High-End Spreadsheets ♔™