Actions11
- Grains Actions
- Finance Actions
- ARCA Actions
Grains → Get Invoices
AI-generatedSummary
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
errormessage 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