API call limitations

I have found I can reliably, and without impact retrieve all I need from API similarly to this :

All rows are returned in order newest first, oldest last as I understand.

  1. Set the API size/qty of rows you would like to retrieve in a single request.
  2. Retrieve them. Push them to a local db along with veeqo order IDs. Pause for 6 seconds at least, to keep leaky bucket happy.
    Repeat 2 above until you have all rows stored locally.

Some time later, hourly or daily, etc…
When you need to pull newly added Veeqo rows, get the highest veeqo order ID from your local DB.
Repeat steps 1 and 2 above but stop when your API return set contains the veeqo row with the highest Veeqo order ID according to your local DB.

I hope that helps a little.