Smartsheet Connector > Mappings for Smartsheet > Smartsheet sources in mappings
  

Smartsheet sources in mappings

In a mapping, you can configure a Source transformation to represent a Smartsheet source.
The following table describes the Smartsheet source properties that you can configure in a Source transformation:
Property
Description
Connection
Name of the source connection.
You can select an existing connection or create a new connection.
Operation
The read operation that you want to perform in Smartsheet.
Click the API endpoint from the list of available packages, and select the operation you want to perform.
Request Message
Request message for the operation that you want to perform in Smartsheet.
The request message is in JSON format. You can copy and paste the request message from the request message template.
Do not leave the request message empty. You must at least specify a blank JSON object {} in the request message.
Field Mapping
Map the response parameters to the output fields.
The following table describes the advanced source properties that you can configure in a Source transformation:
Property
Description
Tracing Level
Detail level of error and status messages that Data Integration writes in the session log. You can choose terse, normal, verbose initialization, or verbose data.
Default is normal.
Cache Size for Web Service Response (KB)
Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size.
Default is 1024 KB.
Optimize transformation
Select to improve performance for processing records at run time.
Default is disabled.