QuickBooks Online Data Targets

Query

Required

Select the query that will generate the data for this target.
See the relevant target type documentation for additional details on what query columns are required for your target.

Query Mode

Required

Select New unless you have a reason to select Latest or Specific.

Credential

Required

Select a Blackline Credential from the list.

Target Type

Required

Select Customer, Invoice, Item, Journal Entry, Recurring Invoice, Recurring Sales Receipt or Sales Receipt.

Action

Required

If Create, the target will create a new record for each row in the resultset.

If Update, the target will update existing records.

if AutoUpsert, for each row in the resultset, the target will check for an existing record. If one is found, the record is updated. if one is not found, the record is created.

Continue on Error

Optional

Each row of the query resultset is sent individually.

If False, the target will stop processing rows when it encounters an error. Rows processed prior to the error can be assumed to have completed successfully; rows after the row which errors will not be processed. The state of the target will be Error.

If True, the target will attempt to process all rows in the resultset. If any errors are encountered, they will be included in the log and the final state of the target will be Warning.