List Groups

List all groups in Smartsheet.

Options

Field Definition Type Required
Result Set Choose a method to filter search results:
  • First 100 Matching Records: returns the first 100 matching records.
  • Stream Matching Records: passes all matching records from your parent flow to a helper flow. A Streaming input section is added to the card from which you can select a helper flow for streaming and adding custom extensible fields.
Dropdown TRUE

Input

Field Definition Type Required
List Criteria      
Record Limit

Specify the number of records to stream.

  • When the Limit field is set to 0, no records are returned.

  • When the Limit field is set to greater than 0, records greater than 0 and up the maximum number of records specified are returned.

  • When the Limit field is empty or not selected, all records are streamed.

  • Default value is 10 million.

  • Valid range is 0 to 10 million.

Appears when Stream Matching Records is selected from the Result Set option.

Number FALSE
Streaming      
Flow

Click Choose Flow to browse and select a helper flow where the search results will be streamed, then click Choose to confirm.

Optionally, click the empty field under Click or drop here to create and add custom extensible fields that pass data to the helper flow. These fields are added as key/value pairs under the State output object in the helper flow.

Flow TRUE

Output

Field Definition Type
Groups
ID Unique ID of the group. String
Name Group name. String
Description Group description. List of Text
Owner Email Email address of the group owner. String
Owner ID User ID of the group owner. String
Created At Date and time when the group was created. Date and Time
Updated At Date and time when the group was updated. Date and Time
Records Streamed

Number of records streamed in a streaming flow.

Appears when Stream Matching Records is selected from the Result Set option.

Number

Related topics

Smartsheet connector

About the elements of Okta Workflows

Smartsheet API Reference