-
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…
-
Have you seen a change in the time taken to trigger a WebHook?
I use WebHook in a number of places in our Smartsheet system. In the past after a sheet was saved, WebHooks would fire and be received within a few seconds by my servers. Now I am seeing a consistent 60 second delay after save for WebHooks to contact my servers. I think this change has happened in the last 6 months. For…
-
Provide API Access to Upgrade or Downgrade Users under User Subscription Model (USM)
We recently switched over to using USM for license management. This broke our automated scripts that gave users a license. We have a number of non-member employees who we cannot automatically update via the API. I'm told there is no solution for this and we are left manually updating our free users to a licensed member.…
-
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?
