Quickbooks¶

Node: quickbooks · Full type: n8n-nodes-base.quickbooks · Version: 1

Credentials¶

quickBooksOAuth2Api (alias: @quick)

CREDENTIAL @quick = quickBooksOAuth2Api "My Quickbooks"

Operations¶

Resource: `bill`¶

`create`¶

Parameter	Type	Default	Details
`VendorRef`	options	[]	required
`Line`	collection	{}	keys: `accountId`, `Amount`, `Description`, `DetailType`, `itemId`, `LineNum`
`additionalFields`	collection	{}	keys: `APAccountRef`, `Balance`, `DueDate`, `SalesTermRef`, `TotalAmt`, `TxnDate`

`delete`¶

Parameter	Type	Default	Details
`billId`	string	""	required

`get`¶

Parameter	Type	Default	Details
`billId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`update`¶

Parameter	Type	Default	Details
`billId`	string	""	required
`updateFields`	collection	{}	required; keys: `APAccountRef`, `DueDate`, `SalesTermRef`, `TxnDate`

Resource: `customer`¶

`create`¶

Parameter	Type	Default	Details
`displayName`	string	""	required
`additionalFields`	collection	{}	keys: `Active`, `Balance`, `BalanceWithJobs`, `BillAddr`, `BillWithParent`, `CompanyName`, ...

`get`¶

Parameter	Type	Default	Details
`customerId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`update`¶

Parameter	Type	Default	Details
`customerId`	string	""	required
`updateFields`	collection	{}	required; keys: `Active`, `Balance`, `BalanceWithJobs`, `BillAddr`, `BillWithParent`, `CompanyName`, ...

Resource: `employee`¶

`create`¶

Parameter	Type	Default	Details
`FamilyName`	string	""
`GivenName`	string	""
`additionalFields`	collection	{}	keys: `Active`, `BillableTime`, `DisplayName`, `BillAddr`, `PrimaryPhone`, `PrintOnCheckName`, ...

`get`¶

Parameter	Type	Default	Details
`employeeId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`update`¶

Parameter	Type	Default	Details
`employeeId`	string	""	required
`updateFields`	collection	{}	required; keys: `Active`, `BillableTime`, `DisplayName`, `BillAddr`, `PrimaryPhone`, `PrintOnCheckName`, ...

Resource: `estimate`¶

`create`¶

Parameter	Type	Default	Details
`CustomerRef`	options	[]	required
`Line`	collection	{}	keys: `Amount`, `Description`, `DetailType`, `itemId`, `LineNum`, `TaxCodeRef`
`additionalFields`	collection	{}	keys: `ApplyTaxAfterDiscount`, `BillAddr`, `BillEmail`, `CustomFields`, `CustomerMemo`, `DocNumber`, ...

`delete`¶

Parameter	Type	Default	Details
`estimateId`	string	""	required

`get`¶

Parameter	Type	Default	Details
`estimateId`	string	""	required
`download`	boolean	false	required
`binaryProperty`	string	"data"	required
`fileName`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`send`¶

Parameter	Type	Default	Details
`estimateId`	string	""	required
`email`	string	""	required

`update`¶

Parameter	Type	Default	Details
`estimateId`	string	""	required
`updateFields`	collection	{}	required; keys: `ApplyTaxAfterDiscount`, `BillAddr`, `BillEmail`, `CustomFields`, `CustomerMemo`, `DocNumber`, ...

Resource: `invoice`¶

`create`¶

Parameter	Type	Default	Details
`CustomerRef`	options	[]	required
`Line`	collection	{}	keys: `Amount`, `Description`, `DetailType`, `itemId`, `LineNum`, `TaxCodeRef`, ...
`additionalFields`	collection	{}	keys: `Balance`, `BillAddr`, `BillEmail`, `CustomerMemo`, `CustomFields`, `DocNumber`, ...

`delete`¶

Parameter	Type	Default	Details
`invoiceId`	string	""	required

`get`¶

Parameter	Type	Default	Details
`invoiceId`	string	""	required
`download`	boolean	false	required
`binaryProperty`	string	"data"	required
`fileName`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`send`¶

Parameter	Type	Default	Details
`invoiceId`	string	""	required
`email`	string	""	required

`update`¶

Parameter	Type	Default	Details
`invoiceId`	string	""	required
`updateFields`	collection	{}	required; keys: `BillAddr`, `BillEmail`, `CustomerMemo`, `CustomFields`, `DocNumber`, `DueDate`, ...

`void`¶

Parameter	Type	Default	Details
`invoiceId`	string	""	required

Resource: `item`¶

`get`¶

Parameter	Type	Default	Details
`itemId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

Resource: `payment`¶

`create`¶

Parameter	Type	Default	Details
`CustomerRef`	options	[]	required
`TotalAmt`	number	0
`additionalFields`	collection	{}	keys: `TxnDate`

`delete`¶

Parameter	Type	Default	Details
`paymentId`	string	""	required

`get`¶

Parameter	Type	Default	Details
`paymentId`	string	""	required
`download`	boolean	false	required
`binaryProperty`	string	"data"	required
`fileName`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`send`¶

Parameter	Type	Default	Details
`paymentId`	string	""	required
`email`	string	""	required

`update`¶

Parameter	Type	Default	Details
`paymentId`	string	""	required
`updateFields`	collection	{}	required; keys: `TxnDate`

`void`¶

Parameter	Type	Default	Details
`paymentId`	string	""	required

Resource: `purchase`¶

`get`¶

Parameter	Type	Default	Details
`purchaseId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

Resource: `transaction`¶

`getReport`¶

Parameter	Type	Default	Details
`simple`	boolean	true
`filters`	collection	{}	keys: `appaid`, `arpaid`, `cleared`, `columns`, `customer`, `dateRangeCustom`, ...

Resource: `vendor`¶

`create`¶

Parameter	Type	Default	Details
`displayName`	string	""	required
`additionalFields`	collection	{}	keys: `AcctNum`, `Active`, `Balance`, `BillAddr`, `CompanyName`, `FamilyName`, ...

`get`¶

Parameter	Type	Default	Details
`vendorId`	string	""	required

`getAll`¶

Parameter	Type	Default	Details
`returnAll`	boolean	false
`limit`	number	50
`filters`	collection	{}	keys: `query`

`update`¶

Parameter	Type	Default	Details
`vendorId`	string	""	required
`updateFields`	collection	{}	required; keys: `AcctNum`, `Active`, `Balance`, `BillAddr`, `CompanyName`, `FamilyName`, ...

Parameter Details¶

Line children:

Parameter	Type	Default	Details
`accountId`	string	""
`Amount`	number	0
`Description`	string	""
`DetailType`	options	"ItemBasedExpenseLineDetail"	`AccountBasedExpenseLineDetail`, `ItemBasedExpenseLineDetail`
`itemId`	options	[]
`LineNum`	number	1

additionalFields children:

Parameter	Type	Default	Details
`APAccountRef`	fixedCollection	{}	groups: `details`
`Balance`	string	""
`DueDate`	dateTime	""
`SalesTermRef`	fixedCollection	{}	groups: `details`
`TotalAmt`	number	0
`TxnDate`	dateTime	""

filters children:

Parameter	Type	Default	Details
`query`	string	""

updateFields children:

Parameter	Type	Default	Details
`APAccountRef`	fixedCollection	{}	groups: `details`
`DueDate`	dateTime	""
`SalesTermRef`	fixedCollection	{}	groups: `details`
`TxnDate`	dateTime	""

Example¶

NODE "quickbooks" @quick AS "Quickbooks" {
  resource: "bill",
  operation: "get",
  billId: {{ $json.billId }},
  displayName: {{ $json.displayName }},
  customerId: {{ $json.customerId }}
}

Quickbooks¶

Credentials¶

Operations¶

Resource: bill¶

create¶

delete¶

get¶

getAll¶

update¶

Resource: customer¶

create¶

get¶

getAll¶

update¶

Resource: employee¶

create¶

get¶

getAll¶

update¶

Resource: estimate¶

create¶

delete¶

get¶

getAll¶

send¶

update¶

Resource: invoice¶

create¶

delete¶

get¶

getAll¶

send¶

update¶

void¶

Resource: item¶

get¶

getAll¶

Resource: payment¶

create¶

delete¶

get¶

getAll¶

send¶

update¶

void¶

Resource: purchase¶

get¶

getAll¶

Resource: transaction¶

getReport¶

Resource: vendor¶

create¶

get¶

getAll¶

update¶

Parameter Details¶

Example¶

Resource: `bill`¶

`create`¶

`delete`¶

`get`¶

`getAll`¶

`update`¶

Resource: `customer`¶

`create`¶

`get`¶

`getAll`¶

`update`¶

Resource: `employee`¶

`create`¶

`get`¶

`getAll`¶

`update`¶

Resource: `estimate`¶

`create`¶

`delete`¶

`get`¶

`getAll`¶

`send`¶

`update`¶

Resource: `invoice`¶

`create`¶

`delete`¶

`get`¶

`getAll`¶

`send`¶

`update`¶

`void`¶

Resource: `item`¶

`get`¶

`getAll`¶

Resource: `payment`¶

`create`¶

`delete`¶

`get`¶

`getAll`¶

`send`¶

`update`¶

`void`¶

Resource: `purchase`¶

`get`¶

`getAll`¶

Resource: `transaction`¶

`getReport`¶

Resource: `vendor`¶

`create`¶

`get`¶

`getAll`¶

`update`¶