# GraphQL Fulfillment Invoices Query returns empty

**URL:** https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178
**Category:** GraphQL API
**Created:** [January 17, 2025, 10:55pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178 "2025-01-17T22:55:12Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![cathleenturner](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@cathleenturner](https://community.shiphero.com/u/cathleenturner)
#### Post date: [January 17, 2025, 10:55pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/1 "2025-01-17T22:55:12Z")

</div>

Hello Community,

I am trying to get information on fulfillment invoices, and the information for each category (eg if there is an ad\_hoc charge, the associated charges with it). When I do the query, it returns empty.

We followed the instructions for third-party developer and I was able to see my scope:  
“scope”: “openid profile view:products change:products view:orders change:orders view:purchase\_orders change:purchase\_orders view:shipments change:shipments view:returns change:returns view:warehouse\_products change:warehouse\_products view:picking\_stats view:packing\_stats offline\_access”,

I noticed that bills are not on there. Could this be part of the problem? Not looking to do any mutations, just get the detailed items associated with the bill.

This is the query, at this point I am trying to get anything. I know for sure bills were issued in that period so I should be getting something.

Query

```auto

{
  fulfillment_invoices(date_from: "2024-12-01", date_to: "2024-12-05", analyze: true) {
    request_id
    complexity
    ...invoices
  }
}
fragment invoices on FulfillmentInvoicesQueryResult {
  data( first: 10) {
    pageInfo {
      hasNextPage
      hasPreviousPage
      startCursor
      endCursor
    }
    ...thing
  }
}

fragment thing on FulfillmentInvoiceConnection {
  edges {
    node {
      id
      legacy_id
      stripe_charge_id
      stripe_invoice_id
      stripe_invoice_number
      stripe_invoice_status
      stripe_invoice_url
      stripe_next_payment_attempt
      account_id
      cc_info
      amount
      created_at
      # shipping_items(
      # sort: "string"
      # before: "string"
      # after: "string"
      # first: 1
      # last: 1
      # )
      # inbound_shipping_items(
      # sort: "string"
      # before: "string"
      # after: "string"
      # first: 1
      # last: 1
      # )
      # returns_items(
      # sort: "string"
      # before: "string"
      # after: "string"
      # first: 1
      # last: 1
      # )
      # storage_items(
      # sort: "string"
      # before: "string"
      # after: "string"
      # first: 1
      # last: 1
      # )
    }
    cursor
  }
}

```

I tried with and without the 01, same result. This is the response:

```auto
{
  "data": {
    "fulfillment_invoices": {
      "request_id": "678ae6aa4949117d8124db56",
      "complexity": 11,
      "data": {
        "pageInfo": {
          "hasNextPage": false,
          "hasPreviousPage": false,
          "startCursor": null,
          "endCursor": null
        },
        "edges": []
      }
    }
  },
  "extensions": {
    "throttling": {
      "estimated_complexity": 0,
      "cost": 1,
      "cost_detail": {
        "fulfillment_invoices": {
          "items_count": 0,
          "cost": 1,
          "total_cost": 1,
          "fields": {}
        }
      },
      "user_quota": {
        "credits_remaining": 2002,
        "max_available": 2002,
        "increment_rate": 30
      }
    }
  }
}

```

---

<div class="post-metadata">

### Author: ![cathleenturner](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@cathleenturner](https://community.shiphero.com/u/cathleenturner)
#### Post date: [January 17, 2025, 11:57pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/2 "2025-01-17T23:57:46Z")

</div>

I am also trying bills. In the UI the items are shown under “Bills”. Does anyone know if this is Bills or Fulfillment Invoices in the gql api?

---

<div class="post-metadata">

### Author: ![cathleenturner](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@cathleenturner](https://community.shiphero.com/u/cathleenturner)
#### Post date: [January 17, 2025, 11:58pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/3 "2025-01-17T23:58:26Z")

</div>

update: I was able to get some items through the query but the latest items are from two years ago. I need items from 2024

---

<div class="post-metadata">

### Author: ![cathleenturner](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@cathleenturner](https://community.shiphero.com/u/cathleenturner)
#### Post date: [January 18, 2025, 12:01am UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/4 "2025-01-18T00:01:06Z")

</div>

Basically, i need to get the items in this bill. And the line items in them. For storage its the storage bins.

 ![Screenshot 2025-01-17 at 4.00.14 PM](https://us1.discourse-cdn.com/flex020/uploads/shiphero/original/1X/3d993cce0ada0182b7ff138a9292f4e274c11835.png)

---

<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: [January 20, 2025, 3:36pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/5 "2025-01-20T15:36:49Z")

</div>

Hello @cathleenturner! Welcome to our Dev community.

The `fulfillment_invoices` query is for our fulfillment service customers.

The billing queries and mutations in our API are not available for third-party developers at the moment, they are only addressable by full users.

Have a great day

---

<div class="post-metadata">

### Author: ![cathleenturner](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@cathleenturner](https://community.shiphero.com/u/cathleenturner)
#### Post date: [January 21, 2025, 7:28pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/6 "2025-01-21T19:28:00Z")

</div>

Hi Thomas,

Thanks for the warm welcome! I appreciate you.

So if I were added as a user and generated an API key, would I be able to access the billing queries?

Thank you for your time!

---

<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: [January 22, 2025, 3:19pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/7 "2025-01-22T15:19:32Z")

</div>

Hey @cathleenturner! Correct, that should be enough.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex020/uploads/shiphero/original/2X/8/83f2a5ec5d7908b156cb6999baa4c753fadfa85d.svg) [@system](https://community.shiphero.com/u/system)
#### Post date: [April 22, 2025, 3:20pm UTC](https://community.shiphero.com/t/graphql-fulfillment-invoices-query-returns-empty/3178/8 "2025-04-22T15:20:24Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
