Smartsheet
The Smartsheet connector is a Palantir-provided driver connector. Review the official documentation for this driver ↗.
Networking
If using an agent connection, the agent must be allowed to connect to the system you choose. This means that the agent must be able to reach the destination IP address, and the destination system must be configured to allow connections from the agent.
If using a direct connection, be sure to add the following egress policies to the connector:
| Domain | Required |
|---|---|
| api.smartsheet.com | Only if Region=GLOBAL (default) |
| app.smartsheet.com | Only if Region=GLOBAL (default) |
| api.smartsheet.eu | Only if Region=EU |
| app.smartsheet.eu | Only if Region=EU |
| api.smartsheetgov.com | Only if Region=GOV |
| app.smartsheetgov.com | Only if Region=GOV |
Connection settings
The URL field cannot be modified and is fixed as jdbc:smartsheet:. The Java properties section can be used as an alternative to modifying the JDBC URL.
For example, to represent the following JDBC URL:
jdbc:smartsheet:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333;, you can specify the additional properties in the Java properties section as follows:
