-
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…
-
Enable File Handling in Bridge
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…
-
Can Bridge use Smartsheet APIs with HTTP Call Utility Function?
Hi, I'm trying to manage some automated attachments of files to rows in Smartsheet. I've gotten to the point of retrieving the file from its source and am ready to upload it to a Smartsheet row via API. I also have this API request working in Postman. Where I am struggling is when I try to implement this API request in…
-
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
-
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…
-
Attachments vs Discussion with Attachments
Am using below Smartsheet API to get all the attachments. It brings the attachments from attachments and attachment available under Discussion. No problem in that. smartsheetclient.Attachments.get_attachment(sheet_id, attachment_id) While deleting the attachments using the below API. Here the problem is attachments section…
-
Smartsheet sending multiple previously updated records for each "on record updated"
I'm using a 3rd party connector to push data to another system when a Smartsheet record is updated. At the start of the day, if I update 1 record, it triggers one "on record updated" event. For every additional change I make to another record, it will be added to the sent events - so if I update a 2nd record and save, it…
-
Attempting PUT method on Reports "sourceSheets" field... Does anyone know what the API is expecting?
Hello! I am attempting to use the PUT method on a Report to update the source sheets, but cannot figure out how it wants the source sheets to be formatted.. Like what information do I need to put for each sheet in my array of sourceSheets? I am using Powershell. Here is my code so far: $token = <API TOKEN> $reportID = <ID…
-
Why is Smartsheet only adding one blank row instead of all the rows it read from G-sheet?
Hi, I'm trying to make a script from Apps Script to work with Smartsheet and I'm stuck. The script is to process some rows that need to be copied to a specific Smartsheet based on some filtering criteria, but after the script runs, we can see the following. Is there anything that might be preventing Smartsheet from pasting…