Skip to main content

Get Table Rows

Gets table rows 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​

PropertyFieldDescription
Table IDinTableIDTable ID or name
Workbook IDinWorkbookIDWorkbook ID from Open Workbook node

Outputs​

PropertyFieldDescription
TableoutTableDataTable with columns array and rows array of objects

Options​

PropertyFieldDescription
HeadersoptHeadersUse table column names as keys (if false٫ uses column letters A٫B٫C)
JsonifyoptJsonifyConvert column names to lowercase with underscores (e.g. Price Range -> price_range)

Requirements​

  • Azure AD App (Client Credentials) — Use Azure AD app registration with client credentials for server-to-server authentication.
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID (Directory ID)
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret
    • user_email — User Email (Optional) (text, optional). Email of user whose OneDrive to access. Required for accessing user's OneDrive files.
  • OAuth2 (Delegated) — Authorize via browser to access Excel files on behalf of a user.
    • _redirect_url — Redirect URL (readonly, optional). Add this to your Azure app's Redirect URIs
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID، or 'common' for multi-tenant
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret

Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.

List Tables · Create Table · Get Table Row · 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​