Smartsheet: Add Columns
Description
Smartsheet: Add Columns step adds columns in the Smartsheet.
Reference:
- API Documentation: https://smartsheet.redoc.ly/tag/columns/#operation/columns-addToSheet
- Allowed column type: https://smartsheet.redoc.ly/tag/columns/#operation/columns-addToSheet
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 1 | Accept value as variable/static | Leave the checkbox unchecked to accept the Access Token value from a field in the previous steps of the stream using a drop-down list. Else, enable the checkbox for the Access Token field to appear as a text box. |
| 2 | Access Token | Generate the access token in your Smartsheet account. This field is mandatory. |
| 3 | Test Connection | Click to verify whether the connection is established or not. Note: Test Connection will only work with static (hardcoded) values and environment variables. It will not work for the previous step fields. |
Input Tab
| No. | Field Name | Description |
|---|---|---|
| Input Fields: | ||
| 1 | SheetID | Provide the Sheet ID that uniquely identifies the Smartsheet. This field is mandatory. |
| 2 | Get | Click to fetch the list of available sheet IDs. |
| 3 | Accept fields as JSON | If the checkbox is selected, the JSON field will be used to add column(s). If the checkbox is not selected, Table Fields will be used to build the JSON to add column(s). |
| 4 | JSON | Provide a valid JSON to insert the record. Sample Syntax: json [{"title": "New MultiPicklist Column 1","type": "MULTI_PICKLIST","options": ["First", "Second", "Third"],"index": 4},{"title":"New Date Column","type":"DATE","index":4}] |
| 5 | Table fields | Provide the details in the Table fields if you did not select the checkbox. |
| 5.a | Column Name | Specify the name of the column title for which you want to set the column. This field is mandatory. |
| 5.b | Data Type | Datatype of the respective field associated with the Column Name. This field is mandatory. Allowed Column types:
|
| 5.c | Display Order | Specify the column index or position. This number is zero-based. Note: If you provide multiple column names, then the display order value should be the same. |
| 5.d | Options | Specify the options if you have selected MULTI_PICKLIST or PICKLIST in the Data Type field. |