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 Pulling Corp Wallet Journal into Google Docs
Author
Previous Topic Next Topic
Squelch
Crowd Control
#1 - 2014-09-03 20:19:11 UTC  |  Edited by: Squelch
Hi,

After lots of searching, I've not been able to find the answer to this, or figure it out myself.

I want to get the Corp Wallet Journal into a google docs spreadsheet.
First up, I have setup an API key for CORP, and not character

I can put the following url into a browser and have it return the corp wallet.

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


That works. however wrapping it in an importXML in google docs just produces an N/A result.

=importXML("https://api.eveonline.com/char/WalletJournal.xml.aspx?keyID=XXXXXX&vCode=YYYYYYY")


From what I can see, I'm missing the XPath query, however I don't really know what I'm doing with that.
What I'd really like to see, is just the entries where a player has donated to the wallet (refTypeID=10), but I'll be happy just to get the corp walet to appear at all.

If anyone can help I'd be very appreciative.
Thanks
Sq.
HypoConDreAct
Shits N Giggles
#2 - 2014-11-20 05:24:27 UTC  |  Edited by: HypoConDreAct
=importxml("http://api.eveonline.com/corp/AccountBalance.xml.aspx?KeyID=XXXXX&vCode=XXXXX&extended=1", "//@balance")

this will pull all the corp wallets. Fill out the Xs with your Corp Api Key. Then you just have to work out which wallet is what. hope this helps.
maybe if you use the last part of this it may fill out the rest not sure tho
salacious necrosis
Garoun Investment Bank
Gallente Federation
#3 - 2014-11-20 13:59:28 UTC
Shameless self promo time...

If you're comfortable with a little javascript, I find this sort of thing easier with google app script, especially if you need to do some basic filtering.

TL;DR


  1. Copy this doc: https://docs.google.com/spreadsheets/d/1IiL3qOqL6Ftyuk7Kmfk5Gfp4iprCZZx4-Y2IhrDxivk/edit?usp=sharing
  2. Enter your key, vcode, and the account key for the wallet you want (e.g. 1000)
  3. Select EVE -> Retrieve data from the menu


If you want to see how it works, select Tools -> Script editor...

I commented out the line to filter for donations. You can uncomment if you want to try out filtering.

If you want to take the red pill and go further down the rabbit hole, check out:

https://www.eve-kit.org/#/main/doc/1416194988795

Use EveKit ! - Tools for EVE Online 3rd party development