API & Developers

Archives for November 2022

Url links for attachements
Hello, My Ict department blocked out all website except for the tools we use On the tablets we want to view .jpg and .pdf files As far as i know they are stored on com.smartsheet.android.file/attachments or s3.amazonaws.com ? we gave both urls premissions to beeing viewed but still it says Links of content are blocked,…
Formula needed to show project week
Hi all, I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date. Example: If my project started on 31/10 this will be week 1. The formula looks at the task start and finish date and returns - 1,2,3. This is…
Unable to run sample C# read-write-sheet in Visual Studio Code [New SS user]
As the title suggests, I am testing out the smartsheet sample API code in Visual Studio Code. I have cloned the repository from GitHub and run the Program.cs script with hopes that the code would run successfully. I had installed Git and the .NET 7.0 as required before running the code.…
Smartsheet Webhook callback
Hi, When the smartsheet event callback is send to the url (server) it expects to receive a call back acknowledgment (status 200). If the subscriber fails to respond with a 200 status, depending on the response, Smartsheet may retry delivery up to 14 times. My question is how much time do we have to send back the call back…
Pull Data from Power Bi to Smartsheet
Hi, I would like to integrate Power bi with Smartsheet and pull the data on the tables on Power bi to Smartsheet. Is there a way to make this connection ? The reason i need to do this is to make my employee see the data through Smartsheet not from Power bi. Thank you.
smartsheet api: how to read a certain cells value from google apps script
Hi all, could someone please help me how to read a certain cells value from google apps script? I have token, sheet id, col id and row id, but do not know how to do the code. Thank you, Joachim
Is there a way to create Folder and Sheets using C# SDK
Hi, I have built a custom form in the portal using C# and would like to create a folder & sheets in Smartsheet using C# SDK How can I achieve this? Is there a way? Thank you Joseph - Copernics Consulting | congruent Global https://copernicusworld.com/ | https://congruentglobal.com/
Is there a maximum length for a Webhook Shared Secret?
Smartsheet will randomly generate a Shared Secret to use to check signatures on Webhooks to authenticate them. I will need to store that shared secret in a database. I need to know the maximum length that this Shared Secret could be. What is it? Thanks.
How to guarantee proper results on "GetSheet" API after "UpdateSheet" API"?
Imagine a gantt-style Project sheet with many tasks on it. That sheet was created with a particular work schedule (days of week, and hours per day) and a particular holiday schedule. Now use the UpdateSheet API call to update the sheet and change the work schedule and/or holiday schedule. This will cause cascading changes…
When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?
Hello. Imagine you have created a sheet, and used the webhook API to designate a webhook about that sheet, and enabled that webhook. QUESTIONS: If you delete the sheet, are you guaranteed a webhook event for a deleted sheet? And if so, how would you know the event was about the sheet deletion? Is the webhook associated…

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Discussion List