Export to Data Warehouse

I’m in progress of implementing my company data warehouse and I need to load the current ShipHero data into it.

I checked the REST and GraphQL APIs but they don’t provide any bulk export which means I have to do thousands of requests to can extract the data I need (all of it).

I also checked the Stitch solution but it uses the REST API and only 4 end-points.

Do you have any suggestion on how I can achieve what I need?

Hi @Dimo
So what is it exactly the info you need to extract?
Is it the inventory? In that case, would a Inventory Snapshot work for you?
Thanks in advance!

Hi @tomasw,
definitely Inventory Snapshot is one of the thinks but I also need all about “Orders” and “Purchase Orders”

Hi @Dimo
As for Orders of Purchase orders we don’t have bulk operations similar to inventory_snapshot.
For those ones you will have to iterate over them until you get all you need.
For the orders query, you could use filters like updated_at or order_date_from so that you don’t need to export them all every time.
Purchase orders also have the created_from filter.

Let me know if you need more detailed examples or there is anything I can explain better.
Thanks again!