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.

Can the Dynamic View form submission allow new entries to appear at the top of your Smartsheet?
I know this option is available in Smartsheet, but when you enter a form through dynamic view there is not an option to have new items to go to the top of the sheet.
Proofs access using API.
Using API, https://api.smartsheet.com/2.0/sheets/{sheetid}/proofs I get error "errorCode": 4000, "message": "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance.", "refId": "qtifuqjgvlkz" However, i can get list of attachments using…
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…

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
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!

API & Developers

Discussion List

Categories

Popular Tags