ImportFile
Import a CSV or XLSX file to the top-level 'sheets' folder. You can also import it to a specific folder or workspace by specifying their id. You should specify only one of them.
Input
| Name | Type | Required | Description |
| SheetName | String | True | Required. The desired name of the sheet. |
| HeaderRowIndex | String | False | Optional. A zero-based integer indicating the row number to use for column names. Rows before this are omitted. If not specified, the default values are Column1, Column2, etc. |
| PrimaryColumnIndex | String | False | Optional. A zero-based integer indicating the column to designate as primary. If not specified, the default value is 0. |
| FileName | String | True | The file name including extension (and optionally the full path if Content is not set) of the file to upload. Example: C:/Users/Public/Desktop/Departments.csv' |
| FolderId | String | False | Imports CSV or XLSX data into a new sheet in the specified folder. |
| WorkspaceId | String | False | Imports CSV or XLSX data into a new sheet in the specified workspace. |
| Overwrite | String | False | Overwrite an existing sheet.
The default value is false. |
Result Set Columns
| Name | Type | Description |
| Id | String | Sheet Id |
| Name | String | Sheet name |
| AccessLevel | String | User's permissions on the sheet |
| Permalink | String | URL that represents a direct link to the sheet in Smartsheet |