Gigasheet Filter File Rows

• endRowinteger
  Ending row index for pagination (0-based, exclusive). Use with startRow to retrieve a specific range of rows. For example, startRow=0 and endRow=10 returns the first 10 rows.
• handlestring

  Required
  Unique identifier of the sheet/file to filter. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE.
• startRowinteger
  Starting row index for pagination (0-based). Use with endRow to retrieve a specific range of rows from the filtered result set.
• groupKeysarray
  Keys for grouping rows in pivot mode
• pivotColsarray
  Columns to use as pivot dimensions when pivotMode is enabled
• pivotModeboolean
  Enable pivot mode for data aggregation and grouping
• sortModelarray
  Array of sort configurations to apply to the result set. Each item specifies a column and sort direction.
• valueColsarray
  Value columns to aggregate in pivot mode
• FieldTypesarray
  Field type information for pivot mode operations (e.g., int, float, string). The system uses this to determine correct type handling.
• filterModelobject
  Filter model object defining which rows to return. This is an arbitrary JSON object that follows the Gigasheet Filter Model schema. Use an empty object {} to return all rows without filters. For more details, see the Filter Model Detail Guide.
• rowGroupColsarray
  Columns to group rows by in pivot mode
• columnHighlightsobject
  Column highlighting configurations mapped by column identifier

• data

  Required
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  Required
  Whether or not the action execution was successful or not

No verified related use cases are linked yet.

No published Skills explicitly reference this Action yet.