Zoho Books icon

Zoho Books

Consume Zoho Books API

Actions76

Invoice → Get Many

AI-generated

Overview

This node interacts with the Zoho Books API to retrieve multiple invoice records based on user-defined filters and pagination options. It is useful for scenarios where you need to fetch a list of invoices for reporting, auditing, or integration purposes. For example, you might want to get all invoices created within a specific date range, filter by status (e.g., only "Open" invoices), or search invoices related to a particular customer.

Properties

Name Meaning
Return All Whether to return all matching invoices or limit the results to a specified number.
Limit Maximum number of invoices to return when "Return All" is false. Value must be between 1 and 200.
Filters Collection of filtering and sorting options:
  From Date Only include invoices with a date greater than or equal to this date (format YYYY-MM-DD).
  To Date Only include invoices with a date less than or equal to this date (format YYYY-MM-DD).
  Status Filter invoices by their status. Options: Draft, Sent, Open, Closed, Void.
  Customer Filter invoices by a specific customer. The customer can be selected from a dynamically loaded list.
  Updated Since Only return invoices updated after this ISO-8601 datetime.
  Search Text Search invoices containing this text, such as invoice number or customer name.
  Sort By Field to sort the invoices by. Options: Date, Customer Name, Total, Created Time, Last Modified.
  Sort Order Sort direction. Options: Ascending, Descending.
  Page Page number for pagination (only applies if "Return All" is false). Minimum value is 1.
  Per Page Number of invoices per page (max 200, only applies if "Return All" is false).

Output

The output is an array of JSON objects, each representing an invoice record retrieved from Zoho Books. Each item in the output corresponds to one invoice and includes all relevant invoice data fields as returned by the Zoho Books API. The output items are paired with the input item index they correspond to.

The node does not output binary data.

Dependencies

  • Requires an active connection to Zoho Books via an OAuth2 credential configured in n8n.
  • Uses the Zoho Books API to fetch invoice data.
  • Dynamic loading of customers for filtering requires API access to customer data.

Troubleshooting

  • Common issues:
    • Incorrect or expired API credentials will cause authentication errors.
    • Requesting too many records without enabling pagination or "Return All" may lead to API rate limits or timeouts.
    • Using invalid filter values (e.g., wrong date format) may result in API errors.
  • Error messages:
    • "Unsupported resource": This indicates the resource requested is not implemented; ensure "Invoice" is selected.
    • API errors related to authentication or permissions should be resolved by verifying the OAuth2 credentials.
    • Pagination parameters out of range (e.g., limit > 200) should be corrected according to property constraints.

Links and References

Discussion