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.

Python -- Add Image to Cell: file name/display name adopt file path
Hi, smartsheet_client.Cells.add_image_to_cell(sheet_id, row_id, col_id, r'/Users/me/pic_name', 'png') result image added to cell: _Users_me_picname.png I want it to just be picname.png How do I ensure the path is stripped in the resulting image name/image display name? Thanks
API - DELETE by rowid met with an unauthorized error
Hi there, I've developed logic/code that will delete records based on a date using the rowid. Unfortunately, the delete call does not work when executed from my bi server using Pentaho. I am able to successfully delete when using Postman (from the bi server) so I can prove my authentication and call are "correct." Any…
Gantt View data for sheet via api
I am trying to get data for a sheet which is repesented in the Gantt View. Since the ganttview already shows all the milestones and tasks that are under the milestones, getting that data would reduce our calculation by a huge chunk. any idea how can I do this via the api? The get sheets endpoint has include=ganttConfig but…
Pull data from Excel into a blank sheet
Hi everyone, I am trying to pull data from an Excel document into a blank canvas smartsheet. I have tried using power automate to do this however i cant see any triggers/actions that would give me the ability to do this. is this achievable through power automate. i have seen that alot of people use that application Zappier…
Card Order Data via API Response
I am trying to identify the order of cards in card view based on the JSON response to a GET request to the API for a sheet. I created a schedule type sheet as a test project. When I change the order of cards (by manually dragging them up and down in card view), there appears to not be any change to the response JSON that…
Giving access to Smartsheet outside my organization and blocking to only one IP address or website
Hi All, I am trying to integrate my smartsheet with an web based API. That web based PAI will submit a form with basic details and after submit new row will be added to my Smartsheet. We are configuring Smartsheet with security token in API. I want to make sure that Smartsheet will be restricted to that API IP address or…
Smartsheet Live Data Connector
Hi Guys Have some queries around the Smartsheet Live Data Connector and a possible integration with Qlik Sense. We have a combination of data coming from our data warehouse (lives in Qlik Sense) and manual trackers (lives in Smartsheet). Is the Live Data Connector an answer to integrating the manually tracked data with the…
3rd Party Apps
How can I let my application know who is accessing the application before it has an actual Smartsheet access token? If I understand correctly the first time the user uses the authorize link it generates the token and we can use that initially. The second time the user accesses the web app they are going through the direct…
We are integrating smartsheet with API. There is a requirement to submit a video in API
Hello team, We are integrating smartsheet with API. There is a requirement to submit a video in API and that video come to API as attachment. After submission of each API form with video we should see all videos in smartsheet. Thanks in advance Ravi Arora
Looking for Smartsheet API developer
Can someone help me figure out a good place to find someone who will help me with the Smartsheet API to be able to push and pull data into/from other systems? Thank you!

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