Actions10
- Row Actions
- Export Actions
- Import Actions
- View Actions
- Workspace Actions
- Organization Actions
Row → Get Many
AI-generatedSummary
Fetches rows from a selected Zoho Analytics view as JSON items. Optionally filters the rows with SQL-like criteria and limits the returned columns; if synchronous export is rejected for the view, the node retries through Zoho’s asynchronous export job API.
Inputs
- Organization (required) — Select the Zoho Analytics organization.
- Workspace (required) — Select the workspace containing the view.
- View (required) — Select the table or report view to read.
- Criteria — Optional SQL-like filter, such as "Department"='Finance' AND "Status"='Active'. Supports comparison operators, LIKE/NOT LIKE, IN/NOT IN, BETWEEN, and AND/OR. Use double quotes for column names and single quotes for string values.
- Selected Columns — Comma-separated column names to include. Leave blank to return all columns.
Output shape
A list of n8n items, one per returned row, with each row in the item's JSON.
Requests JSON data and returns all matching rows; this operation has no limit or pagination input. If the API response does not contain a recognized rows array, it returns no row items. With Continue On Fail enabled, an error is returned as an item containing an error field.