API & Developers
Connect with other developers using the Smartsheet API.
Discussion List
-
404 Error - Event data - Smartsheet APIIn API & DevelopersHi, 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…
-
ScriptIncl:SmartsheetIntegrationHelper-FailedIn API & DevelopersWe 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…
-
Converting Cell Text to HyperlinkIn API & DevelopersHi. 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…
-
Timestamps only match selected date format when clicked onIn API & DevelopersHello, 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 …
-
Multi-picklist using a list of element "errorCode": 5536In API & DevelopersI'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…
-
Can a one to many relationship be created in Smartsheets?In API & DevelopersFor 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…
-
How to add Developer Tools to GOV account?In API & DevelopersHi, 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…
-
CDATA import into Smartsheet cause apostrophe problemIn API & DevelopersWe 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…
-
Get working hours and days from API for ProjectIn API & DevelopersHi, 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