API and Developers
Discussion List
-
How can I use API to attach a local PDF to a Smartsheet row through Kofax/Tungsten?
I've been trying to figure out how to configure Kofax's Call REST Web Service step so I can use an API to attach local PDFs to specific rows of a Smartsheet. I keep hitting dead ends or examples for everything besides PDFs. Anyone out there know how to accomplish this task?
-
Using the API to get attachment URLs
I have PDF row attachments in a sheet. I need to get a direct URL to the attachment but I can't see a way to do this in the API. Using the GUI to "send" the file provides a link - so I'm trying to get something similar through the API. I'm aware that the the URL using the GUI method expires after 30 days. I would prefer…
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
Integration into Streamlit?
I'm looking to pull data from Smartsheet into a private Streamlit web app for a small team of people to edit data and make notes. Is this feasible? Is it as simple as just connecting the API to push and pull data?
-
404 - Error Code 1006 "Not Found"
I am attempting to get an automation in place between Smartsheet and Excel. When running the script I am receiving a Response Status 404 with a response body error code 1006 message Not Found for every singe row. I have confirmed that nothing is deleted, permissions are fine and everything looks like it should. I just can…
-
Embedding Smartsheet Calendar to SharePoint Calendar
Hello, I am trying to get a calendar on Smartsheet to sync with a SharePoint calendar. I have realized that there needs to be a flow involved to connect the two. When I try to set up a flow on SharePoint it does not connect on Smartsheet. Thank you!
-
How to get sheet owner information
I am trying to get sheet owner information through python SDK. But I am getting "None" for owner name. Am I doing something wrong here?
-
Adding a row via API using cURL adds blank row
Hi all: I'm attempting to add a child row to a sheet using the API and cURL. It took some time but finally, taking information from chatgpt and other sources, I was able to get a row added as a child in the proper place. However, the row is blank and not taking the values I am setting. curl -X POST…
-
Conditional Dropdowns functionality, not available yet?
Hello everyone, I’ve been working extensively with Smartsheet and noticed a significant limitation that has been discussed for years but still hasn’t been addressed: conditional dropdowns. Here’s the scenario I’m struggling with: In Column A, the user selects an option (e.g., "Option 1"). Based on that selection, the…
-
Downloading Attachments from a Sheet with API
Hello Smartsheet Community! I need help downloading attachments from a sheet that currently has a little over five thousand lines and manually downloading isn't ideal. I was able to extract the metadata for my sheet and revising the documentation for the Attachment Object I was able to extract the attachment id and other…