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.
 

Looking for a Range function/call
Author
Previous Topic Next Topic
Jaseac
Ghost of Shadow Union
#1 - 2017-02-21 03:25:01 UTC
Trying to import data to excel, however am stuck at the 10,000 line limit. How do i pull the rest of the items past that 10,000 mark?
Jaseac
Ghost of Shadow Union
#2 - 2017-02-21 03:56:56 UTC
Meaning like 30000-45000, Seems kind of pointless to be able to only see the item info up to 10000 lines. There must be a way to get it all.
YeuxVerts Belle
Royal Amarr Institute
Amarr Empire
#3 - 2017-02-21 08:42:36 UTC
If you're asking about the market orders and/or market history, both of them are page-split in both ESI and CREST, and i think they're split by pages of 10k items (might be 30k for CREST on market orders, but i'm not sure).
To pull the next page, find the correct syntax for the URL to call it another time. Out of the top of my head, you just call the URL again like this : [URL]&Page=2

The reason it doesn't return everything in one page is fairly simple : it's too much to handle on both the client and server side. Particularly the server.

The above message presents my opinions on the topic at hand. If there is a conflict between my views and reality, consider reality to be correct until proven otherwise.
Jaseac
Ghost of Shadow Union
#4 - 2017-02-21 14:34:57 UTC
adding &page=2 didn't work for eve-markets. The website doesn't say how to pull the next page, it just says it caps at 10k. The person running the page also doesn't respond to messages