Operations (sample payloads)

Main operations
Copy

Create account
Copy

Create an account.

Sample Input

1
{
2
"access_token": "your_access_token_here",
3
"realm_id": "your_realm_id_here",
4
"name": "Marketing Expenses",
5
"account_number": "6000",
6
"tax_code_reference": "TAX",
7
"taxable": {
8
"account_type": "Expense - Expense"
9
}
10
}

Sample Output

1
{
2
"Account": {
3
"Name": "Marketing Expenses",
4
"SubAccount": false,
5
"FullyQualifiedName": "Marketing Expenses",
6
"Active": true,
7
"Classification": "Expense",
8
"AccountType": "Expense",
9
"AccountSubType": "AdvertisingPromotional",
10
"AcctNum": "6000",
11
"CurrentBalance": 0,
12
"CurrentBalanceWithSubAccounts": 0,
13
"CurrencyRef": {
14
"value": "USD",
15
"name": "United States Dollar"
16
},
17
"TaxCodeRef": {
18
"value": "TAX"
19
},
20
"domain": "QBO",
21
"sparse": false,
22
"Id": "123",
23
"SyncToken": "0",
24
"MetaData": {
25
"CreateTime": "2023-04-20T10:30:00Z",
26
"LastUpdatedTime": "2023-04-20T10:30:00Z"
27
}
28
},
29
"time": "2023-04-20T10:30:00.123Z"
30
}

Create bill
Copy

Create a bill.

Sample Input

1
{
2
"vendor_ref": {
3
"value": "56",
4
"name": "ABC Office Supplies"
5
},
6
"lines": [
7
{
8
"amount": 250,
9
"account_ref": {
10
"value": "72",
11
"name": "Office Supplies Expense"
12
},
13
"description": "Paper and ink cartridges",
14
"billable_status": "NotBillable"
15
},
16
{
17
"amount": 100,
18
"account_ref": {
19
"value": "73",
20
"name": "Postage Expense"
21
},
22
"description": "Shipping costs",
23
"billable_status": "Billable",
24
"customer_ref": {
25
"value": "34",
26
"name": "XYZ Corp"
27
}
28
}
29
],
30
"txn_date": "2023-06-15T00:00:00Z",
31
"currency_ref": {
32
"value": "USD",
33
"name": "United States Dollar"
34
}
35
}

Sample Output

1
{
2
"Bill": {
3
"DueDate": "2023-07-15",
4
"Balance": 350,
5
"domain": "QBO",
6
"sparse": false,
7
"Id": "1234",
8
"SyncToken": "0",
9
"MetaData": {
10
"CreateTime": "2023-06-15T14:30:25-07:00",
11
"LastUpdatedTime": "2023-06-15T14:30:25-07:00"
12
},
13
"TxnDate": "2023-06-15",
14
"CurrencyRef": {
15
"value": "USD",
16
"name": "United States Dollar"
17
},
18
"Line": [
19
{
20
"Id": "1",
21
"LineNum": 1,
22
"Amount": 250,
23
"DetailType": "AccountBasedExpenseLineDetail",
24
"AccountBasedExpenseLineDetail": {
25
"AccountRef": {
26
"value": "72",
27
"name": "Office Supplies Expense"
28
},
29
"BillableStatus": "NotBillable",
30
"TaxCodeRef": {
31
"value": "NON"
32
}
33
}
34
},
35
{
36
"Id": "2",
37
"LineNum": 2,
38
"Amount": 100,
39
"DetailType": "AccountBasedExpenseLineDetail",
40
"AccountBasedExpenseLineDetail": {
41
"AccountRef": {
42
"value": "73",
43
"name": "Postage Expense"
44
},
45
"BillableStatus": "Billable",
46
"TaxCodeRef": {
47
"value": "NON"
48
}
49
}
50
}
51
],
52
"VendorRef": {
53
"value": "56",
54
"name": "ABC Office Supplies"
55
},
56
"APAccountRef": {
57
"value": "33",
58
"name": "Accounts Payable"
59
},
60
"TotalAmt": 350
61
},
62
"time": "2023-06-15T14:30:25-07:00"
63
}

Create customer
Copy

Create a customer.

Sample Input

1
{
2
"access_token": "YOUR_ACCESS_TOKEN",
3
"realm_id": "YOUR_REALM_ID",
4
"identifier": {
5
"display_name": "John Doe",
6
"given_name": "John",
7
"family_name": "Doe"
8
},
9
"company_name": "Doe Enterprises",
10
"primary_phone": "555-123-4567",
11
"primary_email_addr": "john.doe@example.com",
12
"bill_addr": {
13
"line_1": "123 Main St",
14
"city": "Anytown",
15
"country": "USA",
16
"postal_code": "12345"
17
},
18
"taxable": {
19
"default_tax_code_ref": "TAX"
20
},
21
"preferred_delivery_method": "Email"
22
}

Sample Output

1
{
2
"Customer": {
3
"Id": "68",
4
"DisplayName": "John Doe",
5
"PrintOnCheckName": "John Doe",
6
"GivenName": "John",
7
"FamilyName": "Doe",
8
"FullyQualifiedName": "John Doe",
9
"CompanyName": "Doe Enterprises",
10
"Taxable": true,
11
"BillAddr": {
12
"Id": "69",
13
"Line1": "123 Main St",
14
"City": "Anytown",
15
"Country": "USA",
16
"PostalCode": "12345"
17
},
18
"Job": false,
19
"BillWithParent": false,
20
"Level": 0,
21
"Balance": 0,
22
"BalanceWithJobs": 0,
23
"CurrencyRef": {
24
"value": "USD",
25
"name": "United States Dollar"
26
},
27
"PreferredDeliveryMethod": "Email",
28
"domain": "QBO",
29
"sparse": false,
30
"SyncToken": "0",
31
"MetaData": {
32
"CreateTime": "2023-04-15T10:30:00-07:00",
33
"LastUpdatedTime": "2023-04-15T10:30:00-07:00"
34
},
35
"Active": true,
36
"PrimaryPhone": {
37
"FreeFormNumber": "555-123-4567"
38
},
39
"PrimaryEmailAddr": {
40
"Address": "john.doe@example.com"
41
},
42
"DefaultTaxCodeRef": {
43
"value": "TAX"
44
}
45
},
46
"time": "2023-04-15T10:30:00.123-07:00"
47
}

Create employee
Copy

Create an employee.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"display_name": "John Doe",
5
"title": "Software Engineer",
6
"given_name": "John",
7
"middle_name": "Michael",
8
"family_name": "Doe",
9
"suffix": "Jr",
10
"primary_addr": {
11
"line_1": "123 Main St",
12
"line_2": "Apt 4B",
13
"city": "San Francisco",
14
"country": "USA",
15
"country_sub_division_code": "CA",
16
"postal_code": "94105"
17
},
18
"primary_email_addr": "john.doe@example.com",
19
"hired_date": "2023-05-01T09:00:00Z",
20
"billable_time": true,
21
"gender": "Male",
22
"bill_rate": 75.5,
23
"active": true,
24
"primary_phone": "555-123-4567",
25
"mobile": "555-987-6543",
26
"birth_date": "1990-01-15T00:00:00Z",
27
"s_s_n": "123-45-6789",
28
"employee_number": "EMP001",
29
"print_on_check_name": "John M. Doe Jr"
30
}

Sample Output

1
{
2
"Employee": {
3
"EmployeeNumber": "EMP001",
4
"SSN": "123-45-6789",
5
"PrimaryAddr": {
6
"Id": "1",
7
"Line1": "123 Main St",
8
"Line2": "Apt 4B",
9
"City": "San Francisco",
10
"Country": "USA",
11
"CountrySubDivisionCode": "CA",
12
"PostalCode": "94105"
13
},
14
"BillableTime": true,
15
"BillRate": 75.5,
16
"BirthDate": "1990-01-15",
17
"Gender": "Male",
18
"HiredDate": "2023-05-01",
19
"domain": "QBO",
20
"sparse": false,
21
"Id": "123",
22
"SyncToken": "0",
23
"MetaData": {
24
"CreateTime": "2023-05-01T09:15:23-07:00",
25
"LastUpdatedTime": "2023-05-01T09:15:23-07:00"
26
},
27
"Title": "Software Engineer",
28
"GivenName": "John",
29
"MiddleName": "Michael",
30
"FamilyName": "Doe",
31
"Suffix": "Jr",
32
"DisplayName": "John Doe",
33
"PrintOnCheckName": "John M. Doe Jr",
34
"Active": true,
35
"PrimaryPhone": {
36
"FreeFormNumber": "555-123-4567"
37
},
38
"Mobile": {
39
"FreeFormNumber": "555-987-6543"
40
},
41
"PrimaryEmailAddr": {
42
"Address": "john.doe@example.com"
43
}
44
},
45
"time": "2023-05-01T09:15:23-07:00"
46
}

Create invoice
Copy

Create an invoice.

Sample Input

1
{
2
"access_token": "your_access_token_here",
3
"realm_id": "your_realm_id_here",
4
"line": [
5
{
6
"sales_item_line_detail": {
7
"amount": 100,
8
"description": "Web Design Services",
9
"item_ref": "1",
10
"unit_price": 100,
11
"qty": 1
12
}
13
}
14
],
15
"customer_ref": {
16
"value": "1",
17
"name": "John Doe"
18
},
19
"currency_ref": "USD - US Dollar",
20
"doc_number": "INV-001",
21
"txn_date": "2023-06-15",
22
"due_date": "2023-07-15",
23
"bill_addr": {
24
"line_1": "123 Main St",
25
"city": "Anytown",
26
"country": "USA",
27
"postal_code": "12345"
28
},
29
"private_note": "Internal note for this invoice",
30
"customer_memo": "Thank you for your business!"
31
}

Sample Output

1
{
2
"Invoice": {
3
"Id": "123",
4
"SyncToken": "0",
5
"MetaData": {
6
"CreateTime": "2023-06-15T10:00:00-07:00",
7
"LastUpdatedTime": "2023-06-15T10:00:00-07:00"
8
},
9
"DocNumber": "INV-001",
10
"TxnDate": "2023-06-15",
11
"CurrencyRef": {
12
"value": "USD",
13
"name": "United States Dollar"
14
},
15
"PrivateNote": "Internal note for this invoice",
16
"Line": [
17
{
18
"Id": "1",
19
"LineNum": 1,
20
"Description": "Web Design Services",
21
"Amount": 100,
22
"DetailType": "SalesItemLineDetail",
23
"SalesItemLineDetail": {
24
"ItemRef": {
25
"value": "1",
26
"name": "Web Design"
27
},
28
"UnitPrice": 100,
29
"Qty": 1
30
}
31
}
32
],
33
"CustomerRef": {
34
"value": "1",
35
"name": "John Doe"
36
},
37
"CustomerMemo": {
38
"value": "Thank you for your business!"
39
},
40
"BillAddr": {
41
"Line1": "123 Main St",
42
"City": "Anytown",
43
"Country": "USA",
44
"PostalCode": "12345"
45
},
46
"DueDate": "2023-07-15",
47
"TotalAmt": 100,
48
"Balance": 100
49
},
50
"time": "2023-06-15T10:00:00.000-07:00"
51
}

Create purchase
Copy

Create a purchase.

Sample Input

1
{
2
"payment_type": "Check",
3
"account_ref": {
4
"value": "35",
5
"name": "Checking Account"
6
},
7
"lines": [
8
{
9
"amount": 250,
10
"account_ref": {
11
"value": "52",
12
"name": "Office Supplies"
13
},
14
"description": "Printer paper and ink cartridges",
15
"billable_status": "NotBillable"
16
},
17
{
18
"amount": 75.5,
19
"account_ref": {
20
"value": "54",
21
"name": "Utilities"
22
},
23
"description": "Internet service",
24
"billable_status": "None"
25
}
26
],
27
"currency_ref": {
28
"value": "USD",
29
"name": "United States Dollar"
30
}
31
}

Sample Output

1
{
2
"Purchase": {
3
"AccountRef": {
4
"value": "35",
5
"name": "Checking Account"
6
},
7
"PaymentType": "Check",
8
"Credit": false,
9
"TotalAmt": 325.5,
10
"domain": "QBO",
11
"sparse": false,
12
"Id": "1234",
13
"SyncToken": "0",
14
"MetaData": {
15
"CreateTime": "2023-04-15T14:30:25-07:00",
16
"LastUpdatedTime": "2023-04-15T14:30:25-07:00"
17
},
18
"TxnDate": "2023-04-15",
19
"CurrencyRef": {
20
"value": "USD",
21
"name": "United States Dollar"
22
},
23
"Line": [
24
{
25
"Id": "1",
26
"Amount": 250,
27
"DetailType": "AccountBasedExpenseLineDetail",
28
"AccountBasedExpenseLineDetail": {
29
"AccountRef": {
30
"value": "52",
31
"name": "Office Supplies"
32
},
33
"BillableStatus": "NotBillable"
34
}
35
},
36
{
37
"Id": "2",
38
"Amount": 75.5,
39
"DetailType": "AccountBasedExpenseLineDetail",
40
"AccountBasedExpenseLineDetail": {
41
"AccountRef": {
42
"value": "54",
43
"name": "Utilities"
44
},
45
"BillableStatus": "None"
46
}
47
}
48
]
49
},
50
"time": "2023-04-15T14:30:25-07:00"
51
}

