-
What's the easiest way to grab all specific JSON data from a Smartsheet JSON?
I have a sheet that I have imported. I have a column that I'm trying to grab all the values from and add them to a list in Python what would be the easiest way to go about this from the development end?
-
Get Request for Sheet works, get request for column doesn't?
Any idea why this would be happening Use get request in Postman like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId} That works but any attempt to grab the columns doesn't like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId}/columns. Instead, I get this message: { "errorCode": 1006,…
-
API Service Account Login
I am extensively using the API to create actions and generate data in sheets and the source of that data always shows up as my user, I would either like the option to make that show up as the smartsheet automation user or as a service account so the ability to generate a username and an API key under my account that will…
-
Can you use the API to call and get just the first row ID?
I have 10,000K line database and I need just the row ID for the first row -- currently I'm grabbing the entire JSON table to then query for the ID, but that takes a bit of time. Is there a re way to just ask for that first row ID? You can do this for columns like this: first_column = []…
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…
-
Creating rows as children using the API
I've successfully created a Python script to update a sheet in Smartsheets based off a table in postgres. The postgres table updates every hour, so I have the code running every hour after the update. It works great. I have the code set up to create my dataframe, delete all the rows in the sheet, then append all the new…
-
What causes a column ID to change?
Hello, What can cause a column ID to change? We have an integration from one of our software applications to a sheet, and we are having issues because the column ID will change without us knowing. Also, is there a way to see the column ID without having to use the API? For example, through a portal? We opened a ticket for…
-
Web Push Notifications to Windows 10 Notification Center
We have been relying on email to notify people of any Smartsheet notifications they may be receiving as our users are not in the application daily. The problem with the emails is that our company will not add anything to external to our safe sender's domain, so anything from Smartsheet comes along with a huge red banner…
-
Trigger Data Shuttle to run with the API
Can't schedule a data shuttle monthly, so maybe if we could trigger a workflow run via the API that would solve that problem.
-
Can Dynamic Views be manipulated via the API?
Our business is considering adding Dynamic Views, but we would want to set them up/manage them programmatically. Is this possible?
