Picks_per_day query returning empty inventory_bin field

GraphQL API
1

Hello!

In the picks_per_day query, inventory_bin field is available to include in the results, but I see it always returns an empty string.

If I go to the dashboard > manage orders and check a fulfilled order, I can scroll to the bottom and see the pick location for each item in the tote there, but I need to be able to get at this information en masse so that I can build a picking heat map for our warehouse.

Thanks!

2

Hi Jeremy,
Can you show me the query that your sending?

3 
    query($start_ts: ISODateTime, $end_ts: ISODateTime, $cursor: String, $record_count: Int) {
    picks_per_day(date_from: $start_ts, date_to: $end_ts) {
        request_id
        complexity
        data(after: $cursor, first: $record_count, sort: "created_at") {
            pageInfo {
                hasPreviousPage
                hasNextPage
                endCursor
            }
            edges {
                cursor
                node {
                    id
                    user_first_name
                    user_last_name
                    order_number
                    sku
                    picked_quantity
                    inventory_bin
                    barcode_scanned
                    created_at
                }
            }
        }
    }
}
4

Please send a request id to dig into this further.

5

Hi Theresa,

That exact query is actually embedded in a script that doesn’t save the request ID when it’s done. Below is one that’s slightly different (not using the variables, mainly) and it came back with the following request ID: 60a275e931b388a4819f5080

query {
    picks_per_day (date_from:"2021-05-17", date_to:"2021-05-20") {
        request_id
        complexity
        data (first:100) {
            pageInfo {
                hasPreviousPage
                hasNextPage
                endCursor
            }
            edges {
                cursor
                node {
                    id
                    user_first_name
                    user_last_name
                    order_number
                    sku
                    picked_quantity
                    inventory_bin
                    barcode_scanned
                    created_at
                }
            }
        }
    }
}
6

Hi Jeremyw,
I did some tests and was consistently getting the same results. I am getting a colleague to review this, it may be bug.

1 Like