Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Order of the Columns
Hi everyone, I didn't find this answered anywhere, but is it possible to change the order of the columns using the API/SDK? I have a large number of sheets that I want/need to keep separated but I would like to standardize them with a defined order of the columns. Is it possible to get an attribute like "column order" and…
How to change the owner of an APP we have developed?
Hi All, We currently experiencing an issue with an APP that we have developed in Smartsheet with a n Account in Smartsheet and does not exist in our IDP. Our company recently turned on SAML and now the APP is unable to authenticate because of this Account not existing. We have created a new account that is part of our IDP…
Identification of attachment's uploader after moving cells to another sheet?
Hi Everyone, I'm after some kind of identifier for a person uploading an attachment. I have no issues obtaining it on the original sheet using "Get Row" or "Get Attachment" API methods, but the data is lost when moving cells to another sheet. I could imagine it is simply not saved anywhere and replaced by…
WorkApp notifications problem - Notification from report with "Current User" filter
Hello, I just received this no helpful notification from a WorkApp. The user made a comment on a report that has the "Current User" filter on it. The comment is for an issue on a ticketing system. Notification received The key issues that make the notification not helpful are: Cause of problem In a WorkApp with a report…
Updating Column Dropdown List using an API or other alternatives
Hoping someone can assist. I am aware that a Data Shuttle can be created to achieve what I am looking for, but due to the expense of a Data Shuttle I am looking for alternative options. Can anyone provide me an example of something they built using the API option or something else that worked on updating a dropdown list…
Oracle CPQ to snowflake
I'm looking for some advice on how to extract data from Oracle CPQ to snowflake. I do not have any idea about how Oracle CPQ works and not sure on the data model how the system works. Is there any way we can extract Oracle CPQ transactional data into snowflake? I see rest API's can be used. But I want incremental data…
Cannot schedule a data refresh from SmartSheet datasource on Tableau Cloud
Hi, I am doing a task of getting data on SmartSheet and develop a dashboard on Tableau desktop, then publishing the dashboard to Tableau Cloud. I am getting troubles when using Web Data Connector and Tableau Bridge to try to schedule and automatically refresh source data from SmartSheet. It keeps showing error message that…
SmartSheet Attachments in Power BI
The out-of-the-box Power BI connector doesn't include attachments to sheets or rows. But we can use the SmartSheet API to pull all attachments. I have successfully tested in Power BI. However, there is a catch… SmartSheet uses AWS s3 as the file store The documents are stored as private The full URI returned by the api…
Power BI error message
This discussion was created from comments split from: Message Error in POWERBI 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error.
Which role of user can create a webhook
I community, I need to build an app that connect to smartsheet via webhook. My question is the smartsheet plan and user role required to create webhook

Popular Tags

Trending in API & Developers

URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…

API & Developers

Discussion List

Categories

Popular Tags