Query 3PL bills and charges for a period

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


Thank you!

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

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 and didn’t find a ‘bills’ query…

Hey @Raj !

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

{
  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

Hey @Rayanp, that works awesome! Thank you!!

1 Like