Smartsheet Connector > Mappings for Smartsheet > Smartsheet targets in mappings
  

Smartsheet targets in mappings

In a mapping, you can configure a Target transformation to represent a Smartsheet target.
The following table describes the Smartsheet target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
You can select an existing connection or create a new connection.
Operation
The write 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.
Field Mapping
Map your input fields to the target fields. Ensure that you map all the mandatory fields in the target.
The following table describes the advanced target properties that you can configure in a Target transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the web service request contains many rows or columns, you might want to increase the cache size.
Default is 1024 KB.
Transaction Commit Control
Control to commit or roll back transactions based on the set of rows that pass through the transformation. Use the transaction commit control if you have a large amount of data and you want to control how it is processed.
Transformation Scope
Specifies how Data Integration applies the transformation logic to incoming data:
  • - Transaction. Applies the transformation logic to all rows in a transaction. Choose Transaction when a row of data depends on all rows in the same transaction, but does not depend on rows in other transactions.
  • - All Input. Applies the transformation logic on all incoming data. When you choose All Input, Data Integration drops incoming transaction boundaries. Choose All Input when a row of data depends on all rows in the source.
Optimize transformation
Select to improve performance for processing records at run time.
Default is disabled.