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.
 

Problem importing data from eve-central into spreadsheet....
Author
Previous Topic Next Topic
LolGot Cloned
Jita Jump Junkies
#1 - 2016-11-30 12:32:46 UTC  |  Edited by: LolGot Cloned
Using Excel 2013 and trying to import lists of items (have all ItemIDs and station/system IDs I Need) from eve-central.
For the most part have most information setup but I cannot, for the life of me, figure out how to get
API pulls for items based on the Item name.
I can pull; for example;
http://api.eve-central.com/api/marketstat?typeid=34&typeid=35®ionlimit=30002187
by dropping it into Data > web in excel and get that in 2 lines... I want it dynamic to where it pulls what i search
and puts it into the appropriate fields (guessing some Vlookup for this also) so looking for
function to check a column in a sheet for item name then search for it in my itemID sheet and do something like

http://api.eve-central.com/api/marketstat?typeid=typeID!D1:D44&usesystem=30002187

So I can just put in a reference in a spread sheet with names and have the sheet populate for the particular items
i want on it.
Suggestions?
Newbie to the API sorry.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2016-11-30 14:56:01 UTC
For each item you have you should create a column which has their typeId,

The type id can be fetched most likely with =VLOOKUP(...) Not knowing what format your typeID sheet is, I cannot say what exactly you should put to VLOOKUP

For combining strings there are few possible functions
a) CONCATENATE
b) JOIN

By using JOIN & CONCATENATE & VLOOKUP you should be able to automatically build the string.
LolGot Cloned
Jita Jump Junkies
#3 - 2016-11-30 20:56:19 UTC
Ah, ok thanks thats a great lead. Appreciate it!