Product questions?
Sign in and 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.

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…
Dashboard - error pulling data
I have created a Dashboard. I am trying to pull the report data in as I have always done. I keep getting an error message. I re-created the reports and initially it will work. As soon as I hit "save" I start getting error messages. Help?
Create/Update/Delete APIs for Sight Widgets
I don't see any Create/Update/Delete APIs for Sight Widgets (Read is handled via getting a sight given it's id). In the docs, the sight update command can only be used to rename the site. I've tried to pass in the complete JSON for the sight along with it's updated widgets... but get a { "errorCode" : 1008, "message" :…

Trending in API & Developers

"Search Everything" API request always response with 'totalCount' limited to 100
Hello, Is there a limit to the total number of search results to 100? For the example, the GET request to URL: https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=stuff always response with "totalCount": 100 even though I know there are more than that. Is there a way to increase the search results beyond 100?…
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…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags