API & Developers

Connect with other developers using the Smartsheet API.

Discussion List

  • 404 Error - Event data - Smartsheet API
    In API & Developers
    Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the u…
    Accepted
    40 3
    Answered ✓ 40 views 3 comments Most recent by Andrée Starå
  • ScriptIncl:SmartsheetIntegrationHelper-Failed
    In API & Developers
    We are using ServiceNow to Smartsheet Integration and for one record is throw out an error and error code is : " ScriptIncl:SmartsheetIntegrationHelper-Failed to insert issue table record to the smartsheet sheet " What could b…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Genevieve P.
  • Converting Cell Text to Hyperlink
    In API & Developers
    Hi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) + "-" + RIGHT([Su…
    898 7
    898 views 7 comments Most recent by AJW
  • Timestamps only match selected date format when clicked on
    In API & Developers
    Hello, I am sending data to a Smartsheet via the API. I have been following the requirements for dates to be in isoformat 8601 per the documentation without any issue for over a year. Recently however, the dates are coming in as their raw …
    Accepted
    20 1
    Answered ✓ 20 views 1 comment Most recent by Kurt Maurer
  • 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
    100 2
    Answered ✓ 100 views 2 comments Most recent by jackamino
  • Can a one to many relationship be created in Smartsheets?
    In API & Developers
    For example I have sheet A that has my master list and all components within a "Kit".  On sheet B I have multiple kits and would like to reference all the included components.  I get that you can link cell to another just like an…
    581 3
    581 views 3 comments Most recent by Pam Parrish
  • How to add Developer Tools to GOV account?
    In API & Developers
    Hi, I want to add Develope Tools to a GOV account so I can than Create New App which will help me in generating a ClientID and ClientSecret. I need those to give users a log in page. I am able to create developers account for non gov acco…
    Answered - Pending Review
    36 3
    Answered - Pending Review 36 views 3 comments Most recent by Andrée Starå
  • CDATA import into Smartsheet cause apostrophe problem
    In API & Developers
    We are using an external tool from CDATA to import data into Smartsheet from MS SSIS. We have recently run into an issue where the data load inserts an apostrophe in front of the string value we are loading. We've checked the outbound flow…
    Answered - Pending Review
    95 2
    Answered - Pending Review 95 views 2 comments Most recent by Marvin
  • Get working hours and days from API for Project
    In API & Developers
    Hi, How could I retrieve "working hours" and "working days" using API for Project files? In Smartsheet it can be found in Project Settings (see picture below). Didn't find this info in documentation. Thanks
    Accepted
    40 3
    Answered ✓ 40 views 3 comments Most recent by Genevieve P.