Smartsheet Connector

Overview

The Jitterbit Harmony Smartsheet Connector is accessed from the Connectivity tab of the design component palette:

This connector is used to first configure a Smartsheet connection, establishing access to an account on the Smartsheet server, and then used to configure one or more Smartsheet activities associated with that connection as either a source or target within an operation:

• Get Sheet: Retrieves a sheet from a Smartsheet connection and is used as a source in an operation.

• Import Sheet: Imports data into a new sheet in a Smartsheet connection and is used as a target in an operation.

• Delete Sheet: Deletes a sheet from a Smartsheet connection and is used as a target in an operation.

The Smartsheet connector uses the Smartsheet API 2.0. Refer to the API documentation for information on the schema fields.

The Smartsheet connector requires the use of an agent version 10.1 or higher.

Together, a specific Smartsheet connection and its activities are referred to as a Smartsheet endpoint. Once a connection is configured, activities associated with the endpoint are available from the Endpoints filter: