API & Developers

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

How to get the response of a Smartsheet Sheet link(https://app.smartsheet.com/sheets/..)
Hello All, Need your help! Is there a workflow to get the response of a Smartsheet sheet link (URL:https://app.smartsheet.com/sheets/abcdxyz...) programmatically instead of with sheet_id (https://app.smartsheet.com/2.0/sheets/sheet_id). Thanks, Dev
Webhook callback authentication
My colleague and I are trying to create a webhook that triggers off new rows and sends data to Boomi for additional workflow/integration. How do we include our authentication for Boomi in the callback response from Smartsheet? Thanks Brian
get_report in Python API not returning all rows when no page / pagesize specified
I don't think I used to run into this issues but when using the Python SDK I'm getting an index out of range when looping though the report object returned by get_report when it is called without a page and pageSize: Example code: # Modules import sys import smartsheet import pprint #static details SourceReportID =…
How Do I get the smartsheet Live data connector in Tableau to accept my API token?
I have downloaded the proper drivers and I have the proper smartsheet and Tableau licenses but every time I try to use the API token for SSO, I am thrown an error. Any advice on how to fix this would be great.
Need solution to "The columnid xxxxxxx is invalid" when using Zapier New Row Update
Hi Community, I'm looking for a solution to a problem that's occurring when using Zapier to update cells in one smartsheet from cells in another smartsheet. When using the Zapier New Row Update action on a Smartsheet, it's throwing an error: "The app returned "The columnId xxxxxxxx is invalid". This is occurring when…
Extract sheetID from rows on report Smartsheet API
Is there a way to obtain the sheetID, for the Smartsheet API, for each row found on a report? I have a script to make modifications to sheets using the Smartsheet API. However, I had to locate the sheetID manually by accessing every single sheet and going to its properties. Is there a way to use the Smartsheet API to make…
What is the expiry time duration for refresh token?
I know that the expiry for access token is 7 days. Does refresh token expire and become invalid? If it expires, how does it help in refreshing the access token? Can someone explain how exactly the access token and the refresh tokens are updated after their expiry? Are there new values generated?
API Token - Can a Token be limited to a single sheet or workspace
I am looking to give an external developer the Smartsheet API so that I can get data to a specific sheet. I generated a new API ACCESS TOKEN and am concerned that this developer who I do not know (I am trying him out) will have access to all my sheets. Please tell me this is not true.
Smartsheet-Python SDK: Workspace
Hi everyone, I am having trouble retrieving workspace from Smartsheet using Python. I installed smartsheet-python SDK already and have the token and headers for authorization so no problem there (can access sheets etc). Here is the error: TypeError: get_workspace() missing 1 required positional argument: 'workspace_id'…
Hello Team
***********************Seeking Help**************************** I am quite new to python. I wanted to bring data from excel to Smartsheet using Python SDk. Can some one please help me to provide sample code. Basically replace smartsheet data from excel on daily basis.

Popular Tags

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
API - Limit User Access to one report
I'm new to using Smartsheet and currently have access to one report. I’d like to access this report via the API, and I’m reaching out to check if it’s possible to get the necessary API access. However, I’ve heard from someone that API access can’t be restricted to a single report. I’ve looked through the Smartsheet…
Is it possible to test code in a Sandbox, and not in the Smartsheet Production Environment?
I am VERY new to API's, Python, and Bridge. I'd like to test my scripts on our existing Smartsheet Data, but without the risk of breaking something in our Smartsheet Production environment. Besides me making mistakes, to run test scripts in our environment on production data, I need a change request and multiple meetings…

API & Developers

Discussion List

Categories

Popular Tags