# Inventory\_changes query with customer\_account\_id filter

**URL:** <https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812>\
**Category:** GraphQL API\
**Created:** [September 17, 2020, 1:35pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812 "2020-09-17T13:35:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bbarrett](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bbarrett](https://community.shiphero.com/u/bbarrett)\
**Post date:** [September 17, 2020, 1:35pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812/1 "2020-09-17T13:35:59Z")

</div>

I would like to do something like this:  
inventory\_changes(date\_from:“2020-08-01” customer\_account\_id:“12345”)

Why wouldn’t the inventory\_changes query support filtering by customer account?

Is there some other efficient way to get the adjustments for a single account? So I can avoid wasting API call credits returning Adjustments across all accounts?

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [September 18, 2020, 2:23pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812/2 "2020-09-18T14:23:32Z")

</div>

Hi @bbarrett!  
We currently don’t have this, but you could use a Bearer associated to the customer account, would that work for you?

Something like this:

```
query {
  inventory_changes(
    warehouse_id: "V2FyZWhvdXNlOjExNzkz"
    date_from: "2020-09-18"
  ) {
    request_id
    complexity
    data {
      edges {
        node {
          user_id
          account_id
          warehouse_id
          sku
          previous_on_hand
          change_in_on_hand
          reason
          cycle_counted
          location_id
          created_at
        }
      }
    }
  }
} 

```

But instead of using the 3PL User Bearer, use the Bearer from the Customer account user instead.

Let me know if this still won’t work for you.  
Thanks in advance!  
Tom

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [October 1, 2020, 2:10pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812/3 "2020-10-01T14:10:36Z")

</div>

UPDATE about this:

> The request has been approved and now is on our engineering board to be built (to be able to filter for `customer_account_id` on the `inventory_changes` query).  
> It might take some time until this gets implemented, but I will let you know as soon as I have a better ETA for it.

The reason is that using the customer bearer (as in my previous suggestion above) is not bringing back all the information needed.

Thanks again!  
Tom

---

<div class="post-metadata">

**Author:** ![kokua](https://avatars.discourse-cdn.com/v4/letter/k/9d8465/32.png) [@kokua](https://community.shiphero.com/u/kokua)\
**Post date:** [February 6, 2022, 7:13pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812/4 "2022-02-06T19:13:16Z")

</div>

@tomasw I am not seeing `customer_account_id` as a filter for `inventory_changes` implemented. Is this still planned?

Thank you

---

<div class="post-metadata">

**Author:** ![tomasfd](https://avatars.discourse-cdn.com/v4/letter/t/5daacb/32.png) [@tomasfd](https://community.shiphero.com/u/tomasfd)\
**Post date:** [February 7, 2022, 7:59pm UTC](https://community.shiphero.com/t/inventory-changes-query-with-customer-account-id-filter/812/5 "2022-02-07T19:59:02Z")

</div>

Hello @kokua!

Sadly, this hasn’t been released yet, and I don’t see it in the roadmap.

However, the workaround provided should work now. Can you let me know if this is not the case for you?

Have a great day!  
TomasFD
