stmcallister

#!/usr/bin/env python
import smartsheet
import os
import json

ss_client = smartsheet.Smartsheet(os.environ['SMARTSHEET_ACCESS_TOKEN'])
ss_client.errors_as_exceptions()

sheet_ID = xxxxxxxxxxxxxxxx

tbuckl

from smartsheet import *
import pandas as pd
from credentials import smartsheet_token

smartsheet = smartsheet.Smartsheet(smartsheet_token)

def get_sheet_as_df(sheet_id):
    ss1 = smartsheet.Sheets.get_sheet(sheet_id, page_size=0)
    row_count = ss1.total_row_count
    ss1 = smartsheet.Sheets.get_sheet(sheet_id, page_size=row_count)