EVE Technology Lab

Hi folks,

Do you know if you can make a market call for more than one item using ESI in a single call? e.g. sell order prices for all the minerals.

I'm interested in pulling the lowest sell price materials in Jita 4-4 into my Excel 2016 spreadsheet. I know the XML API is on it's way out and i've seen Steve R's work with Google sheets, but i'm working with Excel to improve my skills in it for outside of Eve (i'm digressing), so i was looking into getting the data via the ESI. I have very little, to none, coding experience besides Excel and being exposed to SQL every so often.

Steps i've done so far:

1. Gone to: https://esi.tech.ccp.is/latest/#!/Market/get_markets_prices

2. Adjusted what i need to (order_type = sell, region_ID=10000002, type_ID = 11399) - here i'm using the type_id for morphite.

3. This gives me this:

https://esi.tech.ccp.is/latest/markets/10000002/orders/?datasource=tranquility&order_type=sell&page=1&type_id=11399

4. In Excel, i can then do a "From Web", paste that URL. It then saves as a .JSON file, which i can then actually import back into Excel for me to read.

Following on from that, i thought about pulling more items in one go by adding another "&type_id=34" to the end (in this case for trit), which would look like:

https://esi.tech.ccp.is/latest/markets/10000002/orders/?datasource=tranquility&order_type=sell&page=1&type_id=11399&type_id=34

The query runs, but when i export it back into excel i can see it's only picked the first type_id it reads, the morphite. I was then hoping to use VLOOKUPS, MINIFS etc in Excel.

Thanks for the help, advice, comments!