Contact Us 1-800-596-4880
  1. Homepage
  2. Smartsheet Connector (1.1)

  3. Smartsheet Connector Reference

All Connectors

Smartsheet Connector 1.1 Reference - Mule 4

Anypoint Connector for Smartsheet (Smartsheet Connector) enables you to interface with the Smartsheet platform without having to interact with the Smartsheet API directly.

Configurations

Config

Parameters

Name Type Description Default Value Required

Name

String

The name for this configuration. Connectors reference the configuration with this name.

x

Connection

Oauth2 0 Connection Provider

The connection types to provide to this configuration.

x

Response Timeout

Number

The timeout for the request to the remote service.

1

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

MINUTES

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

AUTO

Expiration Policy

Expiration Policy

Configures the minimum amount of time that a dynamic configuration instance can remain idle before Mule considers it eligible for expiration. This does not mean that the platform expires the instance at the exact moment that it becomes eligible. Mule purges the instances as appropriate.

Connection Types

Oauth2 0 Connection Provider
Parameters
Name Type Description Default Value Required

Default Headers

Array of Default Header

Query Parameters

Array of Default Query Param

Connection Timeout

Number

The timeout for establishing connections to the remote service

30

Connection Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Connection Timeout

SECONDS

Use Persistent Connections

Boolean

If false, each connection will be closed after the first request is completed.

true

Max Connections

Number

The maximum number of outbound connections to keep open at the same time

-1

Connection Idle Timeout

Number

A timeout for how long a connection can remain idle before it is closed

30

Connection Idle Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the connection Idle Timeout

SECONDS

Proxy Config

Proxy

Reusable configuration element for outbound connections through a proxy

Stream Response

Boolean

Whether or not to stream received responses, which means that processing continues as soon as all headers are parsed, and the body is streamed as it is received.

false

Response Buffer Size

Number

The space, in bytes, for the buffer where the HTTP response will be stored.

-1

Protocol

Enumeration, one of:

  • HTTP

  • HTTPS

Protocol to use for communication. Valid values are HTTP and HTTPS.

HTTP

TLS Configuration

TLS

Reconnection

Reconnection

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy.

Consumer Key

String

The OAuth consumerKey as registered with the service provider

x

Consumer Secret

String

The OAuth consumerSecret as registered with the service provider

x

Authorization Url

String

The service provider’s authorization endpoint URL

https://app.smartsheet.com/b/authorize

Access Token Url

String

The service provider’s accessToken endpoint URL

https://api.smartsheet.com/2.0/token

Scopes

String

The OAuth scopes to be requested during the dance. If not provided, this value defaults to those in the annotation.

ADMIN_SHEETS

Resource Owner Id

String

The resourceOwnerId that each component should use if it isn’t referenced otherwise.

Before

String

The name of a flow to execute right before starting the OAuth dance

After

String

The name of a flow to execute right after an accessToken has been received

Listener Config

String

A reference to an <http:listener-config /> to use to create the listener that will catch the access token callback endpoint.

x

Callback Path

String

The path of the access token callback endpoint

x

Authorize Path

String

The path of the local HTTP endpoint that triggers the OAuth dance

x

External Callback Url

String

If the callback endpoint is behind a proxy or should be accessed through an indirect URL, use this parameter to tell the OAuth provider the URL it should use to access the callback

Object Store

String

A reference to the object store that should be used to store each resource owner ID’s data. If not specified, Mule automatically provisions the default object store.

Supported Operations

Associated Sources

Operations

Create Sheet

<smartsheet:create-sheets>

Creates a new sheet in the user’s Sheets folder. This operation makes an HTTP POST request to the /sheets endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

CreateSheetRequestSchema

Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines whether to send the request using streaming. If the value is set to AUTO, the best strategy is automatically determined based on the content of the request.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Copy Sheet

<smartsheet:create-sheets-copy-by-sheet-id>

Creates a copy of the specified sheet. This operation makes an HTTP POST request to the /sheets/{sheetId}/copy endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

include

String

Comma-separated list of elements to copy

exclude

String

Excludes the sheet’s hyperlinks from the response

CreateCopySheetRequestSchema

Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Add Comment

<smartsheet:create-sheets-discussions-comments-by-sheet-id-discussion-id>

Adds a comment to a discussion. This operation makes an HTTP POST request to the /sheets/{sheetId}/discussions/{discussionId}/comments endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Discussion Id

String

Discussion ID

x

Comment

Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Add File to Row

