API connection for archived orders

Retired Boards Appdev Customers Discounts And Orders
1

Hi,

At this moment I’ve setup and API connection for importing my orders into an excel sheet.

But what I noticed is that when an order is archived it’s not visible.

That why I would like to setup a connection where I can view in excel all the orders with the different status (open, archived, cancelled, …)

Is their someone who can help me with this?

Thanks,

2

Hey @SestraFood

Thanks for getting in touch! If you’re looking for archived orders, in REST you could call a GET for example to orders.json?status=closed which would give you a store’s orders that show as ‘archived’ in the Shopify Admin. There’s a closed_at timestamp present on the orders object too. Feel free to check out the docs here that will show you what status(s) you can GET. Hope that helps!

3 Likes
3
Show More

Thanks for the feedback. Instead of ‘closed’ I know used ‘any’ and looks that all orders are shown now.

4

Now I can see all the orders but it’s limited to 50 records. I’ve tried several options with adding ‘limit’ to the url but nothings seems to work.

Is their also a solution for how I can extend this qty to all?

5

For retrieving more than 50 orders, you can use the pagination of REST API and link more pages to your current page.
Refer here LINK