Overview
Configuration is provided for establishing connections with the Smartsheet service. The configuration is used in the REST Connection Manager.
Setup
Press icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
Configuration
Base URL address: https://api.smartsheet.com/2.0
.
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}
.The authentication has the following user-defined parameters:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Id
Data type: DT_UI8 The gathered value is processed with
{{=value && value.toString()}}
expression.- UserT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, email, name, firstName, lastName, admin, licensedSheetCreator, groupAdmin, resourceViewer, status, alternateEmails, sheetCount, lastLogin, customWelcomeScreenViewed.
For further information, please check here.
-
Uses template:
- AttachmentT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, attachmentType, attachmentSubType, createdAt, createdBy, mimeType, parentType, parentId, sizeInKb.
For further information, please check here.
-
Uses template:
- CommentT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, text, createdBy, createdAt, modifiedAt, attachments, discussionId.
For further information, please check here.
-
Uses template:
- GroupMember
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, email, firstName, lastName, name.
For further information, please check here.
-
Uses template:
- CellLink
-
Field components:
-
Uses template:
ShortText
. - Contains the following components: status, sheetId, rowId, columnId, sheetName.
For further information, please check here.
-
Uses template:
- CellT
-
Field components:
-
Uses template:
Id
. - Contains the following components: columnId, columnType, value, displayValue, objectValue, formula, hyperlink, linkInFromCell, linksOutToCells, overrideValidation, format, conditionalFormat, strict, image.
For further information, please check here.
-
Uses template:
- ColumnT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, index, title, primary, type, options, contactOptions, hidden, symbol, systemColumnType, autoNumberFormat, tags, validation, width, format, filter, locked, lockedForUser.
For further information, please check here.
-
Uses template:
- DiscussionT
Field components:
-
Uses template:
Id
. - Contains the following components: id, title, comments, commentCount, commentAttachments, parentId, parentType, lastCommentedAt, lastCommentedUser, createdBy, accessLevel, readOnly.
-
Uses template:
- RowT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, sheetId, rowNumber, version, filteredOut, inCriticalPath, locked, lockedForUser, expanded, accessLevel, format, conditionalFormat, createdAt, createdBy, modifiedAt, modifiedBy, columns, permalink, parentId, siblingId, toTop, toBottom, above.
For further information, please check here.
-
Uses template:
- SheetT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, accessLevel, permalink, createdAt, modifiedAt.
For further information, please check here.
-
Uses template:
- ReportT
-
Template: SheetT.
For further information, please check here.
- TemplateT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, description, accessLevel, image, largeImage, locale, type, tags, categories, blank, globalTemplate.
For further information, please check here.
-
Uses template:
- FolderT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, permalink.
For further information, please check here.
-
Uses template:
- WorkspaceT
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, favorite, accessLevel, permalink.
-
Uses template:
- HyperLinkT
-
Field components:
-
Uses template:
ShortText
. - Contains the following components: url, sheetId, reportId, sightId.
For further information, please check here.
-
Uses template:
- SightT
-
Field components:
-
Uses template:
Id
. - Contains the following components: id, name, columnCount, favorite, accessLevel, permalink, createdAt, modifiedAt, workspace.
For further information, please check here.
-
Uses template:
- [Read] action
-
The result is extracted from:{{=response.data}}
.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}}
-
page:
{{=parameters.iterator}}
-
_includeUserParameters:
{{=parameters}}
-
pageSize:
- [Create] action
-
The result is extracted from:{{=response.result}}
.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Update] action
-
The result is extracted from:{{=response.result}}
.
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/attachments
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- [Read discussionId] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/discussions/{{=parameters.discussionId}}/attachments
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- discussionId: Required. Specify discussion identifier.
For further information check here.
- [Read rowId] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows/{{=parameters.rowId}}/attachments
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- rowId: Required. Specify row identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Smartsheet.getPostAttachmentUrl(item)}}
.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/attachments/{{=item.id}}
.For further information check here.
The resource includes the fields from the AttachmentT template.
- sheetId
Template: Id.
- rowId
Template: Id.
- commentId
Template: Id.
- versions
-
The value is gathered from
/sheets/{{=Smartsheet.getSheetId(parameters)}}/attachments/{{=item.id}}/versions
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
- Contains the following components: id, name, attachmentType, mimeType, createdAt.
For further information, please check here.
- content
Data type: DT_IMAGE The value is gathered from
{{=item.url}}
address. The value is sent to{{=Smartsheet.getPostAttachmentUrl(item)}}
address.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/columns
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- [Create] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/columns
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
application/json:
{{=batch}}
For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/columns/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/columns/{{=item.id}}
.For further information check here.
The resource includes the fields from the ColumnT template.
- sheetId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/discussions/{{=parameters.discussionId}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- discussionId: Required. Specify discussion identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/discussions/{{=item.discussionId}}/comments
.For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/comments/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/comments/{{=item.id}}
.For further information check here.
The resource includes the fields from the CommentT template.
- sheetId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/discussions
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- [Read rowId] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows/{{=parameters.rowId}}/discussions
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- rowId: Required. Specify row identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/sheets/{{=item.sheetId + (item.rowId ? '/rows/' + item.rowId : '')}}/discussions
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/discussions/{{=item.id}}
.For further information check here.
The resource includes the fields from the DiscussionT template.
- sheetId
Template: Id.
- rowId
Template: Id.
- comment
Template: CommentT.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/favorites
.For further information check here.
- [Create] action
-
Endpoint URL address:
/favorites
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/favorites/{{=item.type}}/{{=item.objectId}}
.For further information check here.
- type
Template: ShortText.
- objectId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/home/folders
.For further information check here.
- [Read folderId] action
-
Endpoint URL address:
/folders/{{=parameters.folderId}}/folders
.The action has the following user-defined parameters:
- folderId: Required. Specify folder identifier.
For further information check here.
- [Read workspaceId] action
-
Endpoint URL address:
/workspaces/{{=Smartsheet.UI.WorkspaceEditor.getValue(parameters)}}/folders
.The action has the following user-defined parameters:
- workspaceId: Required. Select workspace.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=item.parentFolderId && '/folders/' + item.parentFolderId + '/folders' || item.workspaceId && '/workspaces/' + item.workspaceId + '/folders' || '/home/folders'}}
.For further information check here.
- [Update] action
-
Endpoint URL address:
/folders/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/folders/{{=item.id}}
.For further information check here.
The resource includes the fields from the FolderT template.
- parentFolderId
Template: Id.
- workspaceId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups
.For further information check here.
- [Create] action
-
Endpoint URL address:
/groups
.For further information check here.
- [Update] action
-
Endpoint URL address:
/groups/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.id}}
.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: LongText.
- owner
Template: ShortText. A read-only field.
- ownerId
Template: Id.
- members
The value is gathered from
/groups/{{=item.id}}
address. Field components:- An array.
-
Uses template:
GroupMember
.
- createdAt
Template: DateTime. A read-only field.
- modifiedAt
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups/{{=Smartsheet.UI.GroupEditor.getValue(parameters)}}
.
The result is extracted from:{{=response.members}}
.The action has the following user-defined parameters:
- groupId: Required. Specify group identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/groups/{{=Smartsheet.UI.GroupEditor.getValue(parameters)}}/members
.The action has the following user-defined parameters:
- groupId: Required. Specify group identifier.
The following request parameters will be automatically processed:
-
application/json:
{{=batch}}
For further information check here.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.groupId}}/members/{{=item.id}}
.For further information check here.
The resource includes the fields from the GroupMember template.
- groupId
A key field. Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/home
.
The result is extracted from:{{=[response]}}
.For further information check here.
- sheets
Field components:
- An array.
-
Uses template:
SheetT
.
- folders
Field components:
- An array.
-
Uses template:
FolderT
.
- reports
Field components:
- An array.
-
Uses template:
ReportT
.
- templates
Field components:
- An array.
-
Uses template:
TemplateT
.
- workspaces
Field components:
- An array.
-
Uses template:
WorkspaceT
.
- sights
Field components:
- An array.
-
Uses template:
SightT
.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/reports
.For further information check here.
The resource includes the fields from the ReportT template.
- export
Data type: DT_IMAGE The value is gathered from
/reports/{{=item.id}}
address.- sourceSheets
The value is gathered from
/reports/{{=item.id}}
address. Field components:- An array.
-
Uses template:
SheetT
.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}
.
The result is extracted from:{{=response.rows}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- [Create] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
application/json:
{{=batch}}
For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
application/json:
{{=batch}}
For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.
The result is extracted from:{{=undefined}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
ids:
{{=_.pluck(batch, 'id').join()}}
For further information check here.
The resource includes the fields from the RowT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/search
.
The result is extracted from:{{=response.results}}
.For further information check here.
- [Read sheetId] action
-
Endpoint URL address:
/search/sheets/{{=Smartsheet.getSheetId(parameters)}}
.
The result is extracted from:{{=response.results}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- text
Template: LongText.
- objectId
Template: Id.
- objectType
Template: ShortText.
- parentObjectId
Template: Id.
- parentObjectType
Template: ShortText.
- parentObjectName
Template: ShortText.
- contextData
Template: LongText. A composite field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets
.For further information check here.
- [Read all] action
-
Endpoint URL address:
/users/sheets
.For further information check here.
- [Read workspaceId] action
-
Endpoint URL address:
/workspaces/{{=Smartsheet.UI.WorkspaceEditor.getValue(parameters)}}
.
The result is extracted from:{{=response.sheets}}
.The action has the following user-defined parameters:
- workspaceId: Required. Select workspace.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=item.parentFolderId && '/folders/' + item.parentFolderId + '/sheets' || item.workspaceId && '/workspaces/' + item.workspaceId + '/sheets' || '/sheets'}}
.For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.id}}
.For further information check here.
The resource includes the fields from the SheetT template.
- parentFolderId
Template: Id.
- workspaceId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sights
.For further information check here.
- [Update] action
-
Endpoint URL address:
/sights/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sights/{{=item.id}}
.For further information check here.
The resource includes the fields from the SightT template.
- widgets
A read-only field. The value is gathered from
/sights/{{=item.id}}
address. The gathered value is processed with{{=response[field.name]}}
expression. Field components:- An array.
- Contains the following components: id, type, title, showTitle, showTitleIcon, titleFormat, xPosition, yPosition, height, width, version, contents.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/updaterequests
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
For further information check here.
- [Create] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/updaterequests
.For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/updaterequests/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=item.sheetId}}/updaterequests/{{=item.id}}
.For further information check here.
- id
A key field. Template: Id.
- sheetId
A key field. Template: Id.
- sendTo
-
Field components:
- An array.
- Contains the following components: email, groupId.
For further information, please check here.
- subject
Template: ShortText.
- message
Template: LongText.
- ccMe
Data type: DT_BOOL
- columnIds
Template: LongText. A composite field.
- includeAttachments
Data type: DT_BOOL
- includeDiscussions
Data type: DT_BOOL
- layout
Template: ShortText.
- rowIds
Template: LongText. A composite field.
- sentBy
Template: UserT. A read-only field.
- schedule
-
Field components:
-
Uses template:
ShortText
. - Contains the following components: type, startAt, endAt, dayOfMonth, dayOrdinal, dayDescriptors, repeatEvery, lastSentAt, nextSendAt.
For further information, please check here.
-
Uses template:
- createdAt
Template: DateTime. A read-only field.
- modifiedAt
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users
.For further information check here.
- [Create] action
-
Endpoint URL address:
/users
.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.userId}}
.For further information check here.
The resource includes the fields from the UserT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workspaces
.For further information check here.
- [Create] action
-
Endpoint URL address:
/workspaces
.For further information check here.
- [Update] action
-
Endpoint URL address:
/workspaces/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/workspaces/{{=item.id}}
.For further information check here.
The resource includes the fields from the WorkspaceT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webhooks
.For further information check here.
- [Create] action
-
Endpoint URL address:
/webhooks
.For further information check here.
- [Update] action
-
Endpoint URL address:
/webhooks/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webhooks/{{=item.id}}
.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- apiClientId
Template: ShortText. A read-only field.
- apiClientName
Template: ShortText. A read-only field.
- scope
Template: ShortText.
- scopeObjectId
Template: Id.
- events
Template: LongText. A composite field.
- callbackUrl
Template: ShortText.
- sharedSecret
Template: ShortText. A read-only field.
- enabled
Data type: DT_BOOL A read-only field.
- status
Template: ShortText. A read-only field.
- disabledDetails
Template: ShortText. A read-only field.
- version
Data type: DT_I4
- stats
A read-only field. Field components:
-
Uses template:
DateTime
. - Contains the following components: lastCallbackAttemptRetryCount, lastCallbackAttempt, lastSuccessfulCallback.
-
Uses template:
- createdAt
Template: DateTime. A read-only field.
- modifiedAt
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}
.
The result is extracted from:{{=Smartsheet.readData(parameters, response)}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- startRow: Optional. Specify row to start reading from.
- [Create] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
- location: Specifies row insertion location - toTop, toBottom, parentId, siblingId, above
- clear: Specifies to clear sheet before insert. Specify 1-5 to remove rows between 1-5. Specify 5- to remove all rows starting from row 5. If empty, the entire sheet will be cleared.
The following request parameters will be automatically processed:
-
application/json:
{{=Smartsheet.writeSheetData(parameters, batch)}}
For further information check here.
- [Update] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
application/json:
{{=Smartsheet.writeSheetData(parameters, batch)}}
For further information check here.
- [Delete] action
-
Endpoint URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}/rows
.
The result is extracted from:{{=undefined}}
.The action has the following user-defined parameters:
- sheetPath: Required. Specifies path to spreadsheet. Use the following syntax: workspace/folder/subFolder/sheetName
The following request parameters will be automatically processed:
-
ids:
{{=_.pluck(batch, 'id').join()}}
For further information check here.
- id
A key field. Template: Id.
- [External]
-
The external fields URL address:
/sheets/{{=Smartsheet.getSheetId(parameters)}}
. The external fields list is extracted from:{{=response.columns}}
.- {{=external.title}}
Data type: {{=Smartsheet.getDataType(external.type)}} ( length 255 )
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/reports/{{=Smartsheet.getObjectId('report:' + parameters.reportPath)}}
.
The result is extracted from:{{=Smartsheet.readData(parameters, response)}}
.The action has the following user-defined parameters:
- reportPath: Required. Specify the report identifier or choose from the dropdown idesntifier list.
- startRow: Optional. Specify row to start reading from.
- id
A key field. Template: Id.
- [External]
-
The external fields URL address:
/reports/{{=Smartsheet.getObjectId('report:' + parameters.reportPath)}}
. The external fields list is extracted from:{{=response.columns}}
.- {{=external.title}}
Data type: {{=Smartsheet.getDataType(external.type)}} ( length 255 )
Knowledge Base
- Where can I find the documentation for the Smartsheet Connection?
- Error message: Required object attribute(s) are missing from your request: row.id
What's New
- New: Improved parameter entry.
- Fixed: Update of Text/Number fields is now handled properly (Thank you, Ken).
- Fixed:
clear
parameter was not handled properly in 'Sheet Data' resource Create/Update action (Thank you, Kwame).
- Fixed: Failed with error "Array attributes may not contain null elements: row.cells[]." when updating sheet data (Thank you, Cesar).
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.