Smartsheet
Smartsheet is a software as a service (SaaS) offering for collaboration and work management.
ingestr supports Smartsheet as a source.
URI format
The URI format for Smartsheet is as follows:
smartsheet://?access_token=<access_token>
URI parameters:
access_token
: Your Smartsheet API access token.
The URI is used to connect to the Smartsheet API for extracting data. You can generate an access token in Smartsheet by navigating to Account > Personal Settings > API Access.
Setting up a Smartsheet Integration
To set up a Smartsheet integration, you'll need an API Access Token.
- Log in to Smartsheet.
- Click on "Account" in the bottom left corner, then "Personal Settings".
- Go to the "API Access" tab.
- Click "Generate new access token".
- Give your token a name and click "OK".
- Copy the generated token. This will be your
access_token
.
The source table you'll use for ingestr will be the sheet_id
of the Smartsheet you want to ingest. You can find the sheet_id
by opening the sheet in Smartsheet and going to File > Properties. The Sheet ID will be listed there.
Let's say your access token is llk2k3j4l5k6j7h8g9f0
and the sheet ID is 1234567890123456
, here's a sample command that will copy the data from Smartsheet into a DuckDB database:
ingestr ingest \
--source-uri 'smartsheet://?access_token=llk2k3j4l5k6j7h8g9f0' \
--source-table '1234567890123456' \
--dest-uri 'duckdb:///smartsheet_data.duckdb' \
--dest-table 'des.my_sheet_data'
The result of this command will be a my_sheet_data
table containing data from your Smartsheet in the smartsheet_data.duckdb
database.
CAUTION
Smartsheet integration does not currently support incremental loading. Every time you run the command, the entire sheet will be copied from Smartsheet to the destination. This can be slow for large sheets.