-
Discrepancy in API document and response for Sheet Object
I noticed in the Sheet Object API document, https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object, the field is "proofs" object, while in the API response for the same for "Get Sheet" API, the field is a "proof" object. There is a difference in singular and plurality, Is this a discrepancy? Can you please help…
-
Question about nitpicky detail on dealing with infinite loop issues of Webhooks.
I think I understand that a webhook "Callback" is itself comprised of several "Callback Events", each of which may have its own changeAgent property, a string with a comma-separated list of change agents. Further I understand how I may append my own changeAgent designator in the SmartsheetChangeAgent header of any API I…
-
How to update the value of a summary field if it's text?
We introduced a new process where our team needs to fill in a bunch of summary fields for every smartsheet. I'm trying to update the data for summary fields using APIs for existing smartsheets as a backfill. I have all the data in a google sheet. I'm using Zapier to make the API call for every row in the google sheet. I…
-
How we can verify refresh token mechanism if token will expire in 7 days?
For our smartsheet account, Access token is getting expired in 7 days. As we refer to the support documents, we need to implement the refresh token to make it working continuously. One challenge we are facing here, after implementing a refresh token mechanism. We are not able to verify due to the current feature where…
-
Why did you break your API documentation?
it used to be top notch and extremely easy to use, now its a pain most of the important info is hidden! I mean for instance if you don't know where in the documentation to look for say update-cell syntax - you cant use the search to find it! If I am wrong what query string do you have to enter into the search to find the…
-
Smartsheet URL and Redirect URL for connection with Celonis
Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret but everytime I try to connect both, Smartsheets shows an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP…
-
Custom object for expenses (SmartSheet Resource Management)
Hello! I've been asked to create a way to easily parse out expenses into project versus pass through. Is there a way to do this without creating duplicate categories (i.e., "Pass through_expense category 1" and "Project_expense category 1"). I've created custom objects in other PPM software and not sure if that's possible…
-
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…
-
Where is the best place to find help with Power Automate Integration
I happen to be the power automate guru for my team, which isn't saying much. Problem I'm trying to solve: when a cell updates (based on certain target columns), extract that info to a SharePoint list (or some other repository). Why? We have several different project tracking systems and want to consolidate info into one…
-
.net 6?
Hi, Any estimate on .net 6 for the api? Issue seems to be RestSharp and its last major update. Your code when pushed to new AWS .net 6 runtime fails: Void RestSharp.RestClient.set_FollowRedirects(Boolean) at SmartsheetBuilder().SetAccessToken(apiToken).Build() We are using smartsheet-csharp-sdk @ 2.126.0 Many thanks, Brian