Lodol Docs

QuickBooks Online

API actions for the QuickBooks Online integration.

QuickBooks Online

Manage invoices, customers, payments, and accounts with the QuickBooks Online API.


Create a QuickBooks customer

Create a new customer in QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
display_namestringYesCustomer display name (must be unique)
given_namestringNoCustomer first name
family_namestringNoCustomer last name
emailstringNoCustomer email address
phonestringNoCustomer phone number
company_namestringNoCustomer company name

Response

{
  "Customer": {
    "DisplayName": "New Customer",
    "Id": "123",
    "PrimaryEmailAddr": {
      "Address": "new@example.com"
    }
  }
}

Create a QuickBooks invoice

Create a new invoice in QuickBooks Online with a single line item.

Parameters

ParameterTypeRequiredDescription
customer_idstringYesQuickBooks customer ID to invoice
line_amountnumberYesLine item amount
line_descriptionstringNoLine item description
item_idstringNoQuickBooks item (product/service) ID for the line
due_datestringNoInvoice due date (YYYY-MM-DD)
email_tostringNoEmail address to send the invoice to

Response

{
  "Invoice": {
    "Balance": 250.0,
    "DocNumber": "1002",
    "Id": "200",
    "TotalAmt": 250.0
  }
}

Create a QuickBooks payment

Record a payment in QuickBooks Online, optionally linked to an invoice.

Parameters

ParameterTypeRequiredDescription
customer_idstringYesQuickBooks customer ID
total_amountnumberYesPayment amount
invoice_idstringNoQuickBooks invoice ID to apply the payment to

Response

{
  "Payment": {
    "Id": "300",
    "TotalAmt": 100.0
  }
}

Get a QuickBooks customer

Retrieve a single customer by ID from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
customer_idstringYesQuickBooks customer ID

Response

{
  "Customer": {
    "DisplayName": "Acme Corp",
    "Id": "1",
    "PrimaryEmailAddr": {
      "Address": "info@acme.com"
    }
  }
}

Get a QuickBooks invoice

Retrieve a single invoice by ID from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
invoice_idstringYesQuickBooks invoice ID

Response

{
  "Invoice": {
    "Balance": 500.0,
    "DocNumber": "1001",
    "Id": "100",
    "TotalAmt": 500.0
  }
}

List QuickBooks accounts

List accounts (Chart of Accounts) from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
limitnumberNoMaximum number of accounts to return (default 100)

Response

{
  "QueryResponse": {
    "Account": [
      {
        "AccountType": "Bank",
        "Id": "1",
        "Name": "Checking"
      },
      {
        "AccountType": "Accounts Receivable",
        "Id": "2",
        "Name": "Accounts Receivable"
      }
    ],
    "maxResults": 2,
    "startPosition": 1
  }
}

List QuickBooks customers

List customers from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
limitnumberNoMaximum number of customers to return (default 100)

Response

{
  "QueryResponse": {
    "Customer": [
      {
        "DisplayName": "Acme Corp",
        "Id": "1"
      },
      {
        "DisplayName": "Globex Inc",
        "Id": "2"
      }
    ],
    "maxResults": 2,
    "startPosition": 1
  }
}

List QuickBooks invoices

List invoices from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
limitnumberNoMaximum number of invoices to return (default 100)

Response

{
  "QueryResponse": {
    "Invoice": [
      {
        "Balance": 500.0,
        "DocNumber": "1001",
        "Id": "100",
        "TotalAmt": 500.0
      }
    ],
    "maxResults": 1,
    "startPosition": 1
  }
}

List QuickBooks items

List items (products and services) from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
limitnumberNoMaximum number of items to return (default 100)

Response

{
  "QueryResponse": {
    "Item": [
      {
        "Id": "1",
        "Name": "Consulting",
        "Type": "Service"
      },
      {
        "Id": "2",
        "Name": "Widget",
        "Type": "Inventory"
      }
    ],
    "maxResults": 2,
    "startPosition": 1
  }
}

List QuickBooks payments

List payments from QuickBooks Online.

Parameters

ParameterTypeRequiredDescription
limitnumberNoMaximum number of payments to return (default 100)

Response

{
  "QueryResponse": {
    "Payment": [
      {
        "Id": "1",
        "TotalAmt": 100.0
      },
      {
        "Id": "2",
        "TotalAmt": 250.0
      }
    ],
    "maxResults": 2,
    "startPosition": 1
  }
}

On this page