-
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…
-
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.…
-
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…
-
Can the Dynamic View form submission allow new entries to appear at the top of your Smartsheet?
I know this option is available in Smartsheet, but when you enter a form through dynamic view there is not an option to have new items to go to the top of the sheet.
-
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…
-
Gantt View data for sheet via api
I am trying to get data for a sheet which is repesented in the Gantt View. Since the ganttview already shows all the milestones and tasks that are under the milestones, getting that data would reduce our calculation by a huge chunk. any idea how can I do this via the api? The get sheets endpoint has include=ganttConfig but…
-
Pull data from Excel into a blank sheet
Hi everyone, I am trying to pull data from an Excel document into a blank canvas smartsheet. I have tried using power automate to do this however i cant see any triggers/actions that would give me the ability to do this. is this achievable through power automate. i have seen that alot of people use that application Zappier…
-
Card Order Data via API Response
I am trying to identify the order of cards in card view based on the JSON response to a GET request to the API for a sheet. I created a schedule type sheet as a test project. When I change the order of cards (by manually dragging them up and down in card view), there appears to not be any change to the response JSON that…