-
Adding Image to Cell from gdrive URL automatically using Python & Smartsheet API
Hi All, I am currently trying to automatically adding image into a cell in smartsheet using Smartsheet API and Python. So, we have two column : Column A containing image URL Column B where we want to add the image from gdrive URL I have hundred rows, meaning we have hundreds cell on column B to add image from column A. I…
-
Bridge: Running Report and writing information to Smartsheet from Resource Management
I am using Bridge to try and pull information from a Resource Management report into a SmartSheet. Today I have an admin do this manually, but I would like to automate this so that it can be completed manually. I have the report running in Bridge and it is returning 34 items which is expected. I know that I need to then…
-
get_sheet(sheet_id) returns all rows (even above max 10000) instead of default 100.
Hello everyone, I've been working with the get_sheet() function and have noticed this behavior. When I do not set the page_size the function returns all the rows, even when there are more than 10,000 rows in the sheet. However, when I set page_size to 100, it correctly returns 100 rows. For sheets with 10,000 rows or more,…
-
Bridge-Sharepoint Connection
Hello, Our sharepoint connection with Smartsheet bridge start having issues since 3/28. We did not change anything at our side yet. Please help assist how we can get the issue resolved and many thanks.
-
Any idea of vb code to assign hierarchy level of a big amount of rows?
I try to organize a 2000 rows hierarchly, depneding on level 0 (root), 1, 2 and so on. Made it row by row but it took so much time and smartsheet seems to time out giving me errors. I can't send bulk rows update because it says that rows must have same row parent id, sibling id, ecc... but in my case level 1 ha 0 as parent…
-
Does smartsheet have an endpoint for fetching the security controls from the admin centre
Hi @Lee Joramo @Genevieve P. Is there an end point/api or a sdk for fetching the the security controls from the Admin Centre page on the UI. If yes, does the access token need additional permissions. If No , Is there any other way to fetch these info. Or is it under development and when is it expected. Thanks, Narinder
-
API sending data from DOMO to SmartSheet does not allow formulas to work
We are using the pre-built DOMO writeback connector to send data from DOMO into SmartSheet. The data is updated daily with the intent that rows in SmartSheet today will be cleared and replaced with refreshed data tomorrow. Consider this dataset 'A'. We have another dataset 'B' that is contained within SmartSheet and has a…
-
API AttributeError: data
DEBUG:smartsheet.util:object 'Sheet' is missing property 'resource_management_type' DEBUG:smartsheet.util:object 'Sheet' is missing property 'cell_image_upload_enabled' DEBUG:smartsheet.util:object 'Sheet' is missing property 'is_multi_picklist_enabled' Traceback (most recent call last): File…
-
Bridge - Error with POST call to API - Invalid Body
I'm trying to make a post call to an API using the "Call API" action within Bridge. Unfortunately, every time I try this action, it fails with an "Invalid Payload" response. I've tested the payload in Postman, and it seems to be working correctly. The API I'm using is a "POST" to a Slack Webhook. (It will automatically…
-
Strategy to bulk import users on free plans
Anyone tackled importing an unknown large number of free users to a paid plan (Enterprise)? Any strategies other than turning on UAP for a period of time?
