-
Problems using Python API and Cell History - note returning all user input.
I have been using the cell history to try and grab user input. The Input comes from users typing or selecting from a drop down. The data shows fine in Smartsheets. Dates are auto added but text e.g. "11k Production process complete" is user input when using the report/sheet in Smartsheets. But then when I use this code to…
-
Why doesn't the column filter work in "Get a sheet data (dynamic schema)"? [Power Automate]
Setup: Configure dynamic schema block to extract only one column: Expected Behavior: The Power Automate Block returns an array of my rows with only the selected column values included. Issue: All columns are included, notwithstanding the setting. Here you can see at least 2 columns, but take my word for it that there are…
-
Issue with Fetching Comments from Smartsheet API in Python: 'No Attribute' Errors
I'm trying to extract comments from rows in a Smartsheet sheet using the Smartsheet Python SDK, but I'm encountering several errors, particularly 'AttributeError: 'Sheets' object has no attribute 'get_row_comments' and 'Attachments' object has no attribute 'list_attachments'. After some debugging, I realized that the API…
-
What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…
-
API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!
-
Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
-
PowerBI "Failed After Multiple Retry Attempts"
Hi, I haven't seen this exact error on the forum, point me in the direction if I missed it. I have a Power Bi page running off Smartsheets data, nothing has changed in the past week apart from using Power Automate to schedule the Power Bi refresh. I don't believe this would have any affect. Since yesterday every time I try…
-
Issue with Duplicate Rows When Using Smartsheet API in Integration with NetSuite
Hello! I've encountered an issue while integrating NetSuite and Smartsheet via API. The script works inconsistently and occasionally creates duplicate rows in the Smartsheet table. Current Script Logic: A record is created in NetSuite, triggering the script. The script collects data about the parent row. A request is sent…
-
Bridge Question: How do I Add a "^" as the First Character in All Cells in Sheet
I'm trying to use Bridge to add a ^ in front of all text in every cell in a sheet. If it works, it'll allow me to turn sheet formulas into text that can then be treated as text, which Smartsheet can actually back-up. I would likely schedule the bridge flow to run shortly before the scheduled Sheet backup. Then I would…
-
Is it possible to test code in a Sandbox, and not in the Smartsheet Production Environment?
I am VERY new to API's, Python, and Bridge. I'd like to test my scripts on our existing Smartsheet Data, but without the risk of breaking something in our Smartsheet Production environment. Besides me making mistakes, to run test scripts in our environment on production data, I need a change request and multiple meetings…