Linux Python 3.6 script example to download a Smartsheet?
I've been searching for several days for a Python SDK script to download a Smartsheet that I have previously created. I have an existing Smartsheet with 5 columns, and 2690 rows. I only want to download the first column which is a number and assign it to an array.
What I've tried so far:
Smartsheet offers a solution where I can the Internet URL to the Excel Data Source. However, when I try retrieving the data, I get a timeout. There is about 2690 rows and 5 columns to download.
Searching the Internet, I found a potential Python solution using an app and attempted to install pip install simple-smartsheet. The install results in "already satisfied" messages when running.
However, when I try to run their example script:
from datetime import date
from pprint import pprint
from simple_smartsheet import Smartsheet
from simple_smartsheet.models import Sheet, Column, Row, Cell, ColumnType
# SMARTSHEET_API_TOKEN is in the Environment
TOKEN = os.getenv("SMARTSHEET_API_TOKEN")
SHEET_NAME = "[TEST] My New Sheet"
smartsheet = Smartsheet(TOKEN)
I get the error:
pi@SmartSheet:~/Documents/tscripts $ ./mat.py
./mat.py: line 1: import: command not found
from: can't read /var/mail/datetime
from: can't read /var/mail/pprint
from: can't read /var/mail/simple_smartsheet
from: can't read /var/mail/simple_smartsheet.models
./mat.py: line 8: syntax error near unexpected token `('
./mat.py: line 8: `TOKEN = os.getenv("SMARTSHEET_API_TOKEN")'