# Query 3PL bills and charges for a period

**URL:** <https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022>\
**Category:** GraphQL API\
**Created:** [June 6, 2022, 4:15pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022 "2022-06-06T16:15:27Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://community.shiphero.com/u/Raj)\
**Post date:** [June 6, 2022, 4:15pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/1 "2022-06-06T16:15:28Z")

</div>

Hi,  
Is it possible to query 3PL bills and adhoc charges for a given time period using API?  
Basically this info:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/shiphero/original/1X/eb958c3749619cae8bc5227e7d0c4620daf5d9cc.png)  
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:** [June 6, 2022, 8:22pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/2 "2022-06-06T20:22:24Z")

</div>

Hello @Raj!

Using the `bills` query you will be able to get the total and extracts.

Were you looking to get that or each specific line? If it’s the latter, we don’t support that at the moment.

Have a great day!  
TomasFD

---

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://community.shiphero.com/u/Raj)\
**Post date:** [June 6, 2022, 8:44pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/3 "2022-06-06T20:44:43Z")

</div>

Thank you @tomasfd! I think that might be enough - would you be so kind and pls post an example query?  
I went through the docs [here](https://developer.shiphero.com/3pl-billing/) and didn’t find a ‘bills’ query…

---

<div class="post-metadata">

**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\
**Post date:** [June 7, 2022, 2:08pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/4 "2022-06-07T14:08:12Z")

</div>

Hey @Raj !

Thanks for reaching out.  
Would this query suit your needs?

```auto
{
  bills(from_date: "2022-01-01", to_date: "2022-06-07") {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          legacy_id
          __typename
          customer_name
          created_at
          due_date
          profile_name
          amount
          status
          totals(first: 10) {
            edges {
              node {
                id
                category
                quantity
                amount
              }
            }
          }
        }
      }
    }
  }
}

```

Please let me know if you have any questions or concerns.

Best,  
RayanP

---

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://community.shiphero.com/u/Raj)\
**Post date:** [June 7, 2022, 4:07pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/5 "2022-06-07T16:07:44Z")

</div>

Hey @sh-agent, that works awesome! Thank you!!

---

<div class="post-metadata">

**Author:** ![gabriella](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gabriella](https://community.shiphero.com/u/gabriella)\
**Post date:** [October 17, 2023, 3:46pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/6 "2023-10-17T15:46:12Z")

</div>

Hi @tomasfd - I see you mentioned above that the API did not support retrieving each specific lines in this report. Can you please clarify if this has since been added? If not, what queries can I use to imitate these 3PL billing reports by client?

---

<div class="post-metadata">

**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\
**Post date:** [October 18, 2023, 12:00pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/7 "2023-10-18T12:00:15Z")

</div>

Hey @Gabriella,

Thanks for reaching out and welcome to our Developer Community!

This feature has not yet been added and I don’t believe there are any queries that can be used to imitate the 3PL Billing Report that specifically.

Please let me know if you have any questions or concerns!

Best,  
RayanP

---

<div class="post-metadata">

**Author:** ![mendyshipfrankly](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mendyshipfrankly](https://community.shiphero.com/u/mendyshipfrankly)\
**Post date:** [April 24, 2025, 8:35pm UTC](https://community.shiphero.com/t/query-3pl-bills-and-charges-for-a-period/2022/8 "2025-04-24T20:35:16Z")

</div>

I tried this query with more relevant days and I am getting zero edges even though there are definitely bill in my system. Any ideas how I can debug this?