EVE Technology Lab

 
 

[HELP] Google sheet & Corp Wallet

Author
#1 - 2017-05-13 15:42:14 UTC
Is there any way to import a corporation wallet into a google sheet

What im wanting to do is

Get Wallet Balance for each wallet
Transactions and who made them


Any help would be great
#2 - 2017-05-13 17:12:46 UTC
Yes. You can use the old XML API for this until the features are added into ESI.

This will list the accountKeys for each wallet where 1000 is master wallet.
=IMPORTXML("https://api.eveonline.com/corp/AccountBalance.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE","//row/@accountKey")


This will list the balance for each wallet.
=IMPORTXML("https://api.eveonline.com/corp/AccountBalance.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE","//row/@balance")


So to use this you would have the first one in one column, then the other in the column next to it. The first column would have each account key then the second would show the balance for that wallet division.

For the transactions you can use the same method but with the walletTransactions endpoint. Docs are found here:
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/character/char_wallettransactions.html

Example to get the transaction Datetime of each transaction in the master wallet would be like:
=IMPORTXML("https://api.eveonline.com/corp/walletTransactions.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE&acountKey=1000","//row/@transactionDateTime")


Can use the docs and figure out how you want to set it up.


#3 - 2017-05-14 08:24:47 UTC
Perfect thanks
Forum Jump