fyo icon

fyo

Interact with fyo API

Grains → Get Invoices

AI-generated

Summary

Retrieves grain invoices from the Fyo API (POST /granos/facturas), searching by date range, broker contract number, or receipt number. Returns one n8n item per invoice record.

Inputs

  • Search By (required) — Search mode: Date Range (default), Broker Contract Number, or Receipt Number. Determines which other field is used.
  • Date From (required) — Shown for Date Range. Start date, normalized to YYYY-MM-DD. Must be a real calendar date and not in the future.
  • Date To — Shown for Date Range. Optional end date, also validated as real and not in the future. Must not be before Date From and at most 31 days after it. If omitted, only the start date is sent.
  • Broker Contract Number (required) — Shown for Broker Contract Number. Must be a number greater than 0.
  • Receipt Number (required) — Shown for Receipt Number. Must be a number greater than 0.

Output shape

A list of items, one per invoice in the API response's data array. Each item's JSON is the invoice record as returned by Fyo.

Authenticates with the fyoApi credential, whose environment sets the base URL (production, demo, or custom). If the response has no data array, the whole response object may be returned as a single item. No pagination is handled. Invalid inputs or API errors stop the node. With Continue On Fail, an item with an error message is returned instead.

Examples

Example 1: Pull last month's invoices for reconciliation

Search By = Date Range; Date From = 2026-09-01; Date To = 2026-09-30

Example 2: Find invoices tied to a specific broker contract

Search By = Broker Contract Number; Broker Contract Number = 123456

Example 3: Look up one invoice by receipt

Search By = Receipt Number; Receipt Number = 987654

Links

Discussion