Invoices

Get an invoice summary

Changed on

Returns aggregate invoice totals (count and gross total) grouped by currency for the invoices matching the supplied filters. Totals cover the whole matching set, so accurate figures can be retrieved in a single request without paginating.

get/invoices/summary

Request

  • Base URL
    https://sandbox.sequencehq.com/api
  • URL
    https://sandbox.sequencehq.com/api/invoices/summary
  • Auth
    none declared. Required headers: Authorization

Query parameters

invoiceStatusstring

Filter by invoice status. Options: IN_PROGRESS, DRAFT, FINAL, SENT, VOIDED

invoicePaymentStatusstring

Filter by payment status. Options: UNPAID, PARTIALLY_PAID, PAID, UNCOLLECTIBLE

customerIdstring

Filter by customer id.

billingScheduleIdstring

Filter by billing schedule id.

dueBeforestring

Filter by due date before. Format: yyyy-MM-dd

dueAfterstring

Filter by due date after. Format: yyyy-MM-dd

sentBeforestring

Filter by sent date before. Format: yyyy-MM-dd

sentAfterstring

Filter by sent date after. Format: yyyy-MM-dd

invoiceBeforestring

Filter by invoice date before. Format: yyyy-MM-dd

invoiceAfterstring

Filter by invoice date after. Format: yyyy-MM-dd

excludeZeroQuantityboolean

Exclude invoices with zero quantity.

invoiceCurrencystring

Get invoices for a specific currency (provide a comma-separated list)

searchstring

Search invoices by invoice number (partial, case-insensitive match)

invoiceNumberstring

Filter by invoice number

netTotalnumber

Filter by net total amount

Headers

Authorizationstring required

Your API credentials. Eg. Basic {credentials}.

sequence-version'2024-07-30'

Use this header to select an API version

Response

OK

Example response

{
  "totalsByCurrency": [
    {
      "currency": "GBP",
      "invoiceCount": 12,
      "grossTotal": 15400
    },
    {
      "currency": "USD",
      "invoiceCount": 3,
      "grossTotal": 980.5
    }
  ]
}

Changes

  • d01512162768Revision changes
    • warning

      deleted the header request parameter Sequence-Version

    • warning

      deleted the query request parameter excludeBillingScheduleId

    • warning

      deleted the query request parameter excludeCustomerId

    • warning

      deleted the query request parameter excludeInvoiceCurrency

    • warning

      deleted the query request parameter excludeInvoiceNumber

    • warning

      deleted the query request parameter excludeInvoicePaymentStatus

    • warning

      deleted the query request parameter excludeInvoiceStatus

    • warning

      deleted the query request parameter excludeNetTotal

    • warning

      deleted the query request parameter excludeSearch

    • info

      added the new optional header request parameter sequence-version

  • 12ab2101be2aRevision changes
    • warning

      deleted the header request parameter sequence-version

    • info

      added the new optional header request parameter Sequence-Version

    • info

      added the new optional query request parameter excludeBillingScheduleId

    • info

      added the new optional query request parameter excludeCustomerId

    • info

      added the new optional query request parameter excludeInvoiceCurrency

    • info

      added the new optional query request parameter excludeInvoiceNumber

    • info

      added the new optional query request parameter excludeInvoicePaymentStatus

    • info

      added the new optional query request parameter excludeInvoiceStatus

    • info

      added the new optional query request parameter excludeNetTotal

    • info

      added the new optional query request parameter excludeSearch