Create time activity
Copy

Create a time activity

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "123456789",
4
"name_of": {
5
"employee_id": "55",
6
"name": "John Doe"
7
},
8
"time": {
9
"start_time": {
10
"hour": "09",
11
"minute": "00"
12
},
13
"end_time": {
14
"hour": "17",
15
"minute": "30"
16
}
17
},
18
"break_hours": 1,
19
"break_minutes": 0,
20
"billable_status": {
21
"taxable": true,
22
"hourly_rate": 75.5
23
},
24
"txn_date": "2023-05-15T00:00:00Z",
25
"description": "Project development and client meeting",
26
"customer_ref": {
27
"value": "68",
28
"name": "Acme Corp"
29
},
30
"item_ref": {
31
"value": "37",
32
"name": "Software Development"
33
},
34
"class_ref": {
35
"value": "42",
36
"name": "IT Department"
37
},
38
"department_ref": {
39
"value": "15",
40
"name": "Engineering"
41
}
42
}

Sample Output

1
{
2
"TimeActivity": {
3
"TxnDate": "2023-05-15",
4
"NameOf": "Employee",
5
"EmployeeRef": {
6
"value": "55",
7
"name": "John Doe"
8
},
9
"CustomerRef": {
10
"value": "68",
11
"name": "Acme Corp"
12
},
13
"ItemRef": {
14
"value": "37",
15
"name": "Software Development"
16
},
17
"DepartmentRef": {
18
"value": "15",
19
"name": "Engineering"
20
},
21
"ClassRef": {
22
"value": "42",
23
"name": "IT Department"
24
},
25
"BillableStatus": "Billable",
26
"Taxable": true,
27
"HourlyRate": 75.5,
28
"BreakHours": 1,
29
"BreakMinutes": 0,
30
"StartTime": "2023-05-15T09:00:00-07:00",
31
"EndTime": "2023-05-15T17:30:00-07:00",
32
"Description": "Project development and client meeting",
33
"domain": "QBO",
34
"sparse": false,
35
"Id": "123",
36
"SyncToken": "0",
37
"MetaData": {
38
"CreateTime": "2023-05-15T18:00:00-07:00",
39
"LastUpdatedTime": "2023-05-15T18:00:00-07:00"
40
}
41
},
42
"time": "2023-05-15T18:00:00.000Z"
43
}

Create vendor
Copy

Create a vendor

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"identifier": {
5
"display_name": "Acme Supplies Inc.",
6
"given_name": "John",
7
"family_name": "Doe",
8
"title": "Mr."
9
},
10
"bill_addr": {
11
"line_1": "123 Main St",
12
"city": "Anytown",
13
"country": "USA",
14
"country_sub_division_code": "CA",
15
"postal_code": "12345"
16
},
17
"currency_ref": "USD - US Dollar",
18
"term_ref": {
19
"value": "3",
20
"name": "Net 30"
21
},
22
"active": true,
23
"primary_phone": "555-123-4567",
24
"primary_email_addr": "john.doe@acmesupplies.com",
25
"web_addr": "https://www.acmesupplies.com",
26
"vendor_1099": true,
27
"company_name": "Acme Supplies Inc.",
28
"tax_identifier": "12-3456789",
29
"acct_num": "V-001",
30
"print_on_check_name": "Acme Supplies Inc."
31
}

Sample Output

1
{
2
"Vendor": {
3
"MiddleName": null,
4
"sparse": false,
5
"Mobile": null,
6
"CurrencyRef": {
7
"value": "USD",
8
"name": "United States Dollar"
9
},
10
"TermRef": {
11
"value": "3",
12
"name": "Net 30"
13
},
14
"domain": "QBO",
15
"WebAddr": {
16
"URI": "https://www.acmesupplies.com"
17
},
18
"Active": true,
19
"Vendor1099": true,
20
"PrintOnCheckName": "Acme Supplies Inc.",
21
"CompanyName": "Acme Supplies Inc.",
22
"GivenName": "John",
23
"PrimaryEmailAddr": {
24
"Address": "john.doe@acmesupplies.com"
25
},
26
"PrimaryPhone": {
27
"FreeFormNumber": "555-123-4567"
28
},
29
"DisplayName": "Acme Supplies Inc.",
30
"FamilyName": "Doe",
31
"MetaData": {
32
"CreateTime": "2023-04-15T10:30:00Z",
33
"LastUpdatedTime": "2023-04-15T10:30:00Z"
34
},
35
"Suffix": null,
36
"AcctNum": "V-001",
37
"AlternatePhone": null,
38
"TaxIdentifier": "12-3456789",
39
"BillAddr": {
40
"Line1": "123 Main St",
41
"City": "Anytown",
42
"Country": "USA",
43
"CountrySubDivisionCode": "CA",
44
"PostalCode": "12345",
45
"Id": "1"
46
},
47
"Title": "Mr.",
48
"Id": "123",
49
"Balance": 0,
50
"Fax": null,
51
"SyncToken": "0"
52
},
53
"time": "2023-04-15T10:30:00.000Z"
54
}

Delete purchase
Copy

Delete a purchase.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"purchase_id": "123",
5
"sync_token": "0"
6
}

Sample Output

1
{
2
"Purchase": {
3
"domain": "QBO",
4
"status": "Deleted",
5
"Id": "123",
6
"CustomField": []
7
},
8
"time": "2023-04-15T14:30:45.123Z"
9
}

Delete time activity
Copy

Delete a Time Activity.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"time_activity_id": "TA123",
5
"sync_token": "1"
6
}

Sample Output

1
{
2
"TimeActivity": {
3
"domain": "QBO",
4
"status": "Deleted",
5
"Id": "TA123"
6
},
7
"time": "2023-04-15T14:30:00Z"
8
}

Delete transfer
Copy

Delete a transfer.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"transfer_id": "TR-123456"
5
}

Sample Output

1
{
2
"Transfer": {
3
"domain": "QBO",
4
"status": "Deleted",
5
"Id": "TR-123456"
6
},
7
"time": "2023-06-15T14:30:45Z"
8
}

Get account
Copy

Get account details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"account_id": "75"
5
}

Sample Output

1
{
2
"Account": {
3
"Name": "Checking Account",
4
"SubAccount": false,
5
"FullyQualifiedName": "Checking Account",
6
"Active": true,
7
"Classification": "Asset",
8
"AccountType": "Bank",
9
"AccountSubType": "Checking",
10
"CurrentBalance": 5000,
11
"CurrentBalanceWithSubAccounts": 5000,
12
"CurrencyRef": {
13
"value": "USD",
14
"name": "United States Dollar"
15
},
16
"domain": "QBO",
17
"sparse": false,
18
"Id": "75",
19
"SyncToken": "0",
20
"MetaData": {
21
"CreateTime": "2023-04-15T09:00:00-07:00",
22
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
23
}
24
},
25
"time": "2023-04-15T10:30:00-07:00"
26
}

Get bill
Copy

Get bill details by ID.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"bill_id": "123"
5
}

Sample Output

1
{
2
"Bill": {
3
"DueDate": "2023-06-30",
4
"Balance": 500,
5
"domain": "QBO",
6
"sparse": false,
7
"Id": "123",
8
"SyncToken": "0",
9
"MetaData": {
10
"CreateTime": "2023-05-15T09:00:00-07:00",
11
"LastUpdatedTime": "2023-05-15T09:00:00-07:00"
12
},
13
"TxnDate": "2023-05-15",
14
"CurrencyRef": {
15
"value": "USD",
16
"name": "United States Dollar"
17
},
18
"Line": [
19
{
20
"Id": "1",
21
"LineNum": 1,
22
"Description": "Office Supplies",
23
"Amount": 250,
24
"DetailType": "ItemBasedExpenseLineDetail",
25
"ItemBasedExpenseLineDetail": {
26
"BillableStatus": "NotBillable",
27
"ItemRef": {
28
"value": "5",
29
"name": "Office Supplies"
30
},
31
"UnitPrice": 25,
32
"Qty": 10,
33
"TaxCodeRef": {
34
"value": "TAX"
35
}
36
}
37
},
38
{
39
"Id": "2",
40
"LineNum": 2,
41
"Description": "Cleaning Services",
42
"Amount": 250,
43
"DetailType": "ItemBasedExpenseLineDetail",
44
"ItemBasedExpenseLineDetail": {
45
"BillableStatus": "NotBillable",
46
"ItemRef": {
47
"value": "6",
48
"name": "Cleaning Services"
49
},
50
"UnitPrice": 250,
51
"Qty": 1,
52
"TaxCodeRef": {
53
"value": "NON"
54
}
55
}
56
}
57
],
58
"VendorRef": {
59
"value": "56",
60
"name": "Office Depot"
61
},
62
"APAccountRef": {
63
"value": "33",
64
"name": "Accounts Payable"
65
},
66
"TotalAmt": 500
67
},
68
"time": "2023-05-15T09:05:00-07:00"
69
}

Get class
Copy

Get class details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"class_id": "5000000000000123456"
5
}

Sample Output

1
{
2
"Class": {
3
"Name": "Marketing",
4
"SubClass": false,
5
"FullyQualifiedName": "Marketing",
6
"Active": true,
7
"domain": "QBO",
8
"sparse": false,
9
"Id": "5000000000000123456",
10
"SyncToken": "0",
11
"MetaData": {
12
"CreateTime": "2023-04-15T09:30:00-07:00",
13
"LastUpdatedTime": "2023-04-15T09:30:00-07:00"
14
}
15
},
16
"time": "2023-04-15T10:15:30-07:00"
17
}

Get credit memo
Copy

Get credit memo details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"credit_memo_id": "CM-1001"
5
}

Sample Output

1
{
2
"CreditMemo": {
3
"RemainingCredit": 100,
4
"domain": "QBO",
5
"sparse": false,
6
"Id": "CM-1001",
7
"SyncToken": "0",
8
"MetaData": {
9
"CreateTime": "2023-04-15T09:00:00-07:00",
10
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
11
},
12
"CustomField": [],
13
"DocNumber": "1001",
14
"TxnDate": "2023-04-15",
15
"DepartmentRef": {
16
"value": "1",
17
"name": "Sales"
18
},
19
"CurrencyRef": {
20
"value": "USD",
21
"name": "United States Dollar"
22
},
23
"ExchangeRate": 1,
24
"PrivateNote": "Customer overpayment",
25
"Line": [
26
{
27
"Id": "1",
28
"LineNum": 1,
29
"Description": "Product return",
30
"Amount": 100,
31
"DetailType": "SalesItemLineDetail",
32
"SalesItemLineDetail": {
33
"ItemRef": {
34
"value": "1",
35
"name": "Product A"
36
},
37
"ClassRef": {
38
"value": "1",
39
"name": "Retail"
40
},
41
"UnitPrice": 50,
42
"Qty": 2,
43
"TaxCodeRef": {
44
"value": "TAX"
45
}
46
}
47
}
48
],
49
"TxnTaxDetail": {
50
"TotalTax": 8,
51
"TaxLine": [
52
{
53
"Amount": 8,
54
"DetailType": "TaxLineDetail",
55
"TaxLineDetail": {
56
"TaxRateRef": {
57
"value": "1"
58
},
59
"PercentBased": true,
60
"TaxPercent": 8,
61
"NetAmountTaxable": 100
62
}
63
}
64
]
65
},
66
"CustomerRef": {
67
"value": "1",
68
"name": "John Doe"
69
},
70
"CustomerMemo": {
71
"value": "Credit for returned items"
72
},
73
"GlobalTaxCalculation": "TaxExcluded",
74
"TotalAmt": 108,
75
"HomeTotalAmt": 108,
76
"PrintStatus": "NeedToPrint",
77
"EmailStatus": "NotSet",
78
"BillEmail": {
79
"Address": "john.doe@example.com"
80
},
81
"Balance": 0,
82
"DeliveryInfo": {
83
"DeliveryType": "Email",
84
"DeliveryTime": "2023-04-15T09:05:00-07:00"
85
}
86
},
87
"time": "2023-04-15T09:10:00-07:00"
88
}

Get credit memo as PDF
Copy

Get a credit memo as a PDF document.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"credit_memo_id": "CM-12345"
5
}

Sample Output

