Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsQuickBooks ToolsQuickbooks Query Invoices
QuickBooks Tools

Quickbooks Query Invoices

Query QuickBooks invoices with flexible filtering and pagination support. Use this action when you need to search for invoices based on specific criteria like customer, date range, amount, or payment status. Use when retrieving invoices with custom filters, date ranges, or payme…

Write actionRisk level 2 of 5OAuth connection
Use Quickbooks Query Invoices

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • querystring
    SQL-like query string to filter invoices. If not provided, returns all invoices. Supports QuickBooks Query Language syntax: WHERE, ORDERBY, operators (=, <, >, <=, >=, !=, LIKE, IN, AND). Common queryable fields: Id, TxnDate, DueDate, DocNumber, TotalAmt, Balance, CustomerRef, P…
  • statusstring
    Filter by invoice payment status. Common values: 'Paid' (Balance = 0), 'Unpaid' (Balance > 0), 'Overdue' (Balance > 0 AND DueDate < today). This is a convenience filter that will be translated to appropriate query conditions.
  • end_datestring
    Filter invoices created on or before this date in YYYY-MM-DD format. Adds 'TxnDate <= end_date' to query.
  • start_datestring
    Filter invoices created on or after this date in YYYY-MM-DD format. Adds 'TxnDate >= start_date' to query.
  • customer_idstring
    Filter invoices by customer ID. Convenience parameter that adds 'WHERE CustomerRef = customer_id' to the query.
  • max_resultsinteger
    Maximum number of invoices to return. Default is 25, maximum is 1000.
  • start_positioninteger
    Starting position for pagination. Default is 1 (first record).

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.