QuickBooks: Search Accounts
Search accounts in QuickBooks Online by name, type, or other criteria. Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
Catalog action Integrations pipedream:quickbooks
Search accounts in QuickBooks Online by name, type, or other criteria. Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
At a Glance
| Field | Value |
|---|---|
| Action ID | quickbooks-search-accounts |
| Category | Integrations |
| Connector | pipedream:quickbooks |
| Requires gas | No |
| Funds movement | None declared |
| Tags | pipedream, integration, oauth, quickbooks, accounting, bookkeeping, finance, search, query |
Payload Schema
| Field | Type | Required | Description |
|---|---|---|---|
whereClause | string | Yes | SQL-like WHERE clause for filtering (e.g., "Name = 'Checking Account'" or "AccountType = 'Expense'") |
orderClause | string | No | SQL-like ORDER BY clause (e.g., "Name ASC" or "AccountType DESC") |
maxResults | string | No | Maximum number of results to return (e.g., "10"). Default is all results. |
startPosition | string | No | Starting position for pagination (e.g., "1" for first page, "11" for second page with maxResults=10) |
Result Schema
| Field | Type | Required | Description |
|---|---|---|---|
success | boolean | Yes | Whether the search was successful |
data | object | No | QuickBooks Query API response |
exports | object | No | Pipedream exports (if any) |
Examples
json{ "type": "quickbooks-search-accounts", "payload": { "whereClause": "example-whereClause" }, "children": [], "connector": { "type": "pipedream:quickbooks", "id": "conn_pipedream_quickbooks" }}
bashcurl -X POST "https://api.b3os.org/v1/actions/quickbooks-search-accounts/test" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "inputs": { "whereClause": "example-whereClause" }}'
Payload fields can use workflow expressions such as {{$trigger.body.amount}}, {{$nodes.fetch.result.price}}, and {{$props.asset}} when the value should come from a trigger, prior node, or reusable workflow prop.