Skip to main content

Order count using API

  • Nov 10, 2022 6:17 PM UTC
  • 2 replies
  • 0 views

Hello,

I would like to simply retrieve some aggregated order data, things like counts by status etc.  Is this possible to do without retreiving all of the order data?  This data appears at the end of the order queries, but we dont want all the accompanying individual order data.  It seems like a waste to get it all when we only want the counts.

 

We're using the query...

https://ssapi.shipstation.com/orders?orderStatus=awaiting_shipment

....and just want the number outstanding.

 

Looking through the API documentation this doesnt seem possible?  Has anyone come across a workaround?

 

Thanks!

2 replies

Moderator-Davis

Hey there @InkSmith, 

 

Thanks for becoming a community member! We are so happy to have you join us. 

 

If anyone has a workaround they are already using, I would love to hear it! That sharing of knowledge is the biggest strength of this community as a whole! 

 

If you are still in search for answers, you can also reach out to our api support team here at ShipStation at apisupport@shipstation.com. They will be happy to provide any clarifications they can. 

 

Happy shipping! 

From Moderator Davis, May the force be with you!
yohei
  • yohei
  • Nov 14, 2022 8:45 PM UTC

Hi!

You can set the "pageSize" to 1, and you'll only get back one order in the body of the request, while still getting the total value. Not ideal, but it's something.

 

So something like 

https://ssapi.shipstation.com/orders?orderStatus=awaiting_shipment&pageSize=1

 

Terms & ConditionsAccessibility statement