-
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…
-
/users API throwing User not found.
Fetching all users using below API fetches all the users with status, ACTIVE, DECLINED, DEACTIVATED. https://api.smartsheet.com/2.0/users But when we try to fetch the single user using https://api.smartsheet.com/2.0/users/abc If the user abc has status as DECLINED. It fails with error { "errorCode": 1020, "message": "User…
-
Bridge - JSON parsing - Remove HTML and match date
I'm looking for some help on how to extract particular data from a JSON response from an external API call made with Smartsheet Bridge. The API call is working fine, and I'm getting the JSON response. Part of the response is an indexed set of data within the response, that includes HTML formatting tags. I'd like to strip…
-
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…
