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.
 

Pulling Corp Assets VIA API Call
Author
Previous Topic Next Topic
Adonis Helios
Everlasting Forge
#1 - 2012-05-17 20:40:05 UTC
Hey everyone,

First, sorry if this thread exists already. I did a quick search, didn't find anything, and wanted to start the thread before leaving work.

I'm interested in trying to pull Corp Data via an API call to a spreadsheet.
I've been doing API calls successfully from Eve-Central to the spreadsheet so I'm not a COMPLETE noob.

My end goal is to have the corp minerals, salvage, etc. from a station office in game imported into the spreadsheet to be used in formulas etc.

I'd appreciate any help anyone is able to give.
Louis Vitton
Viziam
Amarr Empire
#2 - 2012-05-18 07:42:35 UTC
Adonis Helios
Everlasting Forge
#3 - 2012-05-18 14:07:53 UTC
Louis Vitton wrote:
http://wiki.eve-id.net/APIv2_Page_Index


Thank you for the reference.

I'm trying to make the url to pull the data.

so far i've got

https://api.eveonline.com/corp/AssetList.xml.aspx?userID=XXXXXX&apikey=XXXXXXXXXXXXXXXXXX&characterID=XXXXXXXX

I'm still getting an authenticiation error.
Can anyone see where i'm going wrong here?

I'm using this site as reference now.
http://wiki.eveonline.com/en/wiki/EVE_API_Corporation_Asset_List
Desmont McCallock
#4 - 2012-05-18 14:14:49 UTC  |  Edited by: Desmont McCallock
Use new CAK syntax https://api.eveonline.com/corp/AssetList.xml.aspx?keyID=XXXXXX&vCode=XXXXXXXXXXXXXXXXXX&characterID=XXXXXXXX

P.S. Personally, till CCP pulls the plug on the Legacy API keys, I'm not going to update any wiki.
Adonis Helios
Everlasting Forge
#5 - 2012-05-18 14:32:58 UTC  |  Edited by: Adonis Helios
Desmont McCallock wrote:
Use new CAK syntax https://api.eveonline.com/corp/AssetList.xml.aspx?keyID=XXXXXX&vCode=XXXXXXXXXXXXXXXXXX&characterID=XXXXXXXX

P.S. Personally, till CCP pulls the plug on the Legacy API keys, I'm now going to update any wiki.


Thank you VERY much, that worked and it's not retrieving the asset list.

I've been trying to filter it out via parameters. Essentially I want to use this API call to create a table of the minerals we have at a specific corp office.

I've used the above url as suggested and added the following:
?typeid=34&locationid=30001216

(30001216) being a solar system ID

When I try this it keeps pulling the entire asset list. Is there any way to filter out the information it pulls?
Adonis Helios
Everlasting Forge
#6 - 2012-05-18 15:26:27 UTC
I found a way to just filter the data via Excell

If anyone is aware of filtering the imported asset data though I'd be interested in hearing it.

Thanks Desmont McCallock for the help.
Andy DelGardo
#7 - 2012-05-19 12:51:43 UTC
Adonis Helios wrote:
I found a way to just filter the data via Excell

If anyone is aware of filtering the imported asset data though I'd be interested in hearing it.

Thanks Desmont McCallock for the help.


U can try import the whole asset list to excel and than use VLookup and SumIFS to count and lookup specific regions, items.

bye Andy
Desmont McCallock
#8 - 2012-05-19 13:16:24 UTC
Adonis Helios wrote:
I found a way to just filter the data via Excell

If anyone is aware of filtering the imported asset data though I'd be interested in hearing it.
Just FYI, no CCP API call supports filtering via parameters.
Adonis Helios wrote:

Thanks Desmont McCallock for the help.
You are welcome.