1
{
2
"name": "CreditMemo_CM-12345.pdf",
3
"url": "https://quickbooks.api.intuit.com/v3/company/1234567890/creditMemo/CM-12345/pdf",
4
"mime_type": "application/pdf",
5
"expires": 1623456789
6
}

Get customer
Copy

Get customer details by ID.

Sample Input

1
{
2
"customer_id": "123456"
3
}

Sample Output

1
{
2
"Customer": {
3
"Taxable": true,
4
"BillAddr": {
5
"Id": "1",
6
"Line1": "123 Main St",
7
"City": "Anytown",
8
"PostalCode": "12345",
9
"Lat": "37.7749",
10
"Long": "-122.4194"
11
},
12
"ShipAddr": {
13
"Id": "2",
14
"Line1": "456 Oak Ave",
15
"City": "Somewhere",
16
"PostalCode": "67890",
17
"Lat": "40.7128",
18
"Long": "-74.0060"
19
},
20
"Job": false,
21
"BillWithParent": false,
22
"ParentRef": {
23
"value": "789"
24
},
25
"Level": 0,
26
"Balance": 1000,
27
"BalanceWithJobs": 1000,
28
"CurrencyRef": {
29
"value": "USD",
30
"name": "United States Dollar"
31
},
32
"PreferredDeliveryMethod": "Email",
33
"domain": "QBO",
34
"sparse": false,
35
"Id": "123456",
36
"SyncToken": "0",
37
"MetaData": {
38
"CreateTime": "2023-05-01T10:00:00-07:00",
39
"LastUpdatedTime": "2023-05-15T14:30:00-07:00"
40
},
41
"FullyQualifiedName": "Sample Company",
42
"CompanyName": "Sample Company Inc.",
43
"DisplayName": "Sample Company",
44
"PrintOnCheckName": "Sample Company Inc.",
45
"Active": true
46
},
47
"time": "2023-05-15T14:35:00-07:00"
48
}

Get department
Copy

Get department details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"department_id": "1"
5
}

Sample Output

1
{
2
"Department": {
3
"Name": "Sales",
4
"SubDepartment": false,
5
"FullyQualifiedName": "Sales",
6
"Active": true,
7
"domain": "QBO",
8
"sparse": false,
9
"Id": "1",
10
"SyncToken": "0",
11
"MetaData": {
12
"CreateTime": "2023-04-15T09:00:00-07:00",
13
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
14
}
15
},
16
"time": "2023-04-15T16:30:45.123Z"
17
}

Get employee
Copy

Get employee details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "4620816365177742688",
4
"employee_id": "55"
5
}

Sample Output

1
{
2
"Employee": {
3
"EmployeeNumber": "EMP001",
4
"SSN": "123-45-6789",
5
"PrimaryAddr": {
6
"Id": "1",
7
"Line1": "123 Main St",
8
"Line2": "Apt 4B",
9
"City": "Anytown",
10
"Country": "USA",
11
"PostalCode": "12345"
12
},
13
"BillableTime": true,
14
"BillRate": 75,
15
"BirthDate": "1985-06-15",
16
"Gender": "Female",
17
"HiredDate": "2020-03-01",
18
"domain": "QBO",
19
"sparse": false,
20
"Id": "55",
21
"SyncToken": "0",
22
"MetaData": {
23
"CreateTime": "2020-03-01T09:00:00-08:00",
24
"LastUpdatedTime": "2023-05-15T14:30:00-08:00"
25
},
26
"Title": "Senior Developer",
27
"GivenName": "Jane",
28
"MiddleName": "Marie",
29
"FamilyName": "Doe",
30
"DisplayName": "Jane Doe",
31
"PrintOnCheckName": "Jane M. Doe",
32
"Active": true,
33
"PrimaryPhone": {
34
"FreeFormNumber": "(555) 123-4567"
35
},
36
"Mobile": {
37
"FreeFormNumber": "(555) 987-6543"
38
},
39
"PrimaryEmailAddr": {
40
"Address": "jane.doe@example.com"
41
}
42
},
43
"time": "2023-05-15T14:35:22-08:00"
44
}

Get invoice
Copy

Get invoice details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"invoice_id": "1001"
5
}

Sample Output

1
{
2
"Invoice": {
3
"Id": "1001",
4
"Deposit": 0,
5
"AllowIPNPayment": true,
6
"AllowOnlinePayment": true,
7
"AllowOnlineCreditCardPayment": true,
8
"AllowOnlineACHPayment": false,
9
"domain": "QBO",
10
"sparse": false,
11
"SyncToken": "0",
12
"MetaData": {
13
"CreateTime": "2023-05-15T09:30:00-07:00",
14
"LastUpdatedTime": "2023-05-15T09:30:00-07:00"
15
},
16
"CustomField": [],
17
"DocNumber": "INV-1001",
18
"TxnDate": "2023-05-15",
19
"CurrencyRef": {
20
"value": "USD",
21
"name": "United States Dollar"
22
},
23
"ExchangeRate": 1,
24
"LinkedTxn": [],
25
"Line": [
26
{
27
"Id": "1",
28
"LineNum": 1,
29
"Description": "Web Design Services",
30
"Amount": 1000,
31
"DetailType": "SalesItemLineDetail",
32
"SalesItemLineDetail": {
33
"ItemRef": {
34
"value": "1",
35
"name": "Web Design"
36
},
37
"UnitPrice": 100,
38
"Qty": 10,
39
"TaxCodeRef": {
40
"value": "TAX"
41
}
42
}
43
},
44
{
45
"Id": "2",
46
"LineNum": 2,
47
"Description": "Subtotal",
48
"Amount": 1000,
49
"DetailType": "SubTotalLineDetail",
50
"SubTotalLineDetail": {}
51
}
52
],
53
"TxnTaxDetail": {
54
"TotalTax": 80,
55
"TaxLine": [
56
{
57
"Amount": 80,
58
"DetailType": "TaxLineDetail",
59
"TaxLineDetail": {
60
"TaxRateRef": {
61
"value": "2"
62
},
63
"PercentBased": true,
64
"TaxPercent": 8,
65
"NetAmountTaxable": 1000
66
}
67
}
68
]
69
},
70
"CustomerRef": {
71
"value": "1",
72
"name": "John Doe"
73
},
74
"BillAddr": {
75
"Id": "2",
76
"Line1": "123 Main St",
77
"City": "Anytown",
78
"PostalCode": "12345",
79
"Lat": "37.4275",
80
"Long": "-122.1697"
81
},
82
"ShipAddr": {
83
"Id": "2",
84
"Line1": "123 Main St",
85
"City": "Anytown",
86
"PostalCode": "12345",
87
"Lat": "37.4275",
88
"Long": "-122.1697"
89
},
90
"SalesTermRef": {
91
"value": "3"
92
},
93
"DueDate": "2023-06-14",
94
"GlobalTaxCalculation": "TaxExcluded",
95
"TotalAmt": 1080,
96
"HomeTotalAmt": 1080,
97
"PrintStatus": "NeedToPrint",
98
"EmailStatus": "NotSet",
99
"Balance": 1080
100
},
101
"time": "2023-05-15T10:00:00-07:00"
102
}

Get payment
Copy

Get a payment by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"payment_id": "123"
5
}

Sample Output

1
{
2
"CustomerRef": {
3
"value": "45",
4
"name": "John Doe"
5
},
6
"DepositToAccountRef": {
7
"value": "35"
8
},
9
"PaymentMethodRef": {
10
"value": "3"
11
},
12
"PaymentRefNum": "1001",
13
"TotalAmt": 500,
14
"UnappliedAmt": 0,
15
"ProcessPayment": true,
16
"domain": "QBO",
17
"sparse": false,
18
"Id": "123",
19
"SyncToken": "0",
20
"MetaData": {
21
"CreateTime": "2023-04-15T09:00:00-07:00",
22
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
23
},
24
"TxnDate": "2023-04-15",
25
"CurrencyRef": {
26
"value": "USD",
27
"name": "United States Dollar"
28
},
29
"LinkedTxn": [
30
{
31
"TxnId": "456",
32
"TxnType": "Invoice"
33
}
34
],
35
"Line": [
36
{
37
"Amount": 500,
38
"LinkedTxn": [
39
{
40
"TxnId": "456",
41
"TxnType": "Invoice"
42
}
43
],
44
"LineEx": {
45
"any": [
46
{
47
"name": "TxnLineDetail",
48
"declaredType": "com.intuit.schema.finance.v3.IPPPaymentLineDetail",
49
"scope": "javax.xml.bind.JAXBElement$GlobalScope",
50
"value": {
51
"Name": "PaymentLineDetail",
52
"Value": "Details"
53
},
54
"nil": false,
55
"globalScope": true,
56
"typeSubstituted": false
57
}
58
]
59
}
60
}
61
]
62
}

Get payment method
Copy

Get payment method details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"payment_method_id": "5"
5
}

Sample Output

1
{
2
"PaymentMethod": {
3
"Name": "Credit Card",
4
"Active": true,
5
"Type": "CREDIT_CARD",
6
"domain": "QBO",
7
"sparse": false,
8
"Id": "5",
9
"SyncToken": "0",
10
"MetaData": {
11
"CreateTime": "2023-04-15T09:30:00-07:00",
12
"LastUpdatedTime": "2023-04-15T09:30:00-07:00"
13
}
14
},
15
"time": "2023-04-15T10:15:33.456-07:00"
16
}

Get purchase
Copy

Get purchase details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"purchase_id": "123"
5
}

Sample Output

1
{
2
"Purchase": {
3
"AccountRef": {
4
"value": "42",
5
"name": "Checking Account"
6
},
7
"PaymentType": "Check",
8
"Credit": false,
9
"TotalAmt": 500,
10
"PurchaseEx": {
11
"any": [
12
{
13
"name": "CustomField",
14
"declaredType": "com.intuit.schema.finance.v3.CustomField",
15
"scope": "com.intuit.schema.finance.v3",
16
"value": {
17
"Name": "Project",
18
"Value": "Website Redesign"
19
},
20
"nil": false,
21
"globalScope": true,
22
"typeSubstituted": false
23
}
24
]
25
},
26
"domain": "QBO",
27
"sparse": false,
28
"Id": "123",
29
"SyncToken": "0",
30
"MetaData": {
31
"CreateTime": "2023-04-15T09:00:00-07:00",
32
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
33
},
34
"CustomField": [],
35
"TxnDate": "2023-04-15",
36
"CurrencyRef": {
37
"value": "USD",
38
"name": "United States Dollar"
39
},
40
"Line": [
41
{
42
"Id": "1",
43
"Amount": 500,
44
"DetailType": "AccountBasedExpenseLineDetail",
45
"AccountBasedExpenseLineDetail": {
46
"AccountRef": {
47
"value": "60",
48
"name": "Advertising"
49
},
50
"BillableStatus": "NotBillable",
51
"TaxCodeRef": {
52
"value": "NON"
53
}
54
}
55
}
56
],
57
"time": "2023-04-15T09:00:00-07:00"
58
}
59
}

Get tax code
Copy

Get tax code details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"tax_code_id": "TAX_CODE_1"
5
}

Sample Output

1
{
2
"TaxCode": {
3
"Name": "Sales Tax",
4
"Description": "Standard sales tax for goods and services",
5
"Active": true,
6
"Taxable": true,
7
"TaxGroup": false,
8
"SalesTaxRateList": {
9
"TaxRateDetail": [
10
{
11
"TaxRateRef": {
12
"value": "RATE_1",
13
"name": "State Tax"
14
},
15
"TaxTypeApplicable": "Sales",
16
"TaxOrder": 1
17
},
18
{
19
"TaxRateRef": {
20
"value": "RATE_2",
21
"name": "County Tax"
22
},
23
"TaxTypeApplicable": "Sales",
24
"TaxOrder": 2
25
}
26
]
27
},
28
"PurchaseTaxRateList": {
29
"TaxRateDetail": []
30
},
31
"domain": "QBO",
32
"sparse": false,
33
"Id": "TAX_CODE_1",
34
"SyncToken": "0",
35
"MetaData": {
36
"CreateTime": "2023-04-15T09:00:00-07:00",
37
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
38
}
39
},
40
"time": "2023-04-15T10:30:00-07:00"
41
}

Get term
Copy

Get term details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"term_id": "75"
5
}

Sample Output

1
{
2
"Term": {
3
"Name": "Net 30",
4
"Active": true,
5
"Type": "STANDARD",
6
"DueDays": 30,
7
"DiscountDays": 10,
8
"domain": "QBO",
9
"sparse": false,
10
"Id": "75",
11
"SyncToken": "0",
12
"MetaData": {
13
"CreateTime": "2023-04-15T09:30:00-07:00",
14
"LastUpdatedTime": "2023-04-15T09:30:00-07:00"
15
}
16
},
17
"time": "2023-04-20T14:22:35.279Z"
18
}

Get time activity
Copy

Get time activity details by ID.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"time_activity_id": "TA-000001"
5
}

