QuickBooks: Search Purchases
Search and list purchases in QuickBooks Online. Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
Catalog action Integrations pipedream:quickbooks
Search and list purchases in QuickBooks Online. Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
At a Glance
| Field | Value |
|---|---|
| Action ID | quickbooks-search-purchases |
| Category | Integrations |
| Connector | pipedream:quickbooks |
| Requires gas | No |
| Funds movement | None declared |
| Tags | pipedream, integration, oauth, quickbooks, accounting, bookkeeping, expense, finance, search, query |
Payload Schema
| Field | Type | Required | Description |
|---|---|---|---|
whereClause | string | No | SQL-like WHERE clause for filtering (e.g., "TxnDate > '2024-01-01'" or "TotalAmt > 1000") |
orderClause | string | No | SQL-like ORDER BY clause (e.g., "TxnDate DESC" or "TotalAmt ASC") |
maxResults | string | No | Maximum number of results to return (e.g., "50"). Default is all results. |
startPosition | string | No | Starting position for pagination (e.g., "1" for first page, "51" for second page with maxResults=50) |
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-purchases", "payload": { "whereClause": "example-whereClause", "orderClause": "example-orderClause", "maxResults": "example-maxResults", "startPosition": "example-startPosition" }, "children": [], "connector": { "type": "pipedream:quickbooks", "id": "conn_pipedream_quickbooks" }}
bashcurl -X POST "https://api.b3os.org/v1/actions/quickbooks-search-purchases/test" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "inputs": { "whereClause": "example-whereClause", "orderClause": "example-orderClause", "maxResults": "example-maxResults", "startPosition": "example-startPosition" }}'
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.