-
Bulk POST operation syntax
Hi. I have been able to stumble my way to successfully add new rows to my Smartsheet with the POST API request. However, I can't figure out the correct format to send more than one row at a time. I see reference to Bulk Operations in the documentation but I can't find any examples of exactly what that looks like. Would…
-
c# api v4 and home
Hi, In the recent changes of the c# sdk, /home is being replaced by /folders/personal. Yet the new endpoint, is a major regression in terms of data returned: Workpaces are missing Sub sheets are missing Sub folders are missing Sub report are missing Sights/dashboard are missing So I have to rebuild a tree hierarchy I'll…
-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
URGENT BUG : Endpoint https://api.smartsheet.com/2.0/users/sheets giving an incorrect response
Hi Team, @Genevieve P. We have been using this endpoint to fetch the sheets, this used to return the owner that was needed to be used in subsequent api calls with 'Assume-user'. Somehow the above api call is returning the owner field as empty and the ownerId as a 0. Therefore, all my processes are failing. Can someone…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Using WebHooks & API to create your own custom Column Functions
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to their sheets nearly as easily as they can add formulas. They do NOT need my help as a programmer For example here are a couple…
-
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?
-
Add_Row Data Format
Hello, I am having issues adding rows of data to my sheet through the smartsheet python sdk. I am successfully able to import files and create sheets but when I try using add row via the add_row method, but I see no update or data being added to my sheet. I am even getting SUCCESS status message back from the api request.…
-
Is there a way to the send the pdf attached to a row out as an email attachment?
Hi, I am using document generator to generate a pdf from a row in my Smartsheet. I want to then be able to send this pdf as an email attachment automatically. Is there a way to do this? Do I need to use API? Thank you!
-
Saving Form to Row
Good afternoon SM team, Are you doing well?! What would be a great addition to the SM platform is, if you complete a form, for that form to be attached to a specific row. It would assist in audits whereby you have to give prove of the form that have been completed. This would be super cool. Best regards,