Sample Output

1
{
2
"TimeActivity": {
3
"TxnDate": "2023-05-15",
4
"NameOf": "Employee",
5
"EmployeeRef": {
6
"value": "55",
7
"name": "John Doe"
8
},
9
"CustomerRef": {
10
"value": "23",
11
"name": "Acme Corp"
12
},
13
"ItemRef": {
14
"value": "1",
15
"name": "Web Development"
16
},
17
"BillableStatus": "Billable",
18
"Taxable": true,
19
"HourlyRate": 75,
20
"BreakHours": 0,
21
"BreakMinutes": 30,
22
"StartTime": "2023-05-15T09:00:00-07:00",
23
"EndTime": "2023-05-15T17:30:00-07:00",
24
"Description": "Worked on client website redesign",
25
"domain": "QBO",
26
"sparse": false,
27
"Id": "TA-000001",
28
"SyncToken": "0",
29
"MetaData": {
30
"CreateTime": "2023-05-15T18:00:00-07:00",
31
"LastUpdatedTime": "2023-05-15T18:00:00-07:00"
32
}
33
},
34
"time": "2023-05-16T10:30:00-07:00"
35
}

Get transfer
Copy

Get transfer details by ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"transfer_id": "123"
5
}

Sample Output

1
{
2
"Transfer": {
3
"FromAccountRef": {
4
"value": "35",
5
"name": "Checking Account"
6
},
7
"ToAccountRef": {
8
"value": "36",
9
"name": "Savings Account"
10
},
11
"Amount": 1000,
12
"domain": "QBO",
13
"sparse": false,
14
"Id": "123",
15
"SyncToken": "0",
16
"MetaData": {
17
"CreateTime": "2023-04-15T09:00:00-07:00",
18
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
19
},
20
"TxnDate": "2023-04-15",
21
"CurrencyRef": {
22
"value": "USD",
23
"name": "United States Dollar"
24
}
25
},
26
"time": "2023-04-15T09:05:00-07:00"
27
}

Get vendor
Copy

Get vendor details by ID.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"vendor_id": "56"
5
}

Sample Output

1
{
2
"Vendor": {
3
"BillAddr": {
4
"Id": "23",
5
"Line1": "123 Main St",
6
"Line2": "Suite 100",
7
"City": "San Francisco",
8
"Country": "USA",
9
"PostalCode": "94105"
10
},
11
"TaxIdentifier": "12-3456789",
12
"TermRef": {
13
"value": "3"
14
},
15
"Balance": 1500.75,
16
"AcctNum": "V-1001",
17
"Vendor1099": true,
18
"CurrencyRef": {
19
"value": "USD",
20
"name": "United States Dollar"
21
},
22
"domain": "QBO",
23
"sparse": false,
24
"Id": "56",
25
"SyncToken": "2",
26
"MetaData": {
27
"CreateTime": "2023-04-15T09:00:00-07:00",
28
"LastUpdatedTime": "2023-05-01T14:30:00-07:00"
29
},
30
"CompanyName": "ABC Supplies Inc.",
31
"DisplayName": "ABC Supplies",
32
"PrintOnCheckName": "ABC Supplies Inc.",
33
"Active": true,
34
"PrimaryPhone": {
35
"FreeFormNumber": "(555) 123-4567"
36
},
37
"AlternatePhone": {
38
"FreeFormNumber": "(555) 987-6543"
39
},
40
"Mobile": {
41
"FreeFormNumber": "(555) 555-5555"
42
},
43
"Fax": {
44
"FreeFormNumber": "(555) 111-2222"
45
},
46
"PrimaryEmailAddr": {
47
"Address": "contact@abcsupplies.com"
48
},
49
"WebAddr": {
50
"URI": "https://www.abcsupplies.com"
51
}
52
},
53
"time": "2023-05-10T08:45:30-07:00"
54
}

List accounts
Copy

List all accounts in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"name": "Bank",
5
"where": [
6
{
7
"entity": "AccountType",
8
"operator": "=",
9
"value": "Bank"
10
}
11
],
12
"order_by": {
13
"value": "Name",
14
"direction": "ASC"
15
},
16
"start_position": 1,
17
"max_results": 10
18
}

Sample Output

1
{
2
"QueryResponse": {
3
"Account": [
4
{
5
"Name": "Checking Account",
6
"SubAccount": false,
7
"Description": "Main business checking account",
8
"FullyQualifiedName": "Checking Account",
9
"Active": true,
10
"Classification": "Asset",
11
"AccountType": "Bank",
12
"AccountSubType": "Checking",
13
"CurrentBalance": 15000.5,
14
"CurrentBalanceWithSubAccounts": 15000.5,
15
"CurrencyRef": {
16
"value": "USD",
17
"name": "United States Dollar"
18
},
19
"domain": "QBO",
20
"sparse": false,
21
"Id": "1",
22
"SyncToken": "0",
23
"MetaData": {
24
"CreateTime": "2023-05-01T09:00:00-07:00",
25
"LastUpdatedTime": "2023-05-15T14:30:00-07:00"
26
}
27
},
28
{
29
"Name": "Savings Account",
30
"SubAccount": false,
31
"Description": "Business savings account",
32
"FullyQualifiedName": "Savings Account",
33
"Active": true,
34
"Classification": "Asset",
35
"AccountType": "Bank",
36
"AccountSubType": "Savings",
37
"CurrentBalance": 50000,
38
"CurrentBalanceWithSubAccounts": 50000,
39
"CurrencyRef": {
40
"value": "USD",
41
"name": "United States Dollar"
42
},
43
"domain": "QBO",
44
"sparse": false,
45
"Id": "2",
46
"SyncToken": "0",
47
"MetaData": {
48
"CreateTime": "2023-05-01T09:15:00-07:00",
49
"LastUpdatedTime": "2023-05-15T14:45:00-07:00"
50
}
51
}
52
],
53
"startPosition": 1,
54
"maxResults": 10
55
},
56
"time": "2023-05-15T15:00:00-07:00"
57
}

List classes
Copy

List all classes in your company.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "Name",
7
"operator": "LIKE",
8
"value": "Sales%"
9
}
10
],
11
"order_by": {
12
"value": "Name",
13
"direction": "ASC"
14
},
15
"start_position": 1,
16
"max_results": 10
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"Class": [
4
{
5
"Name": "Sales Department",
6
"SubClass": false,
7
"FullyQualifiedName": "Sales Department",
8
"Active": true,
9
"domain": "QBO",
10
"sparse": false,
11
"Id": "1",
12
"SyncToken": "0",
13
"MetaData": {
14
"CreateTime": "2023-04-15T09:00:00-07:00",
15
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
16
}
17
},
18
{
19
"Name": "Sales Team A",
20
"SubClass": true,
21
"FullyQualifiedName": "Sales Department:Sales Team A",
22
"Active": true,
23
"domain": "QBO",
24
"sparse": false,
25
"Id": "2",
26
"SyncToken": "0",
27
"MetaData": {
28
"CreateTime": "2023-04-15T09:05:00-07:00",
29
"LastUpdatedTime": "2023-04-15T09:05:00-07:00"
30
}
31
}
32
],
33
"startPosition": 1,
34
"maxResults": 10,
35
"totalCount": 2
36
},
37
"time": "2023-04-15T10:00:00-07:00"
38
}

List credit memos
Copy

List all credit memos in your company.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "TxnDate",
7
"operator": ">=",
8
"value": "2023-01-01"
9
}
10
],
11
"order_by": {
12
"value": "TxnDate",
13
"direction": "DESC"
14
},
15
"start_position": 1,
16
"max_results": 10
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"CreditMemo": [
4
{
5
"RemainingCredit": 100,
6
"domain": "QBO",
7
"sparse": false,
8
"Id": "123",
9
"SyncToken": "0",
10
"MetaData": {
11
"CreateTime": "2023-05-15T09:00:00-07:00",
12
"LastUpdatedTime": "2023-05-15T09:00:00-07:00"
13
},
14
"CustomField": [],
15
"DocNumber": "1001",
16
"TxnDate": "2023-05-15",
17
"DepartmentRef": {
18
"value": "1",
19
"name": "Sales"
20
},
21
"CurrencyRef": {
22
"value": "USD",
23
"name": "United States Dollar"
24
},
25
"ExchangeRate": 1,
26
"PrivateNote": "Customer overpayment",
27
"Line": [
28
{
29
"Id": "1",
30
"LineNum": 1,
31
"Description": "Product return",
32
"Amount": 100,
33
"DetailType": "SalesItemLineDetail",
34
"SalesItemLineDetail": {
35
"ItemRef": {
36
"value": "1",
37
"name": "Product A"
38
},
39
"UnitPrice": 100,
40
"Qty": 1,
41
"TaxCodeRef": {
42
"value": "TAX"
43
}
44
}
45
}
46
],
47
"TxnTaxDetail": {
48
"TotalTax": 0
49
},
50
"CustomerRef": {
51
"value": "1",
52
"name": "John Doe"
53
},
54
"CustomerMemo": {
55
"value": "Thank you for your business"
56
},
57
"GlobalTaxCalculation": "TaxExcluded",
58
"TotalAmt": 100,
59
"HomeTotalAmt": 100,
60
"PrintStatus": "NeedToPrint",
61
"EmailStatus": "NotSet",
62
"BillEmail": {
63
"Address": "john.doe@example.com"
64
},
65
"Balance": 0,
66
"DeliveryInfo": {
67
"DeliveryType": "Email",
68
"DeliveryTime": "2023-05-15T09:05:00-07:00"
69
}
70
}
71
],
72
"startPosition": 1,
73
"maxResults": 10
74
},
75
"time": "2023-05-15T09:10:00-07:00"
76
}

List employees
Copy

List all employees in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "Active",
7
"operator": "=",
8
"value": true
9
}
10
],
11
"order_by": {
12
"value": "FamilyName",
13
"direction": "ASC"
14
},
15
"start_position": 1,
16
"max_results": 5
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"Employee": [
4
{
5
"BillableTime": true,
6
"domain": "QBO",
7
"sparse": false,
8
"Id": "55",
9
"SyncToken": "0",
10
"MetaData": {
11
"CreateTime": "2023-04-15T09:00:00-07:00",
12
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
13
},
14
"GivenName": "John",
15
"FamilyName": "Doe",
16
"DisplayName": "John Doe",
17
"PrintOnCheckName": "John Doe",
18
"Active": true,
19
"EmployeeNumber": "EMP001",
20
"Gender": "Male",
21
"HiredDate": "2023-01-15",
22
"PrimaryPhone": {
23
"FreeFormNumber": "+1 (555) 123-4567"
24
},
25
"Mobile": {
26
"FreeFormNumber": "+1 (555) 987-6543"
27
}
28
},
29
{
30
"BillableTime": false,
31
"domain": "QBO",
32
"sparse": false,
33
"Id": "56",
34
"SyncToken": "0",
35
"MetaData": {
36
"CreateTime": "2023-04-16T10:30:00-07:00",
37
"LastUpdatedTime": "2023-04-16T10:30:00-07:00"
38
},
39
"GivenName": "Jane",
40
"FamilyName": "Smith",
41
"DisplayName": "Jane Smith",
42
"PrintOnCheckName": "Jane Smith",
43
"Active": true,
44
"EmployeeNumber": "EMP002",
45
"Gender": "Female",
46
"HiredDate": "2023-02-01",
47
"PrimaryPhone": {
48
"FreeFormNumber": "+1 (555) 234-5678"
49
},
50
"Mobile": {
51
"FreeFormNumber": "+1 (555) 876-5432"
52
}
53
}
54
],
55
"startPosition": 1,
56
"maxResults": 5
57
},
58
"time": "2023-04-20T14:35:42.123-07:00"
59
}

List invoices
Copy

List all invoices in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "TxnDate",
7
"operator": ">=",
8
"value": "2023-01-01"
9
},
10
{
11
"entity": "Balance",
12
"operator": ">",
13
"value": 0
14
}
15
],
16
"order_by": {
17
"value": "TxnDate",
18
"direction": "DESC"
19
},
20
"start_position": 1,
21
"max_results": 10
22
}

Sample Output

