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.

How to add sheet owner via api
My integration is creating new sheets in Smartsheet. When a new sheet is created, by default the logged in user becomes the owner. But I need to update the owner based on the other system's item owner. When I add the owner email to the SheetObject it throws an error: {"The attribute(s) sheet.owner are not allowed for this…
Smartsheet to Power BI Power Automate
@Genevieve P. I Hope you are well I haven't connected with you for a while and i was wondering if i ask for your assistance. I have limited knowledge regarding this topic. I currently have a Smartsheet File that is updated regularly using a Smartsheet app I have created for time tracking. what I am trying to do if there…
Smartsheet API response is incomplete.
I am using this API - https://api.smartsheet.com/2.0/sheets/{SHEETid}?rowsModifiedSince=2023-01-15T00:00:00.000 , this is not returning all the rows that are modified since the given time. From the UI , I can apply the same filter and get desired rows.
QuickBooks Desktop and Smartsheet - Possible API Integration?
I have a client that is switching from customized software for Construction Project Management to Smartsheet and is hoping to preserve his ability to have a back-and-forth (or one-way) integration with QuickBooks Desktop. The previous software was using Intuit's QuickBooks Web Connector to integrate the two applications,…
Add Group Members via API
Has anyone had success adding Group Members via API (not being a system admin but having Group Management permissions)?
Zapier Document Download
We have 95 sheets where we have integrated DocuSign so we have a lot of attachments coming in. I want to find a way to automatically download the signed documents to a Google drive. I set up Zapier but it downloads an empty text file. I contacted Zapier and they said "this is currently a bug with Smartsheet app…
Slack Integration: How can I systematically retrieve the row from the slack notification
I have row update notifications going to Slack as notifications in a workflow. I am also able to listen to that Slack channel from my application. How can my application find out which rowId is being referred to - can the URL be interpreted somehow? Thanks, James.
Is there a way to change a filename automatically?
Hi Everyone, I have been looking to change the filenames for uploads automatically using the Smartsheet cell. I am not sure if I would have to code this myself using the API or if there was an automatic way to do this within Smartsheets! Thanks!
Reports - How to open in a new window
Hello Community! I have a Form that contains a "Reference" link, to show a list of projects. This list is a Report, but users have the issue that this report sometimes opens in the same window and hence, they lose everything they already typed in the Form. My question is: is there any parameter that I can include in the…
How do I get all the rows in a Smartsheet by sending an API call using the requests package in pytho
I am trying to get just the rows (list of rows) in a smartsheet in a single API call by using the Python requests package instead of the smartsheet SDK. I tried to use /rows in my request like so: r = requests.get("https://api.smartsheet.com/2.0/sheets/{sheetID}/rows", headers=smartHeaders, params=payload) but…

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