# What information can I pull

**URL:** <https://forums.eveonline.com/t/what-information-can-i-pull/355252>\
**Category:** Third Party Developers\
**Created:** [March 24, 2022, 4:30pm UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252 "2022-03-24T16:30:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Giddy\_McFee](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/giddy_mcfee/32/375711_2.png) [@Giddy\_McFee](https://forums.eveonline.com/u/Giddy_McFee)\
**Post date:** [March 24, 2022, 4:30pm UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/1 "2022-03-24T16:30:04Z")

</div>

Not that I know yet how to obtain details from the back end, but is there are locaiton/place/website that can tell me in laymans terms what kind of info i can fetch from eve database. I have spreadsheets for example that can pull prices. but i wanted to see what other info could be pulled to see if i can make use of it

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [March 24, 2022, 4:32pm UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/2 "2022-03-24T16:32:12Z")

</div>

See Swagger reference here [EVE Swagger Interface](https://esi.evetech.net/ui/)

Issues go here [Issues · esi/esi-issues · GitHub](https://github.com/esi/esi-issues/issues)

Swagger spec here [https://esi.evetech.net/latest/swagger.json](https://esi.evetech.net/latest/swagger.json) (we typically generate language bindings).

Also ESI uses OAuth2 (unfortunately) for authorization, not API keys.

---

<div class="post-metadata">

**Author:** ![Giddy\_McFee](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/giddy_mcfee/32/375711_2.png) [@Giddy\_McFee](https://forums.eveonline.com/u/Giddy_McFee)\
**Post date:** [March 24, 2022, 4:40pm UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/3 "2022-03-24T16:40:25Z")

</div>

All looks very complicated, but looking at the list of things I can pull in swagger, i don’t think what I want to do is there which is determining how much of a given item is sold other a defined period (day, week etc). and also listing items between a set price range.

Ie all items sold a minmum of 2 units between 10 and 40million ISK sold in Jita over yesterday

---

<div class="post-metadata">

**Author:** ![Golden\_Gnu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/golden_gnu/32/459734_2.png) [@Golden\_Gnu](https://forums.eveonline.com/u/Golden_Gnu)\
**Post date:** [March 25, 2022, 6:42pm UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/4 "2022-03-25T18:42:24Z")

</div>

`/markets/{region_id}/orders/` Let you get all orders in EVE, by region (with some limitations to orders in structures). The only filter is typeID. Do note that using typeID is slower when you’re getting ~10 or more items.

`/markets/{region_id}/history/` have history stats.

If you’re using Google sheets, you can use GESI, to make everything a lot easier:

> **[GitHub - Blacksmoke16/GESI: Google Sheets™ ESI Add-on](https://github.com/Blacksmoke16/GESI)**
>
> Google Sheets™ ESI Add-on. Contribute to Blacksmoke16/GESI development by creating an account on GitHub.

There is also some documentation for ESI:

> **[ESI Documentation](https://docs.esi.evetech.net/)**
>
> The official repository for ESI documentation

There may also be a program that already does what you want:

> **[GitHub - devfleet/awesome-eve: A list of 3rd party Applications and Tools for...](https://github.com/devfleet/awesome-eve)**
>
> A list of 3rd party Applications and Tools for the awesome Eve Online MMO. - GitHub - devfleet/awesome-eve: A list of 3rd party Applications and Tools for the awesome Eve Online MMO.

---

<div class="post-metadata">

**Author:** ![Giddy\_McFee](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/giddy_mcfee/32/375711_2.png) [@Giddy\_McFee](https://forums.eveonline.com/u/Giddy_McFee)\
**Post date:** [March 26, 2022, 8:32am UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/5 "2022-03-26T08:32:38Z")

</div>

Thank you for the links ill check them out

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [June 24, 2022, 8:33am UTC](https://forums.eveonline.com/t/what-information-can-i-pull/355252/6 "2022-06-24T08:33:20Z")

</div>

Closed on June 24, 2022, 8:33am UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
