Picks_per_day filter by order_id and get user_id

GraphQL API
1

How can I retrieve picker (user_id) information for each order using picks_per_day when it does not include user_id or order_id filters?

I am using your reporting API and I noticed an inconsistency between packs_per_day and picks_per_day that blocks a use case we have.

packs_per_day accepts both user_id and order_id:

packs_per_day

Arguments
- warehouse_id: String
- user_id: String
- order_id: String
- order_number: String
- date_from: ISODateTime
- date_to: ISODateTime
- analyze: Boolean

But picks_per_day does not accept user_id or order_id at all:

picks_per_day

Arguments
- warehouse_id: String
- date_from: ISODateTime
- date_to: ISODateTime
- analyze: Boolean

My goal is to get, for a given order_id, who picked what, i.e.:

  • user_id → the picker

  • order_id → the order they were picking for

However:

  • picks_per_day has no user_id or order_id filters.

  • The tote → picks level also does not expose user_id, so I cannot reconstruct this by joining on tote either (at least not with the fields I see exposed).

I do not want to pull a huge time window each time I want to get the picks for a specific order. This is to display live picker data through web socket after a shipment.

1 Like
2

I’ve asked for this feature a while back already: Best way to find the Picker of a shipment

3

Hello,

You are correct that the API does not currently accept user_id or order_id as arguments in the picks_per_day query, the only way to accomplish this is by pulling all of the data and filtering the results downstream from the response. I can submit product feedback for review as a feature request for this improvement in the future.

Thanks

4

Hey Nathan, I am looking at this as well. And adding this feature will help us.

Please update us on this.

1 Like