How to push data into Data Table via API?

Hi

This is similar to the question I posted. All the literature says use an API or live connector but I have only managed to get Excel connect and read Smartsheet, not the other way around. I am still talking to the Smartsheet team so if I manage to find out, I'll let you know

Has there been a Feature request put in for this yet so I can Vote on it?

We need this as well.

@petulka77 @David J @marc4 @Joe Goetschel

In the absence of a direct integration between Varicent and our Data Source Systems, we have scheduled Python/SQL scripts that pull daily snapshots as online XLSXs in OneDrive. The online XLSXs are templates similar to an RDBS staging table prior to data manipulation procedures.

We created the Data Tables sourced from the online XLSX templates in OneDrive.

Data Table has filtering configuration capabilities which help reduce the Python/SQL script complexity and easy backup coverage as coworkers observe Holidays and OOOs. Make sure to share the Data Tables amongst the coworkers responsible for ongoing support and change managment.

Below is a sample Python script to get a list of all Smartsheet Groups for you to use as a test. Of course, this test will not return anything if there are no Smartsheet Groups created. Talk with your Smartsheet Admin for Group access enablement.

Python Script

import smartsheet
import pandas as pd
import openpyxl

#List ALL Smartsheet Groups

smartsheet_client = smartsheet.Smartsheet('INSERT YOUR API KEY')
response = smartsheet_client.Groups.list_groups(include_all=True)
groups = response.data

#Translate Indexed Result into a Dictionary
info = response.to_dict()['data']

#Translates Individual Groups Data Frame of Records
df = pd.DataFrame.from_records(info)

#Generate and download Excel file into OneDrive
#Update OneDrive location
df.to_excel(r'C:\Users\INSERT USERNAME\Downloads\SmartsheetGroupManagementListGroups.xlsx', index=False)