API/Developers
Discussion List
-
400 5160 Error CodeIn API & DevelopersI've got a number of GET search sheet requests returning the following error code: REST Connector: The remote server returned an error: (400) Bad Request: { "errorCode" : 5160, "message" : "The characters *, ~, : …
-
Free Data Shuttle Webinar - March 16In Using SmartsheetHello! We will be hosting a free webinar on March 16th "Intro to Data Shuttle." Join us here to learn how to automatically and seamlessly upload, or offload, data between Smartsheet and other tools.
-
How to automatically remove "unmatched" datamesh results from the Target sheet?In Apps, Integrations, and Add OnsHi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically remov…Answered ✓ 194 views 3 comments 0 points Most recent by Samuel Mueller Apps, Integrations, and Add Ons
-
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…
-
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…
-
how to delete all the rows of a sheet using python at onceIn API & DevelopersI am trying to build an automation that updates an excel file to smartsheet once I run it. I have build that program but issue i am facing is that they are getting updated below the previous one. So I want to delete the rows first .Is ther…
-
Python API Library Started Throwing ErrorIn Apps, Integrations, and Add OnsHi all, I've been using the Python API to update a sheet on a nightly basis. It's been working fine until a couple days ago (not sure exactly when). Now when I call smartsheet.Sheets.delete_rows(sheet_id, list_of_row_ids), I get the follow…Answered - Pending Review 90 views 5 comments 0 points Most recent by Julio S. Apps, Integrations, and Add Ons
-
Fillable PDFIn API & DevelopersHas anyone tried to use the submit button on a fillable PDF form to send data into smartsheet? Doens't seem to difficult but could use some guidance.
-
Third Party API connectors (IPAAS) recomendationsIn API & DevelopersI'm having a hard time finding a reliable third-party integration service. I have a master sheet with a dropdown menu that is used to order a product from another department in my company. When "request" is selected in the drop…