why cant i fetch more then 1000 record in one call
i know this can be solved using off set but doing that it makes the job very slow. i can do off set for incremental calls once i fetch the complete data.
is there a way to fetch one time everything fast?
i'm using python to fetch and then dumping to SQL but i need to make recursive calls to fetch related line item detail. im really stuck with the time its taking for only data from September 2018 it took 12hours. if anyone can help.
You are deliberately hobbled here. Querying large amounts of data like this, especially historical data that wouldn't otherwise be cached, puts an extreme load on our server. If you use our normal API endpoints for this regularly it's likely you'll be cut off at some point.
You should probably start with a description of why you want to do what you are doing.