API & Developers

Archives for June 2021

Discussion List

  • Multi-picklist using a list of element "errorCode": 5536
    In API & Developers
    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 l…
    Accepted
    34 1
    Accepted Answer 34 views 1 comment Most recent by Alex Argumedo API & Developers
  • Report Row Sorting
    In API & Developers
    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 …
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Kyle Moore API & Developers
  • Re:apostrophe
    In API & Developers
    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 te…
    Answered - Pending Review
    50 1
    Answered - Pending Review 50 views 1 comment Most recent by Genevieve P. API & Developers
  • Has anyone mapped their Smartsheet files using the API?
    In API & Developers
    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 …
    Accepted
    45 3
    Accepted Answer 45 views 3 comments Most recent by BKing API & Developers
  • Using GetSheet method returns Unexpected character encountered while parsing value: <. Path '', line
    In API & Developers
    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](S…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Krissia B API & Developers
  • How to insert a value for Contact List Column from c# using api
    In API & Developers
    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
    Answered - Pending Review
    34 1
    Answered - Pending Review 34 views 1 comment Most recent by Genevieve P. API & Developers
  • Proofs access using API.
    In API & Developers
    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…
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Genevieve P. API & Developers
  • Python -- Add Image to Cell: file name/display name adopt file path
    In API & Developers
    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 …
    Answered - Pending Review
    33 1
    Answered - Pending Review 33 views 1 comment Most recent by Genevieve P. API & Developers
  • API - DELETE by rowid met with an unauthorized error
    In API & Developers
    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 (…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Genevieve P. API & Developers