Smartsheets
Prerequisites
To configure the Smartsheet Source for syncs, you'll need the following:
- A Smartsheets API access token - generated by a Smartsheets user with at least read access
- The ID of the spreadsheet you'd like to sync
Setting up the Smartsheets connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Authorization Method | Yes | ||
| 2 | Sheet ID | Yes | The spreadsheet ID. Find it by opening the spreadsheet then navigating to File > Properties | |
| 3 | Start Datetime | No | 2000-01-01T13:00:00 2000-01-01T13:00:00-07:00 | Only rows modified after this date/time will be replicated. This should be an ISO 8601 string, for instance: 2000-01-01T13:00:00 |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.