Smartsheet
The Smartsheet connector is a Palantir-provided driver connector. The official documentation for this driver can be found here ↗.
Networking
The table below lists the domains that the source needs to be able to access in order to successfully run.
If running the connection on a Foundry worker, be sure to add corresponding egress policies for each of those domains.
If those domains are in a different network from Foundry's network, and you are using agent proxy egress policies (preferred) or an agent worker (not recommended), the agent must be able to reach the domain addresses. Additionally, the systems on those domains must be configured to allow connections from the agent. Learn more about agent networking.
| 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:
