Search QuickBooks items

distru-search-quickbooks-itemsRead

Searches the QuickBooks products and services that Distru lines sync to.

Inputs

Every tool also takes the common inputs.

FieldTypeRequiredDescription
limitintegerNoDefault: 10
cursorstringNonextCursor of the previous call; keep the other arguments unchanged.
idsstring[]NoQuickBooks item IDs.
searchstringNoCase-insensitive substring or fuzzy word match on name. Ranks substring matches first, then by similarity, replacing sortBy.
usageenum
SALESPURCHASES
NoSALES: items with an income account; PURCHASES: items with an expense account. An item can be both.
includeHiddenbooleanNoInclude hidden items, which cannot be assigned to products.
sortByobjectNoDefault UPDATED_AT DESC. Ignored while search is set.
sortBy.directionenum
ASCDESC
Yes
sortBy.fieldenum
INSERTED_ATNAMEUPDATED_AT
Yes

Output

Presence on a nested field assumes its parent exists.

FieldTypePresence
hasMorebooleanAlways
nextCursorstringCan be absent
totalCountintegerCan be absent
itemsobject[]Always
items[].idstringAlways
items[].namestringAlways
items[].descriptionstringCan be null
items[].qbItemIdstringCan be null
items[].qbItemTypestringCan be null
items[].defaultbooleanAlways
items[].hiddenbooleanAlways
items[].qbIncomeAccountobjectCan be null
items[].qbIncomeAccount.idstringAlways
items[].qbIncomeAccount.namestringAlways
items[].qbIncomeAccount.activebooleanAlways
items[].qbIncomeAccount.isDeletedbooleanAlways
items[].qbExpenseAccountobjectCan be null
items[].qbExpenseAccount.idstringAlways
items[].qbExpenseAccount.namestringAlways
items[].qbExpenseAccount.activebooleanAlways
items[].qbExpenseAccount.isDeletedbooleanAlways
items[].qbSyncStatusenum
DELETED_IN_QBOERRORNOT_SYNCEDPARTIALLY_SYNCEDPENDINGSYNCED
Can be null
What the AI reads

Searches Distru's QuickBooks items, without deleted ones: the QBO products and services that product, charge and credit lines sync to QuickBooks through, with the accounts they post to. For a product's own items use distru-search-products or distru-get-product; for QuickBooks' own chart of accounts use distru-search-qb-accounts. default = one of the company's two fallback items (sales, purchases): a line whose product has no item of its own syncs through it. qbIncomeAccount / qbExpenseAccount null = the item is not used in sales / purchases, or its account is missing from Distru's copy of the chart of accounts. qbItemId null = not created in QuickBooks yet. qbSyncStatus null = the company is not integrated with QuickBooks; NOT_SYNCED = never pushed.