lookup_record
Search an array of records by field and value to find a specific invoice or supplier. Returns the first match or all matches with optional comparison operators.
Instructions
Find a record by field value — like VLOOKUP/XLOOKUP. Returns the first match or all matches. Use for finding a specific invoice, supplier, etc.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field to search in. | |
| value | Yes | Value to match. | |
| records | Yes | Array of record objects. | |
| operator | No | Comparison operator (default: eq). | eq |
| return_all | No | Return all matches (true) or just first (false). |