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.
 

/char/WalletJournal.xml.aspx

First post
Author
Previous Topic Next Topic
ISquishWorms
#1 - 2012-01-03 04:29:20 UTC
Trying to use this API to pull out data so I can calculate the amount of tax that I have paid since 2011-10-14 but when I use this API it will only provide me data as far back as 2011-12-03. I have tried using and messing around with the rowCount variable and also the fromID but if I specify say a fromID for example 5 rows prior to the last row that I can get data for I simply get a duplicate of the last 5 rows and nothing beyound 2011-12-03.

Any help would be appreciated thanks.

‘No, this isn't it at all. Make it more... psssshhhh’.
CCP Prism X
C C P
C C P Alliance
#2 - 2012-01-03 09:23:26 UTC
Both the wallet and transaction journals only allow you to go back a full month per their design. Blink

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
ISquishWorms
#3 - 2012-01-03 11:51:55 UTC  |  Edited by: ISquishWorms
CCP Prism X wrote:
Both the wallet and transaction journals only allow you to go back a full month per their design. Blink


Thanks CCP Prism X for the explanation so is there any other way to get this data out of game? As in game you can go back futher on the wallet journal and I wish to take all the tax and total it all up using MS Excel.

Thanks.

Reading more about this API I found this:

Journal Walking
The journal is configured to provide up to one month worth of data. Since each request returns at most 2560 entries, you can walk forwards and backwards in the journal to retrieve more entries.

Note: The rows in the result are mostly from "new to old". But CCP doesn't sort the results, so the return order of MSSQL is "undefined". You need to sort it yourself. (i.e. the bottom row is NOT ALWAYS the id, you wanna use for walking)

Is it possible to walk backwards to retrieve data older than a month? Guess not Cry

‘No, this isn't it at all. Make it more... psssshhhh’.