Skip to main content
GET
/
connections
/
{connection_id}
/
invoices
Query Invoices
curl --request GET \
  --url https://qubesync.com/api/v1/connections/{connection_id}/invoices \
  --header 'Authorization: Basic <encoded-value>'
{
  "data": {
    "id": "550e8400-e29b-41d4-a716-446655440000",
    "state": "waiting",
    "webhook_state": "not_applicable",
    "request_xml": "<QBXML><QBXMLMsgsRq onError='stopOnError'><CustomerQueryRq requestID='1'><MaxReturned>100</MaxReturned></CustomerQueryRq></QBXMLMsgsRq></QBXML>",
    "request_json": {
      "version": "13.0",
      "request": {
        "name": "CustomerQueryRq",
        "attributes": {
          "request_id": "1"
        },
        "children": [
          {
            "name": "MaxReturned",
            "text": "100"
          }
        ]
      }
    },
    "response_xml": "<QBXML><QBXMLMsgsRs statusCode='0' statusSeverity='Info' statusMessage='Status OK'><CustomerQueryRs requestID='1' statusCode='0' statusSeverity='Info' statusMessage='Status OK'><CustomerRet><ListID>80000001-1234567890</ListID><Name>Sample Customer</Name></CustomerRet></CustomerQueryRs></QBXMLMsgsRs></QBXML>",
    "response_json": [
      {}
    ],
    "webhook_url": "https://example.com/webhook",
    "webhook_attempts": [
      {
        "attempted_at": "2023-11-07T05:31:56Z",
        "response": "<string>"
      }
    ],
    "webhook_error": "<string>",
    "error": {
      "message": "<string>",
      "code": "<string>",
      "details": {}
    },
    "links": {
      "self": "/api/v1/connections/123e4567-e89b-12d3-a456-426614174000/queued_requests/550e8400-e29b-41d4-a716-446655440000",
      "ui": "/app/queued_requests/550e8400-e29b-41d4-a716-446655440000",
      "connection_ui": "/app/connections/123e4567-e89b-12d3-a456-426614174000"
    },
    "inserted_at": "2023-01-01T12:00:00Z",
    "updated_at": "2023-01-01T12:00:01Z",
    "connection_id": "123e4567-e89b-12d3-a456-426614174000"
  }
}

Authorizations

​
Authorization
string
header
required

Use your app's API_KEY as the username, and leave the password blank

Path Parameters

​
connection_id
string<uuid>
required

ID of the connection to use for the query

Query Parameters

​
request_id
string

A custom ID that can be used to identify the request and response. This could be your local ID for the request.

Example:

"1"

​
iterate
boolean

If true, QuBe Sync will automatically handle the QBXML iteration until all records are returned. Each page of results will have its own request record and webhook. The id and webhook_url will be the same across each page request, and there will also be page_request_id, page values to distinguish pages from each other.

Example:

true

​
max_returned
integer

Maximum number of results to return

​
include[]
enum<string>[]

List of fields for QuickBooks to include in the response. Full list of possible values at

​
customer_list_id
string

Filter invoices by customer ListID

​
from_transaction_date
string<date>

Filter invoices with transaction dates on or after this date (YYYY-MM-DD)

​
to_transaction_date
string<date>

Filter invoices with transaction dates on or before this date (YYYY-MM-DD)

​
from_due_date
string<date>

Filter invoices with due dates on or after this date (YYYY-MM-DD)

​
to_due_date
string<date>

Filter invoices with due dates on or before this date (YYYY-MM-DD)

​
status
enum<string>

Filter invoices by paid status

Available options:
All,
PaidOnly,
NotPaidOnly,
Any
​
include_line_items
boolean
default:false

Whether to include line item details in the response

​
webhook_url
string<uri>

Optional URL to receive a webhook when the request is completed

Response

Query accepted and queued for processing. Returns a queued request object.

​
data
object
⌘I