Smartsheet
The Smartsheet connector is a Palantir-provided driver connector. The official documentation for this driver can be found here ↗.
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 | If Region=GLOBAL (default) |
| api.smartsheet.eu | If Region=EU |
| api.smartsheetgov.com | If Region=GOV |
| app.smartsheet.com | Only for Authorization URL, If Region=GLOBAL (default) |
| app.smartsheet.eu | Only for Authorization URL, If Region=EU |
| app.smartsheetgov.com | Only for Authorization URL, If Region=GOV |
Connection settings
The URL field cannot be modified and is fixed as jdbc:smartsheet:. The JDBC 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 JDBC properties section as follows:
