Operations (sample payloads)
Main operationsCopy
Create accountCopy
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 billCopy
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": 35061},62"time": "2023-06-15T14:30:25-07:00"63}
Create customerCopy
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 employeeCopy
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 invoiceCopy
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": 112}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": 130}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": 10049},50"time": "2023-06-15T10:00:00.000-07:00"51}
Create purchaseCopy
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 activityCopy
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.523},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 vendorCopy
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 purchaseCopy
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 activityCopy
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 transferCopy
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 accountCopy
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 billCopy
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": 50067},68"time": "2023-05-15T09:05:00-07:00"69}
Get classCopy
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 memoCopy
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": 10062}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 PDFCopy
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": 16234567896}
Get customerCopy
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": true46},47"time": "2023-05-15T14:35:00-07:00"48}
Get departmentCopy
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 employeeCopy
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 invoiceCopy
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": 100066}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": 1080100},101"time": "2023-05-15T10:00:00-07:00"102}
Get paymentCopy
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": false57}58]59}60}61]62}
Get payment methodCopy
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 purchaseCopy
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": false23}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 codeCopy
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": 117},18{19"TaxRateRef": {20"value": "RATE_2",21"name": "County Tax"22},23"TaxTypeApplicable": "Sales",24"TaxOrder": 225}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 termCopy
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 activityCopy
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 transferCopy
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 vendorCopy
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 accountsCopy
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": 1018}
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": 1055},56"time": "2023-05-15T15:00:00-07:00"57}
List classesCopy
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": 1017}
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": 236},37"time": "2023-04-15T10:00:00-07:00"38}
List credit memosCopy
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": 1017}
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": 049},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": 1074},75"time": "2023-05-15T09:10:00-07:00"76}
List employeesCopy
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": true9}10],11"order_by": {12"value": "FamilyName",13"direction": "ASC"14},15"start_position": 1,16"max_results": 517}
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": 557},58"time": "2023-04-20T14:35:42.123-07:00"59}
List invoicesCopy
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": 014}15],16"order_by": {17"value": "TxnDate",18"direction": "DESC"19},20"start_position": 1,21"max_results": 1022}
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": 100064}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": 1106},107"time": "2023-05-15T10:00:00-07:00"108}
List itemsCopy
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": 518}
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": 595},96"time": "2023-04-15T10:00:00-07:00"97}
List payment methodsCopy
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": true9}10],11"order_by": {12"value": "Name",13"direction": "ASC"14},15"start_position": 1,16"max_results": 1017}
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": 1046},47"time": "2023-05-15T14:30:00-07:00"48}
List paymentsCopy
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": 100010}11],12"order_by": {13"value": "TxnDate",14"direction": "DESC"15},16"start_position": 1,17"max_results": 1018}
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": false60}61]62}63}64]65}66],67"startPosition": 1,68"maxResults": 1069},70"time": "2023-05-15T16:30:45.123Z"71}
List purchasesCopy
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": 10009},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": 1022}
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": false25}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": 1062},63"time": "2023-05-15T10:00:00-07:00"64}
List tax codesCopy
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": 517}
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": 119}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": 259},60"time": "2023-04-15T10:00:00-07:00"61}
List tax ratesCopy
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": true9}10],11"order_by": {12"value": "Name",13"direction": "ASC"14},15"start_position": 1,16"max_results": 517}
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": 252},53"time": "2023-04-15T11:00:00-07:00"54}
List time activitiesCopy
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": 10022}
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": 10039},40"time": "2023-05-16T10:30:00-07:00"41}
List vendorsCopy
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": 1018}
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": true22},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": true41}42],43"startPosition": 1,44"maxResults": 1045},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": null22},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": 234},35"time": "2023-07-21T12:34:56.789Z"36}37}38}
Run queryCopy
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": 100010},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": 5023}
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": 041},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": 169},70"time": "2023-05-15T12:00:00.000-07:00"71}
Update billCopy
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": 50049}50}51],52"VendorRef": {53"value": "56",54"name": "ABC Supplies"55},56"APAccountRef": {57"value": "33",58"name": "Accounts Payable"59},60"TotalAmt": 150061},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 employeeCopy
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 invoiceCopy
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": 113}14},15{16"sales_item_line_detail": {17"amount": 50,18"description": "Logo Design",19"item_ref": "2",20"unit_price": 50,21"qty": 122}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": 15035}
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": 057},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 purchaseCopy
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 activityCopy
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.522},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": 3043}
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 transferCopy
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 vendorCopy
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 operationsCopy
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": 309},10{11"id": "2",12"name": "Net 15",13"type": "STANDARD",14"discountPercent": 0,15"dueDays": 1516},17{18"id": "3",19"name": "2% 10 Net 30",20"type": "STANDARD",21"discountPercent": 2,22"discountDays": 10,23"dueDays": 3024}25]26}