POST /folders/{folderId}/sheets/import
Imports CSV or XLSX data into a new sheet in the specified folder.
Note the following:
- Both sheetName and the file name must use ASCII characters.
- The source data must be basic text. To include rich formula data, import and create a sheet first, and then use Update Rows. To work with images, see Cell Images.
- XLS is not supported. You must use XLSX.
- Hierarchical relationships between rows in an external file won't import.
Servers
- https://api.smartsheet.com/2.0
Request headers
| Name | Type | Required | Description |
|---|---|---|---|
Content-Type |
String | Yes |
Required for POST request to import a sheet from CSV/XLSX file.
Possible values:
|
Content-Disposition |
String | No |
Should be equal to "attachment" to tell the API that a file is in the body of the POST request, followed by a semicolon, followed by filename= and the URL-encoded filename in quotes |
Query parameters
| Name | Type | Required | Description |
|---|---|---|---|
sheetName |
String | Yes |
Desired name of the sheet. |
headerRowIndex |
Number | No |
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 |
Number | No |
A zero-based integer indicating the column to designate as primary. Default value: 0 |
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.