-
Any requirements imposed for the DATE type columns?
Hello, Is there any recent update or modification in Smartsheet that imposes new requirements for the DATE type columns, even when restricted date-only is not selected? My script, which previously (till yesterday) ran successfully without converting date strings to ISO format, is now encountering an error code 5536,…
-
How do I get a report id from the permalink?
I have not been able to find a path forward in the api documentation, but ultimately I need the report ID after a user pastes their report permalink. How do I get a report ID from a report permalink?
-
Hello Guys!
I´m using Data Shuttle to offload data from a Sheet to a csv file. I´m having a constant error which is new : "Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns." I tried to go and edit the workflow to refresh the mapping but it didnt work. i didnt…
-
When setting up the API - it says to share the sheet with the Key what email address do you use?
I have my API key and I know what sheet I want to connect through the API. The instructions say to Share the Sheet: In the sharing settings, make sure that the Smartsheet API token (represented by an email address) has been added as a collaborator or viewer. Click on the "Share" button or the sharing icon, usually…
-
Download PDF from a row and get it with a watermark
Good afternoon everyone, I am currently working on developing a Smartsheet for document management for a client. The client requests that when downloading, sending, or previewing the attached documents in PDF format on each row of this Smartsheet, a watermark or text at the bottom of the page is added stating "Authorized…
-
API "Search" Endpoint: Offline?
Is the "search" API endpoint nonfunctional at present? All other endpoints seem to be functional on my end (sheets, folders, etc.). This has been tested with both the requests library in Python and in Power Query web requests in Power BI. PQ web requests returns a 500 internal server error. The Python web request returns…
-
Facing a NaN error code
Hi, I am working on adding rows to the smart sheet using JavaScript Node.js SDK, but I am facing this error, the error does not give me the error message and error code. This is the smart sheet error message Error Code: NaN - Cannot read properties of undefined (reading 'status') Ref ID: undefined (node:7328) Warning: a…
-
Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…
-
Creating a form that requires an attachment, and forwards that attachment (not a link)
Hello, I would like to create a form that requires an attachment. I would prefer that this require a PDF attachment if possible. Once the form has been submitted, I want it to automatically email the attachment as a PDF to the designated email address with info from the sheet in the body. I have a software that…
-
Smartsheet API for post method not working with Business Central
Hello all , I am unable to add a row from Business Central to Smartsheet via Smartsheet API - https://api.smartsheet.com/2.0/sheets/342476913069956/rows It gives me a Error as 400 : Bad Request . I tried my code to hit some other API than smartsheets which works fine. Please suggest :)