1
{
2
"QueryResponse": {
3
"Invoice": [
4
{
5
"Deposit": 0,
6
"AllowIPNPayment": true,
7
"AllowOnlinePayment": true,
8
"AllowOnlineCreditCardPayment": true,
9
"AllowOnlineACHPayment": false,
10
"domain": "QBO",
11
"sparse": false,
12
"Id": "1001",
13
"SyncToken": "0",
14
"MetaData": {
15
"CreateTime": "2023-05-15T09:00:00-07:00",
16
"LastUpdatedTime": "2023-05-15T09:00:00-07:00"
17
},
18
"CustomField": [],
19
"DocNumber": "INV-1001",
20
"TxnDate": "2023-05-15",
21
"CurrencyRef": {
22
"value": "USD",
23
"name": "United States Dollar"
24
},
25
"ExchangeRate": 1,
26
"LinkedTxn": [],
27
"Line": [
28
{
29
"Id": "1",
30
"LineNum": 1,
31
"Description": "Consulting Services",
32
"Amount": 1000,
33
"DetailType": "SalesItemLineDetail",
34
"SalesItemLineDetail": {
35
"ItemRef": {
36
"value": "1",
37
"name": "Consulting"
38
},
39
"UnitPrice": 100,
40
"Qty": 10,
41
"TaxCodeRef": {
42
"value": "TAX"
43
}
44
},
45
"SubTotalLineDetail": {},
46
"DescriptionLineDetail": {
47
"ServiceDate": "2023-05-15"
48
}
49
}
50
],
51
"TxnTaxDetail": {
52
"TotalTax": 80,
53
"TaxLine": [
54
{
55
"Amount": 80,
56
"DetailType": "TaxLineDetail",
57
"TaxLineDetail": {
58
"TaxRateRef": {
59
"value": "2"
60
},
61
"PercentBased": true,
62
"TaxPercent": 8,
63
"NetAmountTaxable": 1000
64
}
65
}
66
]
67
},
68
"CustomerRef": {
69
"value": "2",
70
"name": "John Doe"
71
},
72
"BillAddr": {
73
"Id": "3",
74
"Line1": "123 Main St",
75
"City": "Anytown",
76
"PostalCode": "12345",
77
"Lat": "37.7749",
78
"Long": "-122.4194"
79
},
80
"SalesTermRef": {
81
"value": "3"
82
},
83
"DueDate": "2023-06-14",
84
"GlobalTaxCalculation": "TaxExcluded",
85
"TotalAmt": 1080,
86
"HomeTotalAmt": 1080,
87
"PrintStatus": "NeedToPrint",
88
"EmailStatus": "NotSet",
89
"Balance": 1080,
90
"BillEmail": {
91
"Address": "john.doe@example.com"
92
},
93
"ShipAddr": {
94
"Id": "3",
95
"Line1": "123 Main St",
96
"City": "Anytown",
97
"PostalCode": "12345",
98
"Lat": "37.7749",
99
"Long": "-122.4194"
100
}
101
}
102
],
103
"startPosition": 1,
104
"maxResults": 10,
105
"totalCount": 1
106
},
107
"time": "2023-05-15T10:00:00-07:00"
108
}

List items
Copy

List all items in your company.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"group": false,
5
"where": [
6
{
7
"entity": "Name",
8
"operator": "LIKE",
9
"value": "Office%"
10
}
11
],
12
"order_by": {
13
"value": "Name",
14
"direction": "ASC"
15
},
16
"start_position": 1,
17
"max_results": 5
18
}

Sample Output

1
{
2
"QueryResponse": {
3
"Item": [
4
{
5
"Name": "Office Chair",
6
"Description": "Ergonomic office chair",
7
"Active": true,
8
"FullyQualifiedName": "Office Chair",
9
"Taxable": true,
10
"SalesTaxIncluded": false,
11
"UnitPrice": 199.99,
12
"Type": "Inventory",
13
"IncomeAccountRef": {
14
"value": "79",
15
"name": "Sales of Product Income"
16
},
17
"PurchaseDesc": "Ergonomic office chair",
18
"PurchaseTaxIncluded": false,
19
"PurchaseCost": 150,
20
"ExpenseAccountRef": {
21
"value": "80",
22
"name": "Cost of Goods Sold"
23
},
24
"TrackQtyOnHand": true,
25
"SalesTaxCodeRef": {
26
"value": "2",
27
"name": "Standard Rate"
28
},
29
"PurchaseTaxCodeRef": {
30
"value": "2",
31
"name": "Standard Rate"
32
},
33
"domain": "QBO",
34
"sparse": false,
35
"Id": "37",
36
"SyncToken": "0",
37
"MetaData": {
38
"CreateTime": "2023-04-15T09:00:00-07:00",
39
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
40
},
41
"AssetAccountRef": {
42
"value": "81",
43
"name": "Inventory Asset"
44
},
45
"QtyOnHand": 50,
46
"InvStartDate": "2023-04-15"
47
},
48
{
49
"Name": "Office Desk",
50
"Description": "Standard office desk",
51
"Active": true,
52
"FullyQualifiedName": "Office Desk",
53
"Taxable": true,
54
"SalesTaxIncluded": false,
55
"UnitPrice": 299.99,
56
"Type": "Inventory",
57
"IncomeAccountRef": {
58
"value": "79",
59
"name": "Sales of Product Income"
60
},
61
"PurchaseDesc": "Standard office desk",
62
"PurchaseTaxIncluded": false,
63
"PurchaseCost": 200,
64
"ExpenseAccountRef": {
65
"value": "80",
66
"name": "Cost of Goods Sold"
67
},
68
"TrackQtyOnHand": true,
69
"SalesTaxCodeRef": {
70
"value": "2",
71
"name": "Standard Rate"
72
},
73
"PurchaseTaxCodeRef": {
74
"value": "2",
75
"name": "Standard Rate"
76
},
77
"domain": "QBO",
78
"sparse": false,
79
"Id": "38",
80
"SyncToken": "0",
81
"MetaData": {
82
"CreateTime": "2023-04-15T09:15:00-07:00",
83
"LastUpdatedTime": "2023-04-15T09:15:00-07:00"
84
},
85
"AssetAccountRef": {
86
"value": "81",
87
"name": "Inventory Asset"
88
},
89
"QtyOnHand": 30,
90
"InvStartDate": "2023-04-15"
91
}
92
],
93
"startPosition": 1,
94
"maxResults": 5
95
},
96
"time": "2023-04-15T10:00:00-07:00"
97
}

List payment methods
Copy

List all payment methods in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "Active",
7
"operator": "=",
8
"value": true
9
}
10
],
11
"order_by": {
12
"value": "Name",
13
"direction": "ASC"
14
},
15
"start_position": 1,
16
"max_results": 10
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"PaymentMethod": [
4
{
5
"Name": "Cash",
6
"Active": true,
7
"Type": "CASH",
8
"domain": "QBO",
9
"sparse": false,
10
"Id": "1",
11
"SyncToken": "0",
12
"MetaData": {
13
"CreateTime": "2023-05-01T10:00:00-07:00",
14
"LastUpdatedTime": "2023-05-01T10:00:00-07:00"
15
}
16
},
17
{
18
"Name": "Check",
19
"Active": true,
20
"Type": "CHECK",
21
"domain": "QBO",
22
"sparse": false,
23
"Id": "2",
24
"SyncToken": "0",
25
"MetaData": {
26
"CreateTime": "2023-05-01T10:05:00-07:00",
27
"LastUpdatedTime": "2023-05-01T10:05:00-07:00"
28
}
29
},
30
{
31
"Name": "Credit Card",
32
"Active": true,
33
"Type": "CREDIT_CARD",
34
"domain": "QBO",
35
"sparse": false,
36
"Id": "3",
37
"SyncToken": "0",
38
"MetaData": {
39
"CreateTime": "2023-05-01T10:10:00-07:00",
40
"LastUpdatedTime": "2023-05-01T10:10:00-07:00"
41
}
42
}
43
],
44
"startPosition": 1,
45
"maxResults": 10
46
},
47
"time": "2023-05-15T14:30:00-07:00"
48
}

List payments
Copy

List all payments in your company, from a given date.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"date": "2023-05-01T00:00:00Z",
5
"where": [
6
{
7
"entity": "TotalAmt",
8
"operator": ">",
9
"value": 1000
10
}
11
],
12
"order_by": {
13
"value": "TxnDate",
14
"direction": "DESC"
15
},
16
"start_position": 1,
17
"max_results": 10
18
}

Sample Output

1
{
2
"QueryResponse": {
3
"Payment": [
4
{
5
"CustomerRef": {
6
"value": "1",
7
"name": "John Doe"
8
},
9
"DepositToAccountRef": {
10
"value": "35"
11
},
12
"PaymentMethodRef": {
13
"value": "3"
14
},
15
"PaymentRefNum": "1001",
16
"TotalAmt": 1500,
17
"UnappliedAmt": 0,
18
"ProcessPayment": true,
19
"domain": "QBO",
20
"sparse": false,
21
"Id": "123",
22
"SyncToken": "0",
23
"MetaData": {
24
"CreateTime": "2023-05-15T09:00:00-07:00",
25
"LastUpdatedTime": "2023-05-15T09:00:00-07:00"
26
},
27
"TxnDate": "2023-05-15",
28
"CurrencyRef": {
29
"value": "USD",
30
"name": "United States Dollar"
31
},
32
"LinkedTxn": [
33
{
34
"TxnId": "100",
35
"TxnType": "Invoice"
36
}
37
],
38
"Line": [
39
{
40
"Amount": 1500,
41
"LinkedTxn": [
42
{
43
"TxnId": "100",
44
"TxnType": "Invoice"
45
}
46
],
47
"LineEx": {
48
"any": [
49
{
50
"name": "PaymentMethodType",
51
"declaredType": "com.intuit.schema.finance.v3.IPPPaymentMethodTypeEnum",
52
"scope": "com.intuit.schema.finance.v3",
53
"value": {
54
"Name": "PaymentMethodType",
55
"Value": "CreditCard"
56
},
57
"nil": false,
58
"globalScope": false,
59
"typeSubstituted": false
60
}
61
]
62
}
63
}
64
]
65
}
66
],
67
"startPosition": 1,
68
"maxResults": 10
69
},
70
"time": "2023-05-15T16:30:45.123Z"
71
}

List purchases
Copy

List all purchases in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "TotalAmt",
7
"operator": ">",
8
"value": 1000
9
},
10
{
11
"entity": "TxnDate",
12
"operator": ">=",
13
"value": "2023-01-01"
14
}
15
],
16
"order_by": {
17
"value": "TxnDate",
18
"direction": "DESC"
19
},
20
"start_position": 1,
21
"max_results": 10
22
}

Sample Output

1
{
2
"QueryResponse": {
3
"Purchase": [
4
{
5
"AccountRef": {
6
"value": "42",
7
"name": "Checking Account"
8
},
9
"PaymentType": "Check",
10
"Credit": false,
11
"TotalAmt": 1500,
12
"PurchaseEx": {
13
"any": [
14
{
15
"name": "CustomField",
16
"declaredType": "CustomField",
17
"scope": "User",
18
"value": {
19
"Name": "Project",
20
"Value": "Office Renovation"
21
},
22
"nil": false,
23
"globalScope": true,
24
"typeSubstituted": false
25
}
26
]
27
},
28
"domain": "QBO",
29
"sparse": false,
30
"Id": "123",
31
"SyncToken": "0",
32
"MetaData": {
33
"CreateTime": "2023-05-15T09:00:00-07:00",
34
"LastUpdatedTime": "2023-05-15T09:00:00-07:00"
35
},
36
"TxnDate": "2023-05-15",
37
"CurrencyRef": {
38
"value": "USD",
39
"name": "United States Dollar"
40
},
41
"Line": [
42
{
43
"Id": "1",
44
"Amount": 1500,
45
"DetailType": "AccountBasedExpenseLineDetail",
46
"AccountBasedExpenseLineDetail": {
47
"AccountRef": {
48
"value": "72",
49
"name": "Office Supplies"
50
},
51
"BillableStatus": "NotBillable",
52
"TaxCodeRef": {
53
"value": "TAX"
54
}
55
}
56
}
57
]
58
}
59
],
60
"startPosition": 1,
61
"maxResults": 10
62
},
63
"time": "2023-05-15T10:00:00-07:00"
64
}

List tax codes
Copy

List all tax codes in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "Name",
7
"operator": "LIKE",
8
"value": "Sales Tax%"
9
}
10
],
11
"order_by": {
12
"value": "Name",
13
"direction": "ASC"
14
},
15
"start_position": 1,
16
"max_results": 5
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"TaxCode": [
4
{
5
"Name": "Sales Tax",
6
"Description": "Standard sales tax",
7
"Active": true,
8
"Taxable": true,
9
"TaxGroup": false,
10
"SalesTaxRateList": {
11
"TaxRateDetail": [
12
{
13
"TaxRateRef": {
14
"value": "1",
15
"name": "State Tax"
16
},
17
"TaxTypeApplicable": "Sales",
18
"TaxOrder": 1
19
}
20
]
21
},
22
"PurchaseTaxRateList": {
23
"TaxRateDetail": []
24
},
25
"domain": "QBO",
26
"sparse": false,
27
"Id": "2",
28
"SyncToken": "0",
29
"MetaData": {
30
"CreateTime": "2023-04-15T09:00:00-07:00",
31
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
32
}
33
},
34
{
35
"Name": "Sales Tax Exempt",
36
"Description": "Tax exempt sales",
37
"Active": true,
38
"Taxable": false,
39
"TaxGroup": false,
40
"SalesTaxRateList": {
41
"TaxRateDetail": []
42
},
43
"PurchaseTaxRateList": {
44
"TaxRateDetail": []
45
},
46
"domain": "QBO",
47
"sparse": false,
48
"Id": "3",
49
"SyncToken": "0",
50
"MetaData": {
51
"CreateTime": "2023-04-15T09:05:00-07:00",
52
"LastUpdatedTime": "2023-04-15T09:05:00-07:00"
53
}
54
}
55
],
56
"startPosition": 1,
57
"maxResults": 5,
58
"totalCount": 2
59
},
60
"time": "2023-04-15T10:00:00-07:00"
61
}

