-
Use Smartsheet API to sync with external system
Hello I have a need to sync Smartsheet with an external system, the only way I can get the data out of the system is via a regularly updated report - however I have no way for the report to not include all data. Ideally the API would give me an option to specify the value of the primary column, and if there is an existing…
-
Using the API to get attachment URLs
I have PDF row attachments in a sheet. I need to get a direct URL to the attachment but I can't see a way to do this in the API. Using the GUI to "send" the file provides a link - so I'm trying to get something similar through the API. I'm aware that the the URL using the GUI method expires after 30 days. I would prefer…
-
Creating price tickets
Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…
-
Issue When importing an EXCEL file with API ? (switched indent !!)
Hi all, I have a question about what seems to be an issue in smartsheet API. I am surprised not to have found this bug in the forums because the Excel import in smartsheet must be very used? Here is the issue : When you import an Excel file containing indentation, with this script : https://smartsheet.redoc.ly/tag/import/…
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Sample cURL throwing errors
Hello All, I am looking to use cURL for some basic API updates to my sheets. I have used it successfully to pull down data for columns/summary sections, but when I try using the sample cURL to add a field (after updating the cURL for my sheetID and APIkey), it throws errors. Any idea why this might be happening. Wondering…
-
Spontaneous generation of new sheets
Smartsheet issue with spontaneous generation of new sheets. 1 - We created a self-test on our company websites. 2 - Once the test form is created it is directly integrated with Smartsheet. 3 - Once the integration is connected, we completed a sample submission, and the repository is generated. 4 - Once the repository is…
-
Persistent permalinks
I have an issue where my permalinks become useless after midnight. I create a bunch of permalinks to the rows in my main sheet. At midnight I move all these rows to an "Archive" sheet. Is there a way for the permalinks to reference the row that has been moved? Anyone else have this need? I had thought about renaming the…
-
Quotes within a formula for API PUT/POST
How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when I use the same syntax to add/update a column with a formula it doesn't parse correctly. I tried /" and double-quotes.…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
