-
Bad Gateway Error when automating Office Forms API to Smartsheet
Solved: BadGateway error 502 - Power Platform Community (microsoft.com) Not sure how many of you are using Microsoft Forms to collect information and having a flow process to create a new row into smartsheet . Everything points to smartsheet, please see details in the link provided above. Can anyone from Smartsheet Support…
-
File Attachment to Row
Hi Team , I am trying to attach file to smartsheet row with the following details, https://api.smartsheet.com/2.0/sheets/{Sheet ID }/rows/{ Row ID }/attachments Header : Authorization:Bearer {ACCESS TOKEN} Content-Type:image/jpeg Content-Disposition:attachment; filename="C:\1.jpeg" ContentLength:64 Response I am getting…
-
Updating a cell in a column formula is not supported. columnId
Hi All, I am trying to update a smartsheet from a sql table. Several of the columns in the smartsheet have column formula's thus, when I try to update them, the API throws the error: "Updating a cell in a column formula is not supported. columnId" In my code, I open the smartsheet and read all the columns to build a model.…
-
Webhook is not triggering in Smartsheet
Hi Team, We are creating a webhook via API for Smartsheet sheet. After creating webhook we will add some data in the sheet to trigger the event. In some point of time the webhook is not triggering. Can you please help us here.
-
Sheet Summary Report From Smartsheet Into Appsheet
Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet. The error I'm receiving... The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in…
-
Does the unique row id have a check digit?
I need the row id (usually 16-digit) to perform query joins, to get info on attachments and their contents. In the code below, I append the row ids to an Excel sheet, but the Excel file converts back to INT. This may be a problem, as Excel only handles 15-digit INT and drops the last digit to 0. It won't be a problem if…
-
Pushing a Tableau User Name into Form-Fill through the URL
I currently use a Smartsheet Form-Fill that instantly creates commentary on a Tableau dashboard of mine. However, when a Tableau user is putting in commentary via the preset fields using a URL show/hide feature and then hits submit - the Created By reflects web-form@smartsheet.com on the Smartsheet Does anyone know of a…
-
Create Automation in the API
Any chance this is in the works? I'm not seeing a way to do in the API documentation and it'd be nice to automatically create an auotmation rule across 100 sheets instead of manually doing it.
-
Remove User API
Hello, I am attempting to remove a user and transfer their files to another user. Although the API documentation is clear, I am not getting the desired results. User gets deleted, but the sheets never get transferred: const options = { id: personToDelete.id, transferSheets: true, transferTo: userToTransferTo.id, }…
-
Cell History Log - Formatted Download Option
I know there has been a lot of discussions out there for getting the Smartsheet History Cell Log downloaded to a format that is viewable and you can actually use to analyze data.. My understanding is that Smartsheets has not developed anything to support this as of today. Asking around if anyone in this community has…
