-
Auto Sort sheet using API - Python
I have a code that should work to auto-sort my sheet, but I keep getting the message below. Others have used this script with no problem. Any advice would be greatly appreciated. Error sorting sheet. Status code: 405 "errorCode" : 1122, "message" : "Requested URL does not support this method: PUT", Here is the script I…
-
Auto-sort using API
I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?
-
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?