API & Developers

Archives for August 2023

Tableau Embed in WorkApps Error
Hi, I did this a long time ago and put notes on how I did it in OneNote. I just tried to do it in another WorkApps the same way and it gives me an error. I am trying to embed a tableau dashboard into WorkApps. We do have online not public. I tried my original solution where I added &iframeSizedToWindow=true&:embed=y to the…
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…
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…
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…
Has anyone used Power Automate or another tool to insert and update records FROM Excel to Smartsheet
We have a file of data in Excel with Macros to another system with confidential data. We want to send rows and update rows to a Sheet in Smartsheet. Has anyone used Power Automate or another tool to do this?
I need to populate and accumulate data from smartsheets into a data ware house.
It seems like the history log would be the best place to pull this information, but I am not seeing a way to pull the history log via API. Pulling the info cell by cell seems cumbersome. Can someone point me in the right direction?
Power automate question (multi-contact list)
I'm using power automate to wire up some info into smartsheets. I have everything working so far but multi contact list and multi pick list. The contact list error I get is this: The value "John smith" could not be saved in column "Assignment". This column is restricted to MULTI_CONTACT_LIST values only. The name is…
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 =…
End of Line Characters and automated API Reports
Our IT is getting automated reports with our API Key from Smartsheet and has sent me the following email / question: The end of line character in the file is also a line feed (LF), instead of line feed + carriage return (CR) that is common. This causes confusion for the processing, as when processing the file, it is not…

Trending in API & Developers

Change Agent with Python SDK is not working
Hi, I'm using smartsheet-python-sdk version 3.0.2 with Python 3.11 and trying to set the Change Agent so I can use it to read when receiving the webhooks but although I pass the change_agent parameter this is not being applied. When i made the request using cURL it works fine. The below is how I set the change_agent:…
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
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…

API & Developers

Discussion List