List tax rates
Copy

List all tax rates in your company.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "Active",
7
"operator": "=",
8
"value": true
9
}
10
],
11
"order_by": {
12
"value": "Name",
13
"direction": "ASC"
14
},
15
"start_position": 1,
16
"max_results": 5
17
}

Sample Output

1
{
2
"QueryResponse": {
3
"TaxRate": [
4
{
5
"Name": "CA State Tax",
6
"Description": "California State Tax",
7
"Active": true,
8
"RateValue": 7.25,
9
"AgencyRef": {
10
"value": "2"
11
},
12
"TaxReturnLineRef": {
13
"value": "3"
14
},
15
"SpecialTaxType": "NONE",
16
"DisplayType": "ReadOnly",
17
"domain": "QBO",
18
"sparse": false,
19
"Id": "1",
20
"SyncToken": "0",
21
"MetaData": {
22
"CreateTime": "2023-04-15T09:00:00-07:00",
23
"LastUpdatedTime": "2023-04-15T09:00:00-07:00"
24
}
25
},
26
{
27
"Name": "NY City Tax",
28
"Description": "New York City Tax",
29
"Active": true,
30
"RateValue": 4.5,
31
"AgencyRef": {
32
"value": "4"
33
},
34
"TaxReturnLineRef": {
35
"value": "5"
36
},
37
"SpecialTaxType": "NONE",
38
"DisplayType": "ReadOnly",
39
"domain": "QBO",
40
"sparse": false,
41
"Id": "2",
42
"SyncToken": "0",
43
"MetaData": {
44
"CreateTime": "2023-04-15T10:30:00-07:00",
45
"LastUpdatedTime": "2023-04-15T10:30:00-07:00"
46
}
47
}
48
],
49
"startPosition": 1,
50
"maxResults": 5,
51
"totalCount": 2
52
},
53
"time": "2023-04-15T11:00:00-07:00"
54
}

List time activities
Copy

List all time activites in your company.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"where": [
5
{
6
"entity": "TxnDate",
7
"operator": ">=",
8
"value": "2023-01-01"
9
},
10
{
11
"entity": "EmployeeRef.name",
12
"operator": "=",
13
"value": "John Doe"
14
}
15
],
16
"order_by": {
17
"value": "TxnDate",
18
"direction": "DESC"
19
},
20
"start_position": 1,
21
"max_results": 100
22
}

Sample Output

1
{
2
"QueryResponse": {
3
"TimeActivity": [
4
{
5
"TxnDate": "2023-05-15",
6
"NameOf": "Employee",
7
"EmployeeRef": {
8
"value": "55",
9
"name": "John Doe"
10
},
11
"CustomerRef": {
12
"value": "23",
13
"name": "Acme Corp"
14
},
15
"ItemRef": {
16
"value": "1",
17
"name": "Web Development"
18
},
19
"BillableStatus": "Billable",
20
"Taxable": true,
21
"HourlyRate": 75,
22
"BreakHours": 0,
23
"BreakMinutes": 30,
24
"StartTime": "09:00:00",
25
"EndTime": "17:30:00",
26
"Description": "Worked on client website redesign",
27
"domain": "QBO",
28
"sparse": false,
29
"Id": "123",
30
"SyncToken": "0",
31
"MetaData": {
32
"CreateTime": "2023-05-15T18:00:00-07:00",
33
"LastUpdatedTime": "2023-05-15T18:00:00-07:00"
34
}
35
}
36
],
37
"startPosition": 1,
38
"maxResults": 100
39
},
40
"time": "2023-05-16T10:30:00-07:00"
41
}

List vendors
Copy

List all vendors in your company.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"display_name": "ABC Supplies",
5
"where": [
6
{
7
"entity": "DisplayName",
8
"operator": "LIKE",
9
"value": "%Supplies%"
10
}
11
],
12
"order_by": {
13
"value": "DisplayName",
14
"direction": "ASC"
15
},
16
"start_position": 1,
17
"max_results": 10
18
}

Sample Output

1
{
2
"QueryResponse": {
3
"Vendor": [
4
{
5
"Balance": 1500,
6
"Vendor1099": true,
7
"CurrencyRef": {
8
"value": "USD",
9
"name": "United States Dollar"
10
},
11
"domain": "QBO",
12
"sparse": false,
13
"Id": "56",
14
"SyncToken": "0",
15
"MetaData": {
16
"CreateTime": "2023-04-15T09:30:00-07:00",
17
"LastUpdatedTime": "2023-04-15T09:30:00-07:00"
18
},
19
"DisplayName": "ABC Supplies",
20
"PrintOnCheckName": "ABC Supplies Inc.",
21
"Active": true
22
},
23
{
24
"Balance": 750.5,
25
"Vendor1099": false,
26
"CurrencyRef": {
27
"value": "USD",
28
"name": "United States Dollar"
29
},
30
"domain": "QBO",
31
"sparse": false,
32
"Id": "57",
33
"SyncToken": "0",
34
"MetaData": {
35
"CreateTime": "2023-04-16T11:45:00-07:00",
36
"LastUpdatedTime": "2023-04-16T11:45:00-07:00"
37
},
38
"DisplayName": "XYZ Office Supplies",
39
"PrintOnCheckName": "XYZ Office Supplies LLC",
40
"Active": true
41
}
42
],
43
"startPosition": 1,
44
"maxResults": 10
45
},
46
"time": "2023-04-17T14:22:30-07:00"
47
}

Raw HTTP request (advanced)
Copy

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"method": "GET",
5
"url": {
6
"endpoint": "/v3/company/1234567890/query"
7
},
8
"headers": [
9
{
10
"key": "Accept",
11
"value": "application/json"
12
}
13
],
14
"query_parameters": [
15
{
16
"key": "query",
17
"value": "SELECT * FROM Customer WHERE DisplayName LIKE '%Smith%'"
18
}
19
],
20
"body": {
21
"none": null
22
},
23
"include_raw_body": false,
24
"parse_response": "true"
25
}

Sample Output

1
{
2
"response": {
3
"status_code": 200,
4
"headers": {
5
"Content-Type": "application/json",
6
"Date": "Wed, 21 Jul 2023 12:34:56 GMT",
7
"Server": "nginx"
8
},
9
"body": {
10
"QueryResponse": {
11
"Customer": [
12
{
13
"Id": "1",
14
"DisplayName": "John Smith",
15
"GivenName": "John",
16
"FamilyName": "Smith",
17
"PrimaryEmailAddr": {
18
"Address": "john.smith@example.com"
19
}
20
},
21
{
22
"Id": "2",
23
"DisplayName": "Jane Smith",
24
"GivenName": "Jane",
25
"FamilyName": "Smith",
26
"PrimaryEmailAddr": {
27
"Address": "jane.smith@example.com"
28
}
29
}
30
],
31
"startPosition": 1,
32
"maxResults": 2,
33
"totalCount": 2
34
},
35
"time": "2023-07-21T12:34:56.789Z"
36
}
37
}
38
}

Run query
Copy

Run a custom SQL query.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "4620816365177497600",
4
"entity": "Invoice",
5
"where": [
6
{
7
"entity": "TotalAmt",
8
"operator": ">",
9
"value": 1000
10
},
11
{
12
"entity": "DueDate",
13
"operator": "<=",
14
"value": "2023-06-30"
15
}
16
],
17
"order_by": {
18
"value": "TotalAmt",
19
"direction": "DESC"
20
},
21
"start_position": 1,
22
"max_results": 50
23
}

Sample Output

1
{
2
"QueryResponse": {
3
"Invoice": [
4
{
5
"Id": "123",
6
"SyncToken": "0",
7
"MetaData": {
8
"CreateTime": "2023-05-15T10:00:00-07:00",
9
"LastUpdatedTime": "2023-05-15T10:00:00-07:00"
10
},
11
"CustomField": [],
12
"DocNumber": "1001",
13
"TxnDate": "2023-05-15",
14
"CurrencyRef": {
15
"value": "USD",
16
"name": "United States Dollar"
17
},
18
"LinkedTxn": [],
19
"Line": [
20
{
21
"Id": "1",
22
"LineNum": 1,
23
"Description": "Consulting Services",
24
"Amount": 2000,
25
"DetailType": "SalesItemLineDetail",
26
"SalesItemLineDetail": {
27
"ItemRef": {
28
"value": "1",
29
"name": "Services"
30
},
31
"UnitPrice": 100,
32
"Qty": 20,
33
"TaxCodeRef": {
34
"value": "NON"
35
}
36
}
37
}
38
],
39
"TxnTaxDetail": {
40
"TotalTax": 0
41
},
42
"CustomerRef": {
43
"value": "1",
44
"name": "John Doe"
45
},
46
"CustomerMemo": {
47
"value": "Thank you for your business"
48
},
49
"BillAddr": {
50
"Id": "2",
51
"Line1": "123 Main St",
52
"City": "Anytown",
53
"CountrySubDivisionCode": "CA",
54
"PostalCode": "12345",
55
"Lat": "37.4275",
56
"Long": "-122.1697"
57
},
58
"TotalAmt": 2000,
59
"ApplyTaxAfterDiscount": false,
60
"PrintStatus": "NeedToPrint",
61
"EmailStatus": "NotSet",
62
"Balance": 2000,
63
"DueDate": "2023-06-14"
64
}
65
],
66
"startPosition": 1,
67
"maxResults": 50,
68
"totalCount": 1
69
},
70
"time": "2023-05-15T12:00:00.000-07:00"
71
}

Update bill
Copy

Update a bill.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"bill_id": "123",
5
"sync_token": "1",
6
"vendor_ref": {
7
"value": "56",
8
"name": "ABC Supplies"
9
},
10
"lines": [
11
{
12
"account_based_expense_line": {
13
"amount": 500,
14
"account_ref": {
15
"value": "60",
16
"name": "Office Supplies"
17
},
18
"description": "Monthly office supplies",
19
"billable_status": "NotBillable"
20
}
21
},
22
{
23
"item_based_expense_line": {
24
"amount": 1000,
25
"item_ref": {
26
"value": "22",
27
"name": "Printer"
28
},
29
"qty": 2,
30
"unit_price": 500,
31
"description": "New printers for office"
32
}
33
}
34
],
35
"currency_ref": {
36
"value": "USD",
37
"name": "United States Dollar"
38
},
39
"private_note": "Updated bill for office supplies and equipment",
40
"txn_date": "2023-06-15T00:00:00Z"
41
}

Sample Output

1
{
2
"Bill": {
3
"DueDate": "2023-07-15",
4
"Balance": 1500,
5
"domain": "QBO",
6
"sparse": false,
7
"Id": "123",
8
"SyncToken": "2",
9
"MetaData": {
10
"CreateTime": "2023-06-01T10:00:00-07:00",
11
"LastUpdatedTime": "2023-06-15T14:30:00-07:00"
12
},
13
"TxnDate": "2023-06-15",
14
"CurrencyRef": {
15
"value": "USD",
16
"name": "United States Dollar"
17
},
18
"Line": [
19
{
20
"Id": "1",
21
"LineNum": 1,
22
"Description": "Monthly office supplies",
23
"Amount": 500,
24
"DetailType": "AccountBasedExpenseLineDetail",
25
"AccountBasedExpenseLineDetail": {
26
"AccountRef": {
27
"value": "60",
28
"name": "Office Supplies"
29
},
30
"BillableStatus": "NotBillable",
31
"TaxCodeRef": {
32
"value": "NON"
33
}
34
}
35
},
36
{
37
"Id": "2",
38
"LineNum": 2,
39
"Description": "New printers for office",
40
"Amount": 1000,
41
"DetailType": "ItemBasedExpenseLineDetail",
42
"ItemBasedExpenseLineDetail": {
43
"ItemRef": {
44
"value": "22",
45
"name": "Printer"
46
},
47
"Qty": 2,
48
"UnitPrice": 500
49
}
50
}
51
],
52
"VendorRef": {
53
"value": "56",
54
"name": "ABC Supplies"
55
},
56
"APAccountRef": {
57
"value": "33",
58
"name": "Accounts Payable"
59
},
60
"TotalAmt": 1500
61
},
62
"time": "2023-06-15T14:30:00-07:00"
63
}

