-
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…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
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…