Query 3PL bills and charges for a period

GraphQL API
1

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

image
image1490×836 130 KB

Thank you!

1 Like
2

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

3

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…

4

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

1 Like
5

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

1 Like
6

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?

7

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