API and Developers

 

Discussion List

  • Merged: Ability to share Data Shuttle Workflows between users.

    This discussion has been merged.

  • Script to get data from Google Sheet to Smartsheet

    I'm trying pull data from either s csv or google sheet. Can anyone explain to me what is wrong with my script below? No matter how hard I try I get the error: "Unable to parse request. The following error occurred: Field \"null\" was of unexpected type.", function copyDataFromGoogleSheetToSmartsheet() { var…

  • JAVA SDK - Update a Multi Picklist

    Hello, I am having trouble updating the value of a multi-picklist in my sheet. I am using the Java SDK smartsheet-sdk-java 3.1.1, on Java 17. I am setting the column value with the following code: Cell c = new Cell(column.getId()); c.setObjectValue(new MultiPicklistObjectValue(List.of("All", "Some", "None"))); My column I…

  • Importing Google Finance Data into Smartsheet?

    Hi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…

  • How to get page 2 of the reports list from the API /reports endpoint?

    Hello! Perhaps I'm being dense, but how do you get page 2 results from the API using this endpoint using CURL: https://api.smartsheet.com/2.0/reports I can see that there are 3 pages from the response to this endpoint: "pageNumber": 1, "pageSize": 100, "totalPages": 3, Thanks in advance.

  • Generating click.smartsheet email

    Hey guys, I am helping a client elevate their Smartsheet setup. Currently, they have an email automation that sends an email to a customer when a certain field in smartsheet has been updated. The email contains a URL starting with "click.smartsheet", the customer clicks on it and updates certain fields in smartsheet. I…

  • "Row Moved" not in Cell History when called by the API?

    "When I call "List Cell History" with the API the "Row was moved from another sheet" does not show up. Am I doing something wrong? Why can't I get this cell history?

  • R package for Smartsheet

    HI, Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet? I am considering a project using R and I might start building out a package. Thanks Craig info@ngsanalytics.com www.ngsanalytics.com

  • API export to excel to include the rowpermalink

    trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sheet. any help would be greatly apprecitated. $URL =…

  • Change Date column if new row is added after hours

    Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…