<smartsheet:create-sheets-rows-attachments-by-sheet-id-row-id>

Attaches a file to the specified row. This operation makes an HTTP POST request to the /sheets/{sheetId}/rows/{rowId}/attachments endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Row Id

String

Row ID

x

Content Disposition

String

Content disposition

Content Type

String

Content type

Content Length

Number

Content length

Content

Binary

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Add Rows

<smartsheet:create-sheets-rows-by-sheet-id>

Inserts one or more rows into the specified sheet. This operation makes an HTTP POST request to the /sheets/{sheetId}/rows endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Allow Partial Success

Boolean

When true, this field enables partial success for the Add Row operation

false

Override Validation

Boolean

When true, this field allows a cell value to be outside of the validation limits. Set this value to false to bypass value type checking.

false

Add Rows

Array of Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Copy Rows to Another Sheet

<smartsheet:create-sheets-rows-copy-by-sheet-id>

Copies rows from the specified sheet to the bottom of another sheet. This operation makes an HTTP POST request to the /sheets/{sheetId}/rows/copy endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

include

String

Comma-separated list of row elements to copy. The connector copies these rows in addition to the cell data.

Ignore Rows Not Found

Boolean

When true, specifying row IDs that don’t exist within the source sheet does not cause an error response. If omitted or set to false, specifying row IDs that don’t exist within the source sheet causes an error response, and no rows are copied.

false

CopyRowsToAnotherSheetRequestSchema

Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Delete Sheet

<smartsheet:delete-sheets-by-sheet-id>

Deletes the specified sheet. This operation makes an HTTP DELETE request to the /sheets/{sheetId} endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

#[null]

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Delete Rows

<smartsheet:delete-sheets-rows-by-sheet-id>

Deletes one or more rows from the specified sheet. This operation makes an HTTP DELETE request to the /sheets/{sheetId}/rows endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

ids

String

Comma-separated list of row IDs

x

Ignore Rows Not Found

Boolean

If false and any of the specified row IDs are not found, no rows are deleted.

false

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

#[null]

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Search Sheet

<smartsheet:get-search-sheets-by-sheet-id>

Searches a sheet for the specified text. This operation makes an HTTP GET request to the /search/sheets/{sheetId} endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

query

String

Text for which to search. Use double quotes for an exact search.

x

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

#[null]

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Get Sheet

<smartsheet:get-sheets-by-sheet-id>

Returns the specified sheet, optionally populated with discussion and attachment objects. This operation makes an HTTP GET request to the /sheets/{sheetId} endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

include

String

Comma-separated list of elements to include in the response

exclude

String

Comma-separated list of elements to exclude from the response

Column Ids

String

Comma-separated list of column IDs

Filter Id

String

Overrides the values in the include field with the values specified here

level

Number

Indicates whether data with a new column type, such as MULTI_CONTACT_LIST or MULTI-PICK-LIST, is returned in a backwards-compatible text format or as a complex object. Valid values are:

* 0 - returns the data in a backwards-compatible text format * 1 - returns multi-contact data as a complex object * 2 - Returns multi-picklist data as a complex object

If Version After (DEPRECATED)

Boolean

(DEPRECATED) This parameter will be removed in future releases. Use the If Version After field with an integer value instead.

false

If Version After

Number

Specifies the version of the sheet to return.

page

Number

Specifies which page number (1-based) to return. If not specified, the default value is 1. If a page number greater than the number of total pages is specified, the last page is returned.

Page Size

Number

Number of rows per page to include with the sheet. If neither the page size nor page is specified, the connector returns all rows in the sheet. If only the page is specified, the connector defaults to a page size of 100.

Row Ids

String

Comma-separated list of row IDs by which to filter the rows included in the result

Row Numbers

String

Comma-separated list of row numbers by which to filter the rows included in the result. Non-existent row numbers are ignored.

Rows Modified Since

String

Return only rows that have been modified since the specified date and time. Use ISO-8601 format for the date.

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

#[null]

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Get Row

<smartsheet:get-sheets-rows-by-sheet-id-row-id>

Returns the specified rows. This operation makes an HTTP GET request to the /sheets/{sheetId}/rows/{rowId} endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Row Id

String

Row ID

x

include

String

Comma-separated list of elements to include in the response

exclude

String

Comma-separated list of elements exclude from the response

level

Number

Indicates whether data with a new column type, such as MULTI_CONTACT_LIST or MULTI-PICK-LIST, is returned in a backwards-compatible text format or as a complex object. Valid values are:

