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.
 

Market Transactions and Some API questions
Author
Previous Topic Next Topic
LiteralCookie
Caldari Provisions
Caldari State
#1 - 2016-11-15 14:54:00 UTC
I have been gone for about 4 years. In that time it seems the APIs I was interested in have died, or are soon to be dead.

I seem to have read somewhere that the following trade hubs exist:
Jita
Amarr
Rens
Dodixie
Hek
Tash-Murkon Prime
Oursulaert

I'm interested in finding price history/transactions for all of those locations. ie; Item Qty Sold for Y price on X time/date at Z location.

And then another I suppose.. for Buy/Sell for W Amount, X Price, Y range, at Z limit.

What's the best way to get a (current) (MySQL) database dump of every sellable item in the game?

I've been looking at ESI, however, there's no examples of usage that I can find. I like eve-central or eve-market, but from my knowledge these sources are not always accurate.

Thanks!
Althalus Stenory
Flying Blacksmiths
#2 - 2016-11-16 11:03:19 UTC  |  Edited by: Althalus Stenory
For hubs, you can see the "big ones" here for example : http://eve-marketdata.com/station.php?step=Rank

To get history, I think you'll have to loop over every items on every region you want to get the price histories.

Quote:
And then another I suppose.. for Buy/Sell for W Amount, X Price, Y range, at Z limit.

If you want the prices : https://esi.tech.ccp.is/latest/#/Market (price, history etc) for examples, it really depends on your language. But to be short as market does not need auth, you just have to query a single URL, parse the json content and enjoy.

Example with market bulk order for jita : 
https://esi.tech.ccp.is/latest/markets/10000002/orders/?order_type=all&page=1&datasource=tranquility
https://esi.tech.ccp.is/latest/markets/10000002/orders/?order_type=all&page=2&datasource=tranquility
https://esi.tech.ccp.is/latest/markets/10000002/orders/?order_type=all&page=3&datasource=tranquility
....

(You need to increment the page number, until the response is an empty list [] : 
https://esi.tech.ccp.is/latest/markets/10000002/orders/?order_type=all&page=10&datasource=tranquility


Quote:
What's the best way to get a (current) (MySQL) database dump of every sellable item in the game?

You can download the MySQL SDE conversion from Steve ( https://forums.eveonline.com/default.aspx?g=posts&t=499904&find=unread ) and import it (or only tables you need).

Then to find all items that can be on the market, just query the "invTypes" table, looking for items that have a "marketCategoryID" (not sure of the column name) and that are published, and you'll have them.

Another solution can be to query this ESI endpoint : https://esi.tech.ccp.is/latest/markets/prices/?datasource=tranquility as it contains all items adjusted price, average price (and it implies that those items exist on the market).
(IMO, the SDE solution is better).

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI