> ## Documentation Index
> Fetch the complete documentation index at: https://docs.b3os.org/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

![QuickBooks: Search Accounts logo](https://ai-icon.b3.fun/logo/quickbooks)
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

**Workflow node**

```json
{
  "type": "quickbooks-search-accounts",
  "payload": {
    "whereClause": "example-whereClause"
  },
  "children": [],
  "connector": {
    "type": "pipedream:quickbooks",
    "id": "conn_pipedream_quickbooks"
  }
}
```
  **Test with API**

```bash
curl -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"
  }
}'
```

**Use expressions for dynamic values**

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.