* 0 - returns the data in a backwards-compatible text format * 1 - returns multi-contact data as a complex object * 2 - Returns multi-picklist data as a complex object

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

#[null]

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Unauthorize

<smartsheet:unauthorize>

Deletes the access token information associated with a specified resource owner ID so that it’s not possible to execute an operation for that user without performing the authorization dance again.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Resource Owner Id

String

The ID of the resource owner whose access should be invalidated

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

For Configurations

Update Sheet

<smartsheet:update-sheets-by-sheet-id>

Updates an individual user’s sheet settings. If the request body contains only the userSettings attribute, this operation can be performed even if the user has only read-only access to the sheet (for example, if the user has viewer permissions or the sheet is read-only). This operation makes an HTTP PUT request to the /sheets/{sheetId} endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

UpdateSheetRequestSchema

Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Update Rows

<smartsheet:update-sheets-rows-by-sheet-id>

Updates the cell values in the specified rows. This operation makes an HTTP PUT request to the /sheets/{sheetId}/rows endpoint.

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

Sheet ID

x

Allow Partial Success

Boolean

When true, this field enables the Update Rows operation results to be partially successful

false

Override Validation

Boolean

When true, this field allows a cell value to be outside the validation limits. Set this value to false, to bypass value type checking.

false

Update Rows

Array of Any

The content to use

#[payload]

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Streaming Strategy

Configure if repeatable streams should be used and their behavior

Custom Query Parameters

Object

Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.

Custom Headers

Object

Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.

Response Timeout

Number

The timeout for the request to the remote service.

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the Response Timeout

Streaming Type

Enumeration, one of:

  • AUTO

  • ALWAYS

  • NEVER

Defines if the request should be sent using streaming. Setting the value to AUTO automatically defines the best strategy based on the request content.

Target Variable

String

Name of the variable that stores the operation’s output

Target Value

String

Expression that evaluates the operation’s output. The expression outcome is stored in the target variable.

#[payload]

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Throws

  • SMARTSHEET:BAD_REQUEST

  • SMARTSHEET:CLIENT_ERROR

  • SMARTSHEET:CONNECTIVITY

  • SMARTSHEET:INTERNAL_SERVER_ERROR

  • SMARTSHEET:NOT_ACCEPTABLE

  • SMARTSHEET:NOT_FOUND

  • SMARTSHEET:RETRY_EXHAUSTED

  • SMARTSHEET:SERVER_ERROR

  • SMARTSHEET:SERVICE_UNAVAILABLE

  • SMARTSHEET:TIMEOUT

  • SMARTSHEET:TOO_MANY_REQUESTS

  • SMARTSHEET:UNAUTHORIZED

  • SMARTSHEET:UNSUPPORTED_MEDIA_TYPE

Sources

On New Or Updated Row In Sheet Trigger

<smartsheet:on-new-or-updated-row-in-sheet-trigger>

Parameters

Name Type Description Default Value Required

Configuration

String

The name of the configuration to use.

x

Sheet Id

String

The unique identifier for a sheet.

x

Rows Modified Since

String

Filter to return only rows that have been modified since the date/time provided.

x

Config Ref

ConfigurationProvider

The name of the configuration to use to execute this component

x

Primary Node Only

Boolean

Determines whether to execute this source on only the primary node when running in a cluster

Scheduling Strategy

scheduling-strategy

Configures the scheduler that triggers the polling

x

Streaming Strategy

Configures how Mule processes streams. Repeatable streams are the default behavior.

Redelivery Policy

Redelivery Policy

Defines a policy for processing the redelivery of the same message

Reconnection Strategy

A retry strategy in case of connectivity errors

Output

Type

Any

Attributes Type

Http Response Attributes

For Configurations

Types

Default Header

Field Type Description Default Value Required

Key

String

x

Value

String

x

Default Query Param

Field Type Description Default Value Required

Key

String

x

Value

String

x

Proxy

Field Type Description Default Value Required

Host

String

x

Port

Number

x

Username

String

Password

String

Non Proxy Hosts

String

TLS

Defines a configuration for TLS, which can be used from both the client and server sides to secure communication for the Mule app. When using the HTTPS protocol, the HTTP communication is secured using TLS or SSL. If HTTPS is configured as the protocol, then, at a minimum, the user must configure the keystore in the tls:context child element of the listener-config.

Field Type Description Default Value Required

Enabled Protocols

String

A comma-separated list of protocols enabled for this context.

Enabled Cipher Suites

String

A comma-separated list of cipher suites enabled for this context.

Trust Store

Trust Store

Key Store

Key Store

Revocation Check

Trust Store

Field Type Description Default Value Required

Path

String

The location (which will be resolved relative to the current classpath and file system, if possible) of the truststore.

Password

String

The password used to protect the truststore.

Type

String

The type of store used.

Algorithm

String

The algorithm used by the truststore.

Insecure

Boolean

If true, no certificate validations will be performed, rendering connections vulnerable to attacks. Use at your own risk.

Key Store

Field Type Description Default Value Required

Path

String

The location (which will be resolved relative to the current classpath and file system, if possible) of the keystore.

Type

String

The type of store used.

Alias

String

When the keystore contains many private keys, this attribute indicates the alias of the key that should be used. If not defined, the first key in the file will be used by default.

Key Password

String

The password used to protect the private key.

Password

String

The password used to protect the keystore.

Algorithm

String

The algorithm used by the keystore.

Standard Revocation Check

Field Type Description Default Value Required

Only End Entities

Boolean

Only verify the last element of the certificate chain.

Prefer Crls

Boolean

Try CRL instead of OCSP first.

No Fallback

Boolean

Do not use the secondary checking method (the one not selected before).

Soft Fail

Boolean

Avoid verification failure when the revocation server can not be reached or is busy.

Custom Ocsp Responder

Field Type Description Default Value Required

Url

String

The URL of the OCSP responder.

Cert Alias

String

Alias of the signing certificate for the OCSP response (must be in the truststore), if present.

Crl File

Field Type Description Default Value Required

Path

String

The path to the CRL file.

Reconnection

Field Type Description Default Value Required

Fails Deployment

Boolean

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy.

Reconnection Strategy

The reconnection strategy to use.

Reconnect

Field Type Description Default Value Required

Frequency

Number

How often in milliseconds to reconnect

Count

Number

How many reconnection attempts to make.

Reconnect Forever

Field Type Description Default Value Required

Frequency

Number

How often in milliseconds to reconnect

Expiration Policy

Field Type Description Default Value Required

Max Idle Time

Number

A scalar time value for the maximum amount of time a dynamic configuration instance should be allowed to be idle before it’s considered eligible for expiration

Time Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the maxIdleTime attribute

Http Response Attributes

Field Type Description Default Value Required

Status Code

Number

x

Headers

Object

x

Reason Phrase

String

x

Repeatable In Memory Stream

Field Type Description Default Value Required

Initial Buffer Size

Number

The amount of memory that will be allocated to consume the stream and provide random access to it. If the stream contains more data than can be fit into this buffer, then the buffer expands according to the bufferSizeIncrement attribute, with an upper limit of maxInMemorySize.

Buffer Size Increment

Number

This is by how much the buffer size expands if it exceeds its initial size. Setting a value of zero or lower means that the buffer should not expand, meaning that a STREAM_MAXIMUM_SIZE_EXCEEDED error is raised when the buffer gets full.

Max Buffer Size

Number

The maximum amount of memory to use. If more than that is used then a STREAM_MAXIMUM_SIZE_EXCEEDED error is raised. A value lower than or equal to zero means no limit.

Buffer Unit

Enumeration, one of:

  • BYTE

  • KB

  • MB

  • GB

The unit in which all these attributes are expressed

Repeatable File Store Stream

Field Type Description Default Value Required

In Memory Size

Number

Defines the maximum memory that the stream should use to keep data in memory. If more than that is consumed content on the disk is buffered.

Buffer Unit

Enumeration, one of:

  • BYTE

  • KB

  • MB

  • GB

The unit in which maxInMemorySize is expressed

Redelivery Policy

Field Type Description Default Value Required

Max Redelivery Count

Number

The maximum number of times a message can be redelivered and processed unsuccessfully before triggering a process-failed-message

Message Digest Algorithm

String

The secure hashing algorithm to use. If not set, the default is SHA-256.

Message Identifier

Redelivery Policy Message Identifier

Defines which strategy is used to identify the messages.

Object Store

ObjectStore

The object store where the redelivery counter for each message is stored.

Redelivery Policy Message Identifier

Field Type Description Default Value Required

Use Secure Hash

Boolean

Whether to use a secure hash algorithm to identify a redelivered message.

Id Expression

String

Defines one or more expressions to use to determine when a message has been redelivered. This property can be set only if useSecureHash is false.

See Also

Back to top
View on GitHub