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.
デフォルト値は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 |