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.
 

Corporation wallet Journal
Author
Previous Topic Next Topic
Balcanis
Addicted to Shljivovica
Addicted to Shljivovica Alliance
#1 - 2011-11-15 00:33:17 UTC
Hey guys

I'm not very good with this API things and how the actual comments work. I do know that I callout the members list with this command in browser:

https://api.eveonline.com/corp/MemberTracking.xml.aspx?keyID=XXXXX&vCode=XxXXXXxXXXXXXXXXXxxxxxXXxxXxxXXxXXxxx

and I know that I callout to corp journal with:

https://api.eveonline.com/corp/WalletJournal.xml.aspx?keyID=XXXXX&vCode=XxXXXXxXXXXXXXXXXxxxxxXXxxXxxXXxXXxxx

Now, I have few questions:

1. The 2nd command gives me only most recent wallet journal entries. How can I get the the older records (I believe it's 30 days or something)?

2. Is it possible to callout to specific type of journal records not all of them at once?

3. Is it possible to somehow integrate this so my excel table gets updated somehow with the latest data, so i don't have to save as xml, then import it to excel every time?

As for the first two questions I would really appreciate if you can tell me how the actual command looks like cause I don't understand much on some of the pages I read about APIs and their comments, cause there is nowhere to be seen the actual complete command example.

Thanks guys...

Visit http://en.eveonline.rs/
Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#2 - 2011-11-15 05:00:03 UTC
1) use the fromID argument and supply it with the lowest refID you have. Use this in conjunction with rowCount to pull as much info at once. More info here: http://wiki.eve-id.net/APIv2_Page_Index

2) no

3) I have no idea
Lutz Major
Austriae Est Imperare Orbi Universo
#3 - 2011-11-15 07:23:18 UTC
3) Most people don't know it, but it's possible to get a csv export. Just replace the .../WalletJournal.xml.aspx with /WalletJournal.csv.aspx. With that you can pretty easily access the data via Excel.

Balcanis wrote:
As for the first two questions I would really appreciate if you can tell me how the actual command looks like cause I don't understand much on some of the pages I read about APIs and their comments, cause there is nowhere to be seen the actual complete command example.
Please be more specific.
Sable already posted the eve-id page. It's pretty complete