-
Get values from a custom column
Hi All. ¿Can we get values from a custom or native SmartSheet column using the API? Or there are limits or restriction? Please ¿Can you share me the link where the API limits are documented? We have a requeriment to get values from a custom column using functions implemented on Google Cloud. Thanks in advance
-
Multi-picklist using a list of element "errorCode": 5536
I'm trying to implement a multi_picklist with a list of elements, the following code works with one element but fail with a second one, so I think the structure is good, but the format of my list maybe wrong or I'm missing something def listToString(s): str1 = "" for e in s: str1 += e print(str1) return str1…
-
How do I automate Smartsheet API "get_sheet" function to go through a list of sheets and save data?
Hi, I'm currently creating a catalogue of all sheets in a workspace using the "get_sheet" function. The data I'm collecting (crossSheetReferences, cellLinkIn, LinksOut) can only be found within the "get_sheet" function. I have a list of sheet ID's (sheet_list) that I use for collecting data. My code (python) looks like…
-
API Question
I'm trying to get a list of all the shares for a sheet. This would include all the item shares(someone shared this specific sheet) and the workspace shares (someone can access the sheet because the workspace was shared. According to the API documentation this call should do it: curl --silent…
-
When I scan a barcode using a form, an extra ' is entered before the number.
I´m using the barcode scan function in a form to enter the barcode. However, when I do the scan an extra character , ', is entered in front of the number. So instead of the number 10345470605 being entered, '10345470605 is entered instead. This is creating errors when I later do an INDEX/MATCH. How can I get rid of this…
-
Push Row with Attachment
Hallo, I create integration from my form on the website to connect to Smartsheet using API. I want to push data with attachment in one time process, it's that possible? Thanks,
-
Onbase connection
Hello! I'm wondering if anyone has any experience connecting Smartsheet to Onbase, either with the API, or a third party app?
-
How can I make a mock DB to be pulled into Alteryx?
I am working on a school project and am having some issue figuring this out. My team and I's problem is that we have 24 XML files from our sponsor (they make custom garage doors), and it is unstructured data that needs to be organized to be able to determine trends, patterns, etc. We need help on figuring out how to create…
-
How to write to a Smartsheet "Restrict to date only" cell using API?
Hello All! Need your help. With Python using Smartsheet API, I am trying to write to a date only column. I am getting the below error. v1=datetime.datetime.utcnow().date() new_cell = ss_client.models.Cell({'column_id': 123456789, 'object_value': v1, 'strict': False}) {"result": {"errorCode": 1012, "message": "Required…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
