How to push data into Data Table via API?

petulka77

Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read about the Data Shuttle but it looks like it only pulls data from other supported DAM solutions.

David J

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

marc4

Currently you would need to export the data from the remote system into a csv and then use data shuttle to upload it to the DataTable.

/marc

petulka77

https://community.smartsheet.com/discussion/comment/377029#Comment_377029

Thanks David. Please keep us posted.

Danielle Wilson

@petulka77 Not at the moment but this is on our roadmap! If you have a chance this would be a great one to submit on Product Feedback & Ideas so we have visibility into the demand.

Joe Goetschel

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

We need this as well.

Rachel Beck

I tried to look through the product enhancement ideas but I didn't see anything for this specific request - I'd love to upvote this if it has already been submitted as an idea.

Erin Horiuchi Green

@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)