Update customer (full)
Copy

Fully update a customer's details.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"id": "55",
5
"identifier": {
6
"display_name": "John Doe",
7
"given_name": "John",
8
"family_name": "Doe"
9
},
10
"company_name": "Doe Enterprises",
11
"print_on_check_name": "John Doe",
12
"active": "true",
13
"primary_phone": "555-123-4567",
14
"primary_email_addr": "john.doe@example.com",
15
"web_addr": "www.doeenterprises.com",
16
"taxable": {
17
"default_tax_code_ref": "TAX"
18
},
19
"bill_addr": {
20
"line_1": "123 Main St",
21
"city": "Anytown",
22
"country": "USA",
23
"postal_code": "12345"
24
},
25
"ship_addr": {
26
"line_1": "456 Shipping Ave",
27
"city": "Shipville",
28
"country": "USA",
29
"postal_code": "67890"
30
},
31
"notes": "Preferred customer",
32
"payment_method_ref": "3",
33
"currency_ref": "USD - US Dollar",
34
"preferred_delivery_method": "Email"
35
}

Sample Output

1
{
2
"Customer": {
3
"Id": "55",
4
"DisplayName": "John Doe",
5
"PrintOnCheckName": "John Doe",
6
"GivenName": "John",
7
"FamilyName": "Doe",
8
"FullyQualifiedName": "John Doe",
9
"CompanyName": "Doe Enterprises",
10
"Taxable": true,
11
"BillAddr": {
12
"Id": "1",
13
"Line1": "123 Main St",
14
"City": "Anytown",
15
"Country": "USA",
16
"PostalCode": "12345"
17
},
18
"ShipAddr": {
19
"Id": "2",
20
"Line1": "456 Shipping Ave",
21
"City": "Shipville",
22
"Country": "USA",
23
"PostalCode": "67890"
24
},
25
"Job": false,
26
"BillWithParent": false,
27
"Level": 0,
28
"PaymentMethodRef": {
29
"value": "3"
30
},
31
"Balance": 0,
32
"BalanceWithJobs": 0,
33
"CurrencyRef": {
34
"value": "USD",
35
"name": "US Dollar"
36
},
37
"PreferredDeliveryMethod": "Email",
38
"domain": "QBO",
39
"sparse": false,
40
"SyncToken": "0",
41
"MetaData": {
42
"CreateTime": "2023-04-15T10:00:00-07:00",
43
"LastUpdatedTime": "2023-04-15T10:00:00-07:00"
44
},
45
"Active": true,
46
"PrimaryPhone": {
47
"FreeFormNumber": "555-123-4567"
48
},
49
"PrimaryEmailAddr": {
50
"Address": "john.doe@example.com"
51
},
52
"WebAddr": {
53
"URI": "www.doeenterprises.com"
54
},
55
"DefaultTaxCodeRef": {
56
"value": "TAX"
57
}
58
},
59
"time": "2023-04-15T10:00:00.000-07:00"
60
}

Update customer (sparse)
Copy

Sparsely update a customer's details.

Sample Input

1
{
2
"access_token": "YOUR_ACCESS_TOKEN",
3
"realm_id": "YOUR_REALM_ID",
4
"id": "123",
5
"identifier": {
6
"display_name": "John Doe",
7
"given_name": "John",
8
"family_name": "Doe"
9
},
10
"company_name": "Doe Enterprises",
11
"primary_phone": "555-123-4567",
12
"primary_email_addr": "john.doe@example.com",
13
"bill_addr": {
14
"line_1": "123 Main St",
15
"city": "Anytown",
16
"country": "USA",
17
"postal_code": "12345"
18
},
19
"active": "true",
20
"preferred_delivery_method": "Email"
21
}

Sample Output

1
{
2
"Customer": {
3
"Id": "123",
4
"DisplayName": "John Doe",
5
"PrintOnCheckName": "John Doe",
6
"GivenName": "John",
7
"FamilyName": "Doe",
8
"FullyQualifiedName": "John Doe",
9
"CompanyName": "Doe Enterprises",
10
"BillAddr": {
11
"Id": "456",
12
"Line1": "123 Main St",
13
"City": "Anytown",
14
"Country": "USA",
15
"PostalCode": "12345"
16
},
17
"Job": false,
18
"Balance": 0,
19
"BalanceWithJobs": 0,
20
"CurrencyRef": {
21
"value": "USD",
22
"name": "United States Dollar"
23
},
24
"PreferredDeliveryMethod": "Email",
25
"domain": "QBO",
26
"sparse": false,
27
"SyncToken": "0",
28
"MetaData": {
29
"CreateTime": "2023-04-20T10:30:00-07:00",
30
"LastUpdatedTime": "2023-04-20T10:30:00-07:00"
31
},
32
"Active": true,
33
"PrimaryPhone": {
34
"FreeFormNumber": "555-123-4567"
35
},
36
"PrimaryEmailAddr": {
37
"Address": "john.doe@example.com"
38
}
39
},
40
"time": "2023-04-20T10:30:00-07:00"
41
}

Update employee
Copy

Update a employee's details.

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"id": "55",
5
"display_name": "John Doe",
6
"title": "Manager",
7
"given_name": "John",
8
"middle_name": "William",
9
"family_name": "Doe",
10
"suffix": "Jr",
11
"primary_addr": {
12
"line_1": "123 Main St",
13
"line_2": "Apt 4B",
14
"city": "Anytown",
15
"country": "USA",
16
"country_sub_division_code": "CA",
17
"postal_code": "12345"
18
},
19
"primary_email_addr": "john.doe@example.com",
20
"hired_date": "2022-01-15T00:00:00Z",
21
"billable_time": true,
22
"gender": "Male",
23
"bill_rate": 75.5,
24
"active": true,
25
"primary_phone": "555-123-4567",
26
"mobile": "555-987-6543",
27
"birth_date": "1985-06-20T00:00:00Z",
28
"s_s_n": "123-45-6789",
29
"employee_number": "EMP001",
30
"print_on_check_name": "John W. Doe Jr."
31
}

Sample Output

1
{
2
"Employee": {
3
"EmployeeNumber": "EMP001",
4
"SSN": "123-45-6789",
5
"PrimaryAddr": {
6
"Id": "1",
7
"Line1": "123 Main St",
8
"Line2": "Apt 4B",
9
"City": "Anytown",
10
"Country": "USA",
11
"CountrySubDivisionCode": "CA",
12
"PostalCode": "12345"
13
},
14
"BillableTime": true,
15
"BillRate": 75.5,
16
"BirthDate": "1985-06-20",
17
"Gender": "Male",
18
"HiredDate": "2022-01-15",
19
"domain": "QBO",
20
"sparse": false,
21
"Id": "55",
22
"SyncToken": "1",
23
"MetaData": {
24
"CreateTime": "2022-01-15T10:00:00-08:00",
25
"LastUpdatedTime": "2023-05-20T14:30:00-08:00"
26
},
27
"Title": "Manager",
28
"GivenName": "John",
29
"MiddleName": "William",
30
"FamilyName": "Doe",
31
"Suffix": "Jr",
32
"DisplayName": "John Doe",
33
"PrintOnCheckName": "John W. Doe Jr.",
34
"Active": true,
35
"PrimaryPhone": {
36
"FreeFormNumber": "555-123-4567"
37
},
38
"Mobile": {
39
"FreeFormNumber": "555-987-6543"
40
},
41
"PrimaryEmailAddr": {
42
"Address": "john.doe@example.com"
43
}
44
},
45
"time": "2023-05-20T14:30:00-08:00"
46
}

Update invoice
Copy

Update an invoice.

Sample Input

1
{
2
"access_token": "your_access_token_here",
3
"realm_id": "your_realm_id_here",
4
"id": "123",
5
"line": [
6
{
7
"sales_item_line_detail": {
8
"amount": 100,
9
"description": "Web Design Services",
10
"item_ref": "1",
11
"unit_price": 100,
12
"qty": 1
13
}
14
},
15
{
16
"sales_item_line_detail": {
17
"amount": 50,
18
"description": "Logo Design",
19
"item_ref": "2",
20
"unit_price": 50,
21
"qty": 1
22
}
23
}
24
],
25
"customer_ref": {
26
"value": "456",
27
"name": "John Doe"
28
},
29
"currency_ref": "USD - US Dollar",
30
"txn_date": "2023-06-15",
31
"due_date": "2023-07-15",
32
"private_note": "Internal note: Follow up in 2 weeks",
33
"customer_memo": "Thank you for your business!",
34
"total_amt": 150
35
}

Sample Output

1
{
2
"Invoice": {
3
"Id": "123",
4
"SyncToken": "0",
5
"MetaData": {
6
"CreateTime": "2023-06-15T10:00:00-07:00",
7
"LastUpdatedTime": "2023-06-15T10:00:00-07:00"
8
},
9
"CustomField": [],
10
"DocNumber": "1001",
11
"TxnDate": "2023-06-15",
12
"CurrencyRef": {
13
"value": "USD",
14
"name": "United States Dollar"
15
},
16
"LinkedTxn": [],
17
"Line": [
18
{
19
"Id": "1",
20
"LineNum": 1,
21
"Description": "Web Design Services",
22
"Amount": 100,
23
"DetailType": "SalesItemLineDetail",
24
"SalesItemLineDetail": {
25
"ItemRef": {
26
"value": "1",
27
"name": "Web Design"
28
},
29
"UnitPrice": 100,
30
"Qty": 1,
31
"TaxCodeRef": {
32
"value": "NON"
33
}
34
}
35
},
36
{
37
"Id": "2",
38
"LineNum": 2,
39
"Description": "Logo Design",
40
"Amount": 50,
41
"DetailType": "SalesItemLineDetail",
42
"SalesItemLineDetail": {
43
"ItemRef": {
44
"value": "2",
45
"name": "Logo Design"
46
},
47
"UnitPrice": 50,
48
"Qty": 1,
49
"TaxCodeRef": {
50
"value": "NON"
51
}
52
}
53
}
54
],
55
"TxnTaxDetail": {
56
"TotalTax": 0
57
},
58
"CustomerRef": {
59
"value": "456",
60
"name": "John Doe"
61
},
62
"CustomerMemo": {
63
"value": "Thank you for your business!"
64
},
65
"BillEmail": {
66
"Address": "johndoe@example.com"
67
},
68
"TotalAmt": 150,
69
"ApplyTaxAfterDiscount": false,
70
"PrintStatus": "NeedToPrint",
71
"EmailStatus": "NotSet",
72
"Balance": 150,
73
"Deposit": 0,
74
"AllowIPNPayment": false,
75
"AllowOnlinePayment": false,
76
"AllowOnlineCreditCardPayment": false,
77
"AllowOnlineACHPayment": false,
78
"DueDate": "2023-07-15",
79
"sparse": false,
80
"GlobalTaxCalculation": "TaxExcluded"
81
},
82
"time": "2023-06-15T10:00:00.000-07:00"
83
}

Update purchase
Copy

Update a purchase.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"purchase_id": "123",
5
"sync_token": "1",
6
"payment_type": "CreditCard",
7
"account_ref": {
8
"value": "42",
9
"name": "Credit Card Account"
10
},
11
"lines": [
12
{
13
"account_based_expense_line": {
14
"amount": 100,
15
"account_ref": {
16
"value": "55",
17
"name": "Office Supplies"
18
},
19
"description": "Office supplies purchase"
20
}
21
}
22
],
23
"currency_ref": {
24
"value": "USD",
25
"name": "United States Dollar"
26
},
27
"private_note": "Monthly office supply restock"
28
}

Sample Output

1
{
2
"Purchase": {
3
"AccountRef": {
4
"value": "42",
5
"name": "Credit Card Account"
6
},
7
"PaymentType": "CreditCard",
8
"Credit": false,
9
"TotalAmt": 100,
10
"domain": "QBO",
11
"sparse": false,
12
"Id": "123",
13
"SyncToken": "2",
14
"MetaData": {
15
"CreateTime": "2023-04-15T09:00:00-07:00",
16
"LastUpdatedTime": "2023-04-15T10:30:00-07:00"
17
},
18
"TxnDate": "2023-04-15",
19
"CurrencyRef": {
20
"value": "USD",
21
"name": "United States Dollar"
22
},
23
"Line": [
24
{
25
"Id": "1",
26
"Amount": 100,
27
"DetailType": "AccountBasedExpenseLineDetail",
28
"AccountBasedExpenseLineDetail": {
29
"AccountRef": {
30
"value": "55",
31
"name": "Office Supplies"
32
},
33
"BillableStatus": "NotBillable",
34
"TaxCodeRef": {
35
"value": "NON"
36
}
37
}
38
}
39
],
40
"PrivateNote": "Monthly office supply restock"
41
},
42
"time": "2023-04-15T10:30:00-07:00"
43
}

Update time activity
Copy

Update a time activity

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890",
4
"id": "123",
5
"name_of": {
6
"employee_id": "456",
7
"name": "John Doe"
8
},
9
"time": {
10
"start_time": {
11
"hour": "09",
12
"minute": "00"
13
},
14
"end_time": {
15
"hour": "17",
16
"minute": "30"
17
}
18
},
19
"billable_status": {
20
"taxable": true,
21
"hourly_rate": 75.5
22
},
23
"txn_date": "2023-05-15T00:00:00Z",
24
"description": "Project work for Client XYZ",
25
"customer_ref": {
26
"value": "789",
27
"name": "Client XYZ"
28
},
29
"item_ref": {
30
"value": "101",
31
"name": "Consulting Services"
32
},
33
"class_ref": {
34
"value": "202",
35
"name": "IT Department"
36
},
37
"department_ref": {
38
"value": "303",
39
"name": "Development"
40
},
41
"break_hours": 1,
42
"break_minutes": 30
43
}

Sample Output

1
{
2
"TimeActivity": {
3
"TxnDate": "2023-05-15",
4
"NameOf": "Employee",
5
"EmployeeRef": {
6
"value": "456",
7
"name": "John Doe"
8
},
9
"CustomerRef": {
10
"value": "789",
11
"name": "Client XYZ"
12
},
13
"ItemRef": {
14
"value": "101",
15
"name": "Consulting Services"
16
},
17
"DepartmentRef": {
18
"value": "303",
19
"name": "Development"
20
},
21
"ClassRef": {
22
"value": "202",
23
"name": "IT Department"
24
},
25
"BillableStatus": "Billable",
26
"Taxable": true,
27
"HourlyRate": 75.5,
28
"BreakHours": 1,
29
"BreakMinutes": 30,
30
"StartTime": "2023-05-15T09:00:00-07:00",
31
"EndTime": "2023-05-15T17:30:00-07:00",
32
"Description": "Project work for Client XYZ",
33
"domain": "QBO",
34
"sparse": false,
35
"Id": "123",
36
"SyncToken": "0",
37
"MetaData": {
38
"CreateTime": "2023-05-15T10:00:00-07:00",
39
"LastUpdatedTime": "2023-05-15T18:00:00-07:00"
40
}
41
},
42
"time": "2023-05-15T18:00:00-07:00"
43
}

Update transfer
Copy

Update a transfer by its ID.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"transfer_id": "123",
5
"amount": "1000.00",
6
"from": "35",
7
"to": "36"
8
}

Sample Output

1
{
2
"Transfer": {
3
"FromAccountRef": {
4
"value": "35",
5
"name": "Checking Account"
6
},
7
"ToAccountRef": {
8
"value": "36",
9
"name": "Savings Account"
10
},
11
"Amount": 1000,
12
"domain": "QBO",
13
"sparse": false,
14
"Id": "123",
15
"SyncToken": "1",
16
"MetaData": {
17
"CreateTime": "2023-04-15T09:00:00-07:00",
18
"LastUpdatedTime": "2023-04-15T10:30:00-07:00"
19
},
20
"TxnDate": "2023-04-15",
21
"CurrencyRef": {
22
"value": "USD",
23
"name": "United States Dollar"
24
}
25
},
26
"time": "2023-04-15T10:30:00-07:00"
27
}

Update vendor
Copy

Update a vendor's details.

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890",
4
"id": "56",
5
"identifier": {
6
"display_name": "ABC Supplies Inc.",
7
"given_name": "John",
8
"family_name": "Doe"
9
},
10
"bill_addr": {
11
"line_1": "123 Main St",
12
"city": "Anytown",
13
"country": "United States",
14
"country_sub_division_code": "CA",
15
"postal_code": "12345"
16
},
17
"currency_ref": "USD - US Dollar",
18
"term_ref": {
19
"value": "3",
20
"name": "Net 30"
21
},
22
"active": true,
23
"primary_phone": "555-123-4567",
24
"primary_email_addr": "john.doe@abcsupplies.com",
25
"web_addr": "https://www.abcsupplies.com",
26
"vendor_1099": true,
27
"company_name": "ABC Supplies Inc.",
28
"tax_identifier": "12-3456789",
29
"acct_num": "V-1001",
30
"print_on_check_name": "ABC Supplies"
31
}

Sample Output

1
{
2
"Vendor": {
3
"MiddleName": null,
4
"sparse": false,
5
"Mobile": null,
6
"CurrencyRef": {
7
"value": "USD",
8
"name": "United States Dollar"
9
},
10
"TermRef": {
11
"value": "3",
12
"name": "Net 30"
13
},
14
"domain": "QBO",
15
"WebAddr": {
16
"URI": "https://www.abcsupplies.com"
17
},
18
"Active": true,
19
"Vendor1099": true,
20
"PrintOnCheckName": "ABC Supplies",
21
"CompanyName": "ABC Supplies Inc.",
22
"GivenName": "John",
23
"PrimaryEmailAddr": {
24
"Address": "john.doe@abcsupplies.com"
25
},
26
"PrimaryPhone": {
27
"FreeFormNumber": "555-123-4567"
28
},
29
"DisplayName": "ABC Supplies Inc.",
30
"FamilyName": "Doe",
31
"MetaData": {
32
"CreateTime": "2023-04-15T09:00:00-07:00",
33
"LastUpdatedTime": "2023-04-15T10:30:00-07:00"
34
},
35
"Suffix": null,
36
"AcctNum": "V-1001",
37
"AlternatePhone": null,
38
"TaxIdentifier": "12-3456789",
39
"BillAddr": {
40
"Line1": "123 Main St",
41
"City": "Anytown",
42
"Country": "United States",
43
"CountrySubDivisionCode": "CA",
44
"PostalCode": "12345",
45
"Id": "12"
46
},
47
"Title": null,
48
"Id": "56",
49
"Balance": 0,
50
"Fax": null,
51
"SyncToken": "2"
52
},
53
"time": "2023-04-15T10:30:00-07:00"
54
}

DDL operations
Copy

List accounts (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
[
2
{
3
"value": "1",
4
"text": "Cash and cash equivalents"
5
},
6
{
7
"value": "2",
8
"text": "Accounts receivable (A/R)"
9
},
10
{
11
"value": "3",
12
"text": "Inventory"
13
},
14
{
15
"value": "4",
16
"text": "Property, plant and equipment"
17
},
18
{
19
"value": "5",
20
"text": "Accounts payable (A/P)"
21
},
22
{
23
"value": "6",
24
"text": "Sales revenue"
25
},
26
{
27
"value": "7",
28
"text": "Cost of goods sold"
29
},
30
{
31
"value": "8",
32
"text": "Operating expenses"
33
}
34
]

List classes (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
[
2
{
3
"value": "1",
4
"label": "Sales"
5
},
6
{
7
"value": "2",
8
"label": "Marketing"
9
},
10
{
11
"value": "3",
12
"label": "Operations"
13
},
14
{
15
"value": "4",
16
"label": "Finance"
17
},
18
{
19
"value": "5",
20
"label": "Human Resources"
21
}
22
]

List credit memos (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "123456789"
4
}

Sample Output

1
{
2
"creditMemos": [
3
{
4
"Id": "1001",
5
"SyncToken": "0",
6
"MetaData": {
7
"CreateTime": "2023-05-15T09:30:00Z",
8
"LastUpdatedTime": "2023-05-15T09:30:00Z"
9
},
10
"CustomerId": "456",
11
"CustomerRef": {
12
"value": "456",
13
"name": "John Doe"
14
},
15
"TxnDate": "2023-05-15",
16
"TotalAmt": 150,
17
"Balance": 150,
18
"CurrencyRef": {
19
"value": "USD",
20
"name": "United States Dollar"
21
},
22
"Line": [
23
{
24
"Id": "1",
25
"LineNum": 1,
26
"Description": "Product return",
27
"Amount": 150,
28
"DetailType": "SalesItemLineDetail",
29
"SalesItemLineDetail": {
30
"ItemRef": {
31
"value": "55",
32
"name": "Widget A"
33
},
34
"UnitPrice": 75,
35
"Qty": 2,
36
"TaxCodeRef": {
37
"value": "TAX"
38
}
39
}
40
}
41
]
42
},
43
{
44
"Id": "1002",
45
"SyncToken": "0",
46
"MetaData": {
47
"CreateTime": "2023-05-16T14:45:00Z",
48
"LastUpdatedTime": "2023-05-16T14:45:00Z"
49
},
50
"CustomerId": "789",
51
"CustomerRef": {
52
"value": "789",
53
"name": "Jane Smith"
54
},
55
"TxnDate": "2023-05-16",
56
"TotalAmt": 75.5,
57
"Balance": 75.5,
58
"CurrencyRef": {
59
"value": "USD",
60
"name": "United States Dollar"
61
},
62
"Line": [
63
{
64
"Id": "1",
65
"LineNum": 1,
66
"Description": "Service credit",
67
"Amount": 75.5,
68
"DetailType": "SalesItemLineDetail",
69
"SalesItemLineDetail": {
70
"ItemRef": {
71
"value": "66",
72
"name": "Consultation"
73
},
74
"UnitPrice": 75.5,
75
"Qty": 1,
76
"TaxCodeRef": {
77
"value": "NON"
78
}
79
}
80
}
81
]
82
}
83
]
84
}

List departments (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
[
2
{
3
"value": "1",
4
"label": "Sales"
5
},
6
{
7
"value": "2",
8
"label": "Marketing"
9
},
10
{
11
"value": "3",
12
"label": "Finance"
13
},
14
{
15
"value": "4",
16
"label": "Human Resources"
17
},
18
{
19
"value": "5",
20
"label": "Operations"
21
}
22
]

List discount accounts (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
{
2
"accounts": [
3
{
4
"id": "75",
5
"name": "Sales Discounts",
6
"accountType": "Income",
7
"accountSubType": "DiscountsRefundsGiven"
8
},
9
{
10
"id": "76",
11
"name": "Early Payment Discounts",
12
"accountType": "Income",
13
"accountSubType": "DiscountsRefundsGiven"
14
},
15
{
16
"id": "77",
17
"name": "Promotional Discounts",
18
"accountType": "Income",
19
"accountSubType": "DiscountsRefundsGiven"
20
}
21
]
22
}

List entities (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
{
2
"entities": [
3
{
4
"name": "Account",
5
"displayName": "Account",
6
"description": "Chart of Accounts"
7
},
8
{
9
"name": "Customer",
10
"displayName": "Customer",
11
"description": "Customer Information"
12
},
13
{
14
"name": "Invoice",
15
"displayName": "Invoice",
16
"description": "Sales Invoice"
17
},
18
{
19
"name": "Item",
20
"displayName": "Item",
21
"description": "Products and Services"
22
},
23
{
24
"name": "Payment",
25
"displayName": "Payment",
26
"description": "Customer Payment"
27
}
28
]
29
}

List items (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
{
2
"items": [
3
{
4
"value": "1",
5
"text": "Item 1"
6
},
7
{
8
"value": "2",
9
"text": "Item 2"
10
},
11
{
12
"value": "3",
13
"text": "Item 3"
14
}
15
]
16
}

List payment methods (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0...",
3
"realm_id": "4620816365177497889"
4
}

Sample Output

1
[
2
{
3
"value": "1",
4
"name": "Cash"
5
},
6
{
7
"value": "2",
8
"name": "Check"
9
},
10
{
11
"value": "3",
12
"name": "Credit Card"
13
},
14
{
15
"value": "4",
16
"name": "Bank Transfer"
17
},
18
{
19
"value": "5",
20
"name": "PayPal"
21
}
22
]

List tax rates (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
[
2
{
3
"value": "1",
4
"name": "No tax"
5
},
6
{
7
"value": "2",
8
"name": "Standard rate (20%)"
9
},
10
{
11
"value": "3",
12
"name": "Reduced rate (5%)"
13
},
14
{
15
"value": "4",
16
"name": "Zero rate (0%)"
17
}
18
]

List terms (DDL)
Copy

Note that DDL operations can only be called directly by Connectors API, or when using CustomJS in the Embedded solution editor for e.g. DDL-dependent data mapping

Sample Input

1
{
2
"access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
3
"realm_id": "1234567890"
4
}

Sample Output

1
{
2
"terms": [
3
{
4
"id": "1",
5
"name": "Net 30",
6
"type": "STANDARD",
7
"discountPercent": 0,
8
"dueDays": 30
9
},
10
{
11
"id": "2",
12
"name": "Net 15",
13
"type": "STANDARD",
14
"discountPercent": 0,
15
"dueDays": 15
16
},
17
{
18
"id": "3",
19
"name": "2% 10 Net 30",
20
"type": "STANDARD",
21
"discountPercent": 2,
22
"discountDays": 10,
23
"dueDays": 30
24
}
25
]
26
}