-
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…
-
Report Row Sorting
I am trying to use reports to reduce the amount of columns and rows I need to handle via the API. Along with this, I would like to have the report also sort the rows, but it seems that when using the API make a Get Report request, the row numbers in the JSON response do not line up with the associated reports row numbers.…
-
Re:apostrophe
Currently I am pushing data to smartsheet using the API, however, I notice that numbers that have say dashes in front of them to denote them being negative, or any non-numeric elements, causes every record in that column to be pushed as text, together with an invisible apostrophe in front of it that only shows when I click…
-
Has anyone mapped their Smartsheet files using the API?
2 part question here. My company is currently looking at ways to map how all of our sheets link to one another in a consolidated database. A thought that came to mind is using the Smartsheet API to access all of the underlying data (sheet id, name, column ids, cross sheet references, etc.) and store them in a database so…
-
Using GetSheet method returns Unexpected character encountered while parsing value: <. Path '', line
This is just using the basic code that is provided in the Github documentation. Stack Trace; at Smartsheet.Api.Internal.AbstractResources.HandleError(HttpResponse response) at Smartsheet.Api.Internal.AbstractResources.GetResource[T](String path, Type objectClass) at Smartsheet.Api.Internal.SheetResourcesImpl.GetSheet(Int64…
-
How to insert a value for Contact List Column from c# using api
Hi all, I need to insert a value for a column, whose type is column list, from c# using api. I have even tried by defining the value and display value for this column from c#, but it does'nt get reflected on sheet. Thanks! Shoaib
-
Proofs access using API.
Using API, https://api.smartsheet.com/2.0/sheets/{sheetid}/proofs I get error "errorCode": 4000, "message": "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance.", "refId": "qtifuqjgvlkz" However, i can get list of attachments using…
-
Python -- Add Image to Cell: file name/display name adopt file path
Hi, smartsheet_client.Cells.add_image_to_cell(sheet_id, row_id, col_id, r'/Users/me/pic_name', 'png') result image added to cell: _Users_me_picname.png I want it to just be picname.png How do I ensure the path is stripped in the resulting image name/image display name? Thanks
-
API - DELETE by rowid met with an unauthorized error
Hi there, I've developed logic/code that will delete records based on a date using the rowid. Unfortunately, the delete call does not work when executed from my bi server using Pentaho. I am able to successfully delete when using Postman (from the bi server) so I can prove my authentication and call are "correct." Any…