Search QuickBooks accounts

distru-search-qb-accountsRead

Searches your QuickBooks chart of accounts, as Distru last copied it.

Inputs

Every tool also takes the common inputs.

FieldTypeRequiredDescription
limitintegerNoDefault: 10
cursorstringNonextCursor of the previous call; keep the other arguments unchanged.
idsstring[]NoQuickBooks account IDs.
searchstringNoCase-insensitive substring or fuzzy word match on the full name ("Parent:Child"), so a parent's name also finds its sub-accounts. Ranks by similarity, replacing sortBy.
accountTypesenum[]
14 values
ACCOUNTS_PAYABLEACCOUNTS_RECEIVABLEBANKCOST_OF_GOODS_SOLDCREDIT_CARDEQUITYEXPENSEFIXED_ASSETINCOMELONG_TERM_LIABILITYOTHER_CURRENT_ASSETOTHER_CURRENT_LIABILITYOTHER_EXPENSEOTHER_INCOME
NoAny of these QuickBooks account types.
statusenum
ACTIVEANYINACTIVE
NoDefault ACTIVE.
sortByobjectNoDefault UPDATED_AT DESC. Ignored while search is set.
sortBy.directionenum
ASCDESC
Yes
sortBy.fieldenum
INSERTED_ATNAMEUPDATED_AT
YesNAME = full name; INSERTED_AT / UPDATED_AT = when the account was created / last changed in QuickBooks.

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[].accountTypestringAlways
items[].activebooleanAlways
What the AI reads

Searches QuickBooks' own accounts: Distru's copy of the connected QuickBooks company's chart of accounts, refreshed about every 15 minutes, without the accounts QuickBooks deleted. Unlike distru-search-quickbooks-items, which returns Distru's item mappings and the accounts each item posts to, these are QuickBooks records. Use it rather than another QuickBooks connector for an account Distru works with: Distru's write tools take an account by full name (distru-create-invoice-payment's qbDepositAccount), and Distru's settings and items point at one by its QuickBooks id. id is that QuickBooks id; name is the full name ("Parent:Child" for a sub-account). accountType is QuickBooks' own type name.