Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Squelch
Imperial Collective Unsettled.
0
|
Posted - 2014.09.03 20:19:00 -
[1] - Quote
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. |
Squelch
Imperial Collective Unsettled.
0
|
Posted - 2014.09.03 20:19:11 -
[2] - Quote
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
14
|
Posted - 2014.11.20 05:24:27 -
[3] - Quote
=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
Federal Defense Union Gallente Federation
5
|
Posted - 2014.11.20 13:59:28 -
[4] - Quote
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
- Copy this doc: https://docs.google.com/spreadsheets/d/1IiL3qOqL6Ftyuk7Kmfk5Gfp4iprCZZx4-Y2IhrDxivk/edit?usp=sharing
- Enter your key, vcode, and the account key for the wallet you want (e.g. 1000)
- 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
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |