Google Sheets Connector 1.1 Reference | MuleSoft Documentation
# Google Sheets Connector 1.1 Reference
Anypoint Connector for Google Sheets (Google Sheets Connector) enables you to interface with the Google Sheets platform without having to interact with the Google Sheets API directly.
## Configurations
### Config
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Name for this configuration. Connectors reference the configuration with this name.  
Connection |  Oauth 2 0 Connection Provider | The connection types to provide to this configuration.  
Response Timeout | The timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| A time unit that qualifies the Response Timeout  
Streaming Type |  Enumeration, one of:
  * 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.  
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
### Oauth 2 0 Connection Provider
Use OAuth 2.0 to delegate user authentication to the service hosting the user account. For more information, refer to Configuring OAuth 2.0 for Connectors or Configuring OAuth 2.0 for Connectors on CloudHub.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Default Headers |  Array of Default Header  
Query Parameters |  Array of Default Query Param  
Connection Timeout | Timeout for establishing connections to the remote service.  
Connection Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Connection Timeout** field.  
Use Persistent Connections | If false, each connection is closed after the first request is completed.  
Max Connections | Maximum number of outbound connections to keep open concurrently.  
Connection Idle Timeout | Timeout for how long a connection can remain idle before it is closed.  
Connection Idle Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Connection Idle Timeout** field.  
Proxy Config | Reusable configuration element for outbound connections through a proxy.  
Stream Response | Whether or not to stream received responses.  
Response Buffer Size | The space, in bytes, for the buffer where the HTTP response is stored.  
Protocol |  Enumeration, one of: | Protocol to use for communication. Valid values are HTTP and HTTPS.  
TLS Configuration  
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 | The OAuth consumer key as registered with the service provider.  
Consumer Secret | The OAuth consumer secret as registered with the service provider.  
Authorization Url | The service provider’s authorization endpoint URL | https://accounts.google.com/oauth2/auth/  
Access Token Url | The service provider’s access token endpoint URL | https://oauth2.googleapis.com/token  
OAuth scopes to request during the dance. | 
  * https://www.googleapis.com/auth/spreadsheets
  * https://www.googleapis.com
  * /auth/drive.readonly

  
Resource Owner Id | Resource owner ID that each component should use if it isn’t otherwise referenced.  
Name of a flow to execute before starting the OAuth dance.  
Name of a flow to execute after an access token is received.  
Listener Config | Reference to an <http:listener-config /> to use to create the listener that will catch the access token callback endpoint.  
Callback Path | Path of the access token callback endpoint.  
Authorize Path | Path of the local HTTP endpoint that triggers the OAuth dance.  
External Callback Url | 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 to use to access the callback.  
Object Store | Reference to the object store to use to store each resource owner ID’s data. If not specified, Mule runtime automatically provisions the default object store.  
## Sources
  *   * 

### New Row
`<google-sheets:new-row-listener>`
Listens for when a new row is added at the end of a sheet.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | The name of the configuration to use.  
Response timeout  
Response timeout time unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Primary Node Only | 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  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost  
Redelivery Policy |  RedeliveryPolicy | Defines a policy for processing the redelivery of the same message  
Spreadsheet | ID of the spreadsheet  
Worksheet Name | Name of the worksheet  
Reconnection Strategy | 
  *   * Reconnect Forever

| A retry strategy in case of connectivity errors  
#### For Configurations
### New Spreadsheet
`<google-sheets:new-spreadsheet-listener>`
Listens for when a new spreadsheet is created in the Google Drive associated with the connection. Google Sheets are not saved at the moment of creation; instead, they are saved the first time they are edited. Adding a new spreadsheet won’t trigger a flow until after that spreadsheet is edited and saved.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | The name of the configuration to use.  
Response timeout  
Response timeout time unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Primary Node Only | 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  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost  
Redelivery Policy |  RedeliveryPolicy | Defines a policy for processing the redelivery of the same message  
Reconnection Strategy | 
  *   * Reconnect Forever

| A retry strategy in case of connectivity errors  
#### For Configurations
### Updated Row
`<google-sheets:updated-row-listener>`
Listens for when a row is created or updated in a sheet.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | The name of the configuration to use.  
Response timeout  
Response timeout time unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

  
Include Newly Added Rows | Indicates whether to include newly added rows in the output.  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Primary Node Only | 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  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost  
Redelivery Policy |  RedeliveryPolicy | Defines a policy for processing the redelivery of the same message  
Spreadsheet | The ID of the spreadsheet  
Worksheet Name | The name of the worksheet  
Reconnection Strategy | 
  *   * Reconnect Forever

| A retry strategy in case of connectivity errors  
### For Configurations
## Supported Operations
  * Append Spreadsheets Values
  * List Drive Files
  * Get Spreadsheet Properties
  * Get Spreadsheets Values
  *   * Update Spreadsheets Values
Include Newly Added Rows | Indicates whether to include newly added rows in the output.  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Primary Node Only | 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  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost  
Redelivery Policy |  RedeliveryPolicy | Defines a policy for processing the redelivery of the same message  
Spreadsheet | The ID of the spreadsheet  
Worksheet Name | The name of the worksheet  
Reconnection Strategy | 
  *   * Reconnect Forever

| A retry strategy in case of connectivity errors  
### For Configurations
## Supported Operations
  * Append Spreadsheets Values
  * List Drive Files
  * Get Spreadsheet Properties
  * Get Spreadsheets Values
  *   * Update Spreadsheets Values


## Append Spreadsheets Values
`<google-sheets:create-spreadsheets-values-rangeappend-by-spreadsheet-id>`
Appends values to an existing spreadsheet, as determined by the specified range This operation makes an HTTP POST request to the `/spreadsheets/{spreadsheetId}/values/{range}:append` endpoint.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | The name of the configuration to use.  
Spreadsheet | ID of the target spreadsheet.  
A1 notation of a range that determines where to start appending the values. The values are appended starting in the first column and after the last row in the specified range.  
Value Input Option |  Enumeration, one of:
  * USER_ENTERED
  * INPUT_VALUE_OPTION_UNSPECIFIED

| Indicates how to interpret the new content: INPUT_VALUE: Default input value. This value must not be used. RAW: Append the content as is, without parsing it. USER_ENTERED: Parse the values as if they were entered into the Google Sheets UI. | USER_ENTERED  
Insert Data Option |  Enumeration, one of:
  * INSERT_ROWS
  * OVERWRITE

| Determines how existing data is changed when new data is input.  
Content Type | Type of content | application/json  
Spreadsheets Values Rangeappend Content | Content to append | #[payload]  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost.  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| A time unit that qualifies the Response Timeout  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Attributes Type |  HTTP Response Attributes  
---|---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:RETRY_EXHAUSTED
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE


## List Drive Files
`<google-sheets:get-files>`
Returns a list of the user’s Google Drive files. This operation makes an HTTP GET request to the `/files` endpoint.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | The name of the configuration to use.  
Page Size | Page size for the returned results  
Search query  
Paths to the fields to include in the response. Use `*` to retrieve all fields.  
Order By | Order By  
Output Mime Type | The MIME type of the payload that this operation outputs.  
Config Ref |  ConfigurationProvider | The name of the configuration to use to execute this component  
Streaming Strategy | 
  * Repeatable In Memory Iterable
  * Repeatable File Store Iterable
  * non-repeatable-iterable

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| A time unit that qualifies the Response Timeout  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Array of Any  
---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE


## Get Spreadsheet Properties
`<google-sheets:get-spreadsheets-by-spreadsheet-id>`
Returns the Properties of the specified Google spreadsheet. This operation makes an HTTP GET request to the `/spreadsheets/{spreadsheetId}?fields=sheets.properties` endpoint.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | Name of the configuration to use.  
Spreadsheet Id | ID of the target spreadsheet.  
Paths to the fields to include in the response. Use `*` to retrieve all fields.  
Content Type | Content type | application/json  
Config Ref |  ConfigurationProvider | Name of the configuration to use to execute this component.  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost.  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Response Timeout** field.  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever
| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost.  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Response Timeout** field.  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Attributes Type |  HTTP Response Attributes  
---|---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:RETRY_EXHAUSTED
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE


## Get Spreadsheets Values
`<google-sheets:get-spreadsheets-values-by-spreadsheet-id-range>`
Returns the values from the specified range in a Google spreadsheet. This operation makes an HTTP GET request to the `/spreadsheets/{spreadsheetId}/values/{range}` endpoint.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | Name of the configuration to use.  
Spreadsheet | ID of the target spreadsheet.  
A1 notation of the range for which to return properties. You can specify multiple ranges.  
Config Ref |  ConfigurationProvider | Name of the configuration to use to execute this component.  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost.  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Response Timeout** field.  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Attributes Type |  HTTP Response Attributes  
---|---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:RETRY_EXHAUSTED
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE


## Unauthorize
`<google-sheets:unauthorize>`
Deletes all of the access token information associated with a given resource owner ID, so that it’s impossible to execute an operation for that user without repeating the authorization dance.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | Name of the configuration to use.  
Resource Owner Id | ID of the resource owner for whom to invalidate access.  
Config Ref |  ConfigurationProvider | Name of the configuration to use to execute this component.  
### For Configurations
## Update Spreadsheets Values
`<google-sheets:update-spreadsheets-values-by-spreadsheet-id-range>`
Updates the values of a spreadsheet at the specified range. This operation makes an HTTP PUT request to the `/spreadsheets/{spreadsheetId}/values/{range}` endpoint.
### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Configuration | Name of the configuration to use.  
Spreadsheet | ID of the target spreadsheet.  
A1 notation of the range for which to update values.  
Value Input Option |  Enumeration, one of:
  * USER_ENTERED
  * INPUT_VALUE_OPTION_UNSPECIFIED

|  Indicates how to interpret the new content:
  * INPUT_VALUE: Default input value. This value must not be used.
  * RAW: Append the content as is, without parsing it.
  * USER_ENTERED: Parse the values as if they were entered into the Google Sheets UI.

| USER_ENTERED  
Content Type | Content type | application/json  
Spreadsheets Values Rangeappend Content | Updated values | #[payload]  
Config Ref |  ConfigurationProvider | Name of the configuration to use to execute this component.  
Streaming Strategy | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

| Disables the repeatable stream functionality and uses non-repeatable streams to have less performance overhead, memory use, and cost.  
Custom Query Parameters | 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 | 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 | Timeout for the request to the remote service.  
Response Timeout Unit |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

| Time unit for the **Response Timeout** field.  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Attributes Type |  HTTP Response Attributes  
---|---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:RETRY_EXHAUSTED
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE
| Time unit for the **Response Timeout** field.  
Streaming Type |  Enumeration, one of:
  * 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 | Name of the variable that stores the operation’s output.  
Target Value | Expression that evaluates the operation’s output. The expression outcome is stored in the target variable. | #[payload]  
Reconnection Strategy | 
  *   * Reconnect Forever

| Retry strategy in case of connectivity errors.  
### Output
Attributes Type |  HTTP Response Attributes  
---|---  
### For Configurations
### Throws
  * GOOGLE-SHEETS:BAD_REQUEST
  * GOOGLE-SHEETS:CLIENT_ERROR
  * GOOGLE-SHEETS:CONNECTIVITY
  * GOOGLE-SHEETS:INTERNAL_SERVER_ERROR
  * GOOGLE-SHEETS:NOT_ACCEPTABLE
  * GOOGLE-SHEETS:NOT_FOUND
  * GOOGLE-SHEETS:RETRY_EXHAUSTED
  * GOOGLE-SHEETS:SERVER_ERROR
  * GOOGLE-SHEETS:SERVICE_UNAVAILABLE
  * GOOGLE-SHEETS:TIMEOUT
  * GOOGLE-SHEETS:TOO_MANY_REQUESTS
  * GOOGLE-SHEETS:UNAUTHORIZED
  * GOOGLE-SHEETS:UNSUPPORTED_MEDIA_TYPE


## Types
### Default Header
Headers automatically added to every outbound request.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
### Default Query Param
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
### Proxy
Configures the settings used to connect through a proxy.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Hostname or IP address of the proxy server.  
Port of the proxy server.  
Username to authenticate against the proxy server.  
Password to authenticate against the proxy server.  
**Non Proxy Hosts**  
Configures TLS to provide secure communications for the Mule app.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Enabled Protocols** |  A comma-separated list of protocols enabled for this context.  
**Enabled Cipher Suites** |  A comma-separated list of cipher suites enabled for this context.  
**Trust Store** |  Configures the TLS truststore.  
Configures the TLS keystore.  
**Revocation Check** | 
  * Standard Revocation Check
  * Custom OCSP Responder

  
### Trust Store
Configures the TLS truststore.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Path to the truststore. Mule resolves the path relative to the current classpath and file system, if possible.  
Password used to protect the truststore.  
The type of truststore used.  
Algorithm used by the truststore.  
If `true`, Mule stops performing certificate validations. Setting this to `true` can make connections vulnerable to attacks.  
### Key Store
Configures the TLS keystore.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Path to the truststore. Mule resolves the path relative to the current classpath and file system, if possible.  
Type of keystore used.  
Alias of the key to use when the keystore contains multiple private keys. By default, Mule uses the first key in the file.  
**Key Password** |  Password used to protect the private key.  
Password used to protect the keystore.  
Algorithm used by the keystore.  
### Standard Revocation Check
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Only End Entities** |  Only verify the last element of the certificate chain.  
**Prefer Crls** |  Try CRL instead of OCSP first.  
**No Fallback** |  Do not use the secondary checking method (the one not selected before).  
Avoid verification failure when the revocation server can not be reached or is busy.  
### Custom OCSP Responder
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
The URL of the OCSP responder.  
**Cert Alias** |  Alias of the signing certificate for the OCSP response (must be in the trust store), if present.  
### CRL File
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
The path to the CRL file.  
### Reconnection
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Fails Deployment** |  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** | 
  *   * Reconnect Forever

|  The reconnection strategy to use.  
### Reconnect
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
How often in milliseconds to reconnect  
If false, the reconnection strategy runs in a separate, non-blocking thread  
How many reconnection attempts to make.  
### Reconnect Forever
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
How often in milliseconds to reconnect  
If false, the reconnection strategy runs in a separate, non-blocking thread  
### Expiration Policy
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Max Idle Time** |  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  
Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  A time unit that qualifies the maxIdleTime attribute  
### HTTP Response Attributes
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Status Code**  
**Reason Phrase**  
### Repeatable In Memory Stream
Configures the in-memory streaming strategy by which the request fails if the data exceeds the buffer size. Always run performance tests to find the optimal buffer size for your specific use case.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Initial Buffer Size** |  The amount of memory that is 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** |  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** |  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: |  The unit in which these attributes are expressed  
### Repeatable File Store Stream
Configures the repeatable file-store streaming strategy by which Mule keeps a portion of the stream content in memory. If the stream content is larger than the configured buffer size, Mule backs up the buffer’s content to disk and then clears the memory.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**In Memory Size** |  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: |  The unit in which maxInMemorySize is expressed  
### Repeatable In Memory Iterable
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Initial Buffer Size** |  Initial amount of memory to allocate to the memory stream. If the stream data exceeds this value, the buffer expands by **Buffer Size Increment** , with an upper limit of **Max In Memory Size value**. Default value is 100 instances.  
**Buffer Size Increment** |  Amount by which the buffer size expands if it exceeds its initial size. Setting a value of `0` or lower specifies that the buffer can’t expand. Default value is 100 instances.  
**Max Buffer Size** |  Maximum size of the buffer. If the buffer size exceeds this value, Mule raises a `STREAM_MAXIMUM_SIZE_EXCEEDED` error. A value of less than or equal to `0` means no limit.  
### Repeatable File Store Iterable
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**In Memory Objects** |  The maximum amount of instances to keep in memory. If more than that is required, content on the disk is buffered.  
**Buffer Unit** |  Enumeration, one of: |  The unit in which maxInMemorySize is expressed  
## See Also
  * Introduction to Anypoint Connectors MuleSoft Help Center