# How to get all totes
**URL:** https://community.shiphero.com/t/how-to-get-all-totes/2678
**Category:** GraphQL API
**Created:** [November 9, 2023, 3:27pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678 "2023-11-09T15:27:41Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@cschouten](https://community.shiphero.com/u/cschouten)
#### Post date: [November 9, 2023, 3:27pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/1 "2023-11-09T15:27:41Z")
Hi there,
I’m trying to get tote information based upon a order\_line\_item barcode, but I’m getting null in my response. Am I doing something wrong?
Here’s the request I made: `654cf9791489a209562862e5`.
We’re looking to create a table on our end called `tote`, which would contain the tote’s “id”, “name”, and associated “warehouse\_id”. Are there any recommendations on how to get this data from the GraphQL API?
All the best,
Colin
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [November 9, 2023, 5:47pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/2 "2023-11-09T17:47:01Z")
Hey @cschouten,
Thanks for reaching out!
I’ll take a look at this inquiry and get back to you.
Please let me know If you have any questions or concerns in the meantime.
Best,
RayanP
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [November 10, 2023, 4:13pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/4 "2023-11-10T16:13:31Z")
Hey @cschouten,
Thanks for hanging in there!
We’re still investigating this issue, but I wanted to confirm something. Are you looking to build a table with the complete list of totes? Or just totes that have current picks?
Best,
RayanP
---
### Author:  [@cschouten](https://community.shiphero.com/u/cschouten)
#### Post date: [November 10, 2023, 4:29pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/5 "2023-11-10T16:29:21Z")
We’re looking to build a table with the complete list of totes.
All the best,
Colin
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [November 13, 2023, 3:25pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/6 "2023-11-13T15:25:00Z")
Hey @cschouten,
Thanks for hanging in there!
I wanted to provide you with a quick update here.
I believe the barcode needed in the tote query is that specific tote’s barcode. We want to see if this information is attainable via the Public API.
It is possible to get all of the tote barcodes from the webpage via CSV if that option works for you.
Please let me know if you have any questions or concerns.
Best,
RayanP
---
### Author:  [@cschouten](https://community.shiphero.com/u/cschouten)
#### Post date: [November 13, 2023, 4:01pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/7 "2023-11-13T16:01:45Z")
Hi @sh-agent,
I did try what you suggested in getting the tote information from the tote\_history query, but even when using a recent barcode, the query didn’t return any data.
Here’s the request I made last week: `654cf9791489a209562862e5` .
I’m afraid that CSV option doesn’t work for us. It’s just not scalable for our use case; we’d have to download the CSV every time we add a new location or tote rack.
Is there a programmatic way for us to get the aforementioned data?
All the best,
Colin
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [December 6, 2023, 12:43pm UTC](https://community.shiphero.com/t/how-to-get-all-totes/2678/8 "2023-12-06T12:43:35Z")
Hey @cschouten,
Thanks for hanging in there!
I believe the tote query will only return information if a line\_item is currently in the tote.
Aside from the CSV, there isn’t any way to get the tote barcodes in bulk.
Please let me know if you have any questions or concerns.
Best,
RayanP