Get Table Row
Gets a table row in Microsoft Excel 365.
This node is also exposed as an AI Agent tool.
This node has 1 input port and 1 output port.
Common Properties
Every node shares these.
- Name — the node's display name on the canvas.
- Color — the node's colour on the canvas.
- Delay Before (sec) — wait this long before the node runs.
- Delay After (sec) — wait this long after the node runs.
- Continue On Error — carry on instead of failing the flow. Defaults to false.
info
When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.
Inputs
| Property | Field | Description |
|---|---|---|
| Row Index | inRowIndex | Row index (0-based٫ e.g. 0 for first data row) |
| Table ID | inTableID | Table ID or name |
| Workbook ID | inWorkbookID | Workbook ID from Open Workbook node |
Outputs
| Property | Field | Description |
|---|---|---|
| Row | outRow | JSON object with column names as keys |
Options
| Property | Field | Description |
|---|---|---|
| Headers | optHeaders | Use table column names as keys (if false٫ uses column letters A٫B٫C) |
| Jsonify | optJsonify | Convert column names to lowercase with underscores (e.g. Price Range -> price_range) |
Related nodes
List Tables · Create Table · Get Table Rows · Set Table Row · Append Table Row
Elsewhere in the package: Open Workbook · Close Workbook · Create Workbook · List Workbooks · Get Workbook · List Worksheets · Create Worksheet · Delete Worksheet · Read Range · Write Range and 15 more
See also
- Microsoft Excel 365 — every node in this package
- Message object — how properties read values from
msg - Handling failure — Continue On Error, Catch and retries