-
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 =…
-
Tableau Smartsheet WDC -Unable To refresh smartsheet datasource in tableau server
I have a smartsheet sheet published as a datasource in tableau server. The initial connection to smartsheet from tableau desktop is made using WDC . the said WDC is enabled in the server with the refresh status also set as allowed. This is the result for "tsm tsm data-access web-data-connectors list" command Status:…
-
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…
-
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.
-
API sheet changes and Activity Log
Hi everyone, Hoping the great minds here can help solve a mystery. We recently implemented Control Center (first started using it on 5-Aug) and one of the manual tasks we've set up a workflow to notify our admins to complete each week is to update the Control Center generated link in our demand management sheet to show…
-
How to get attachments from each row from Smartsheet using Power automate using HTTP call
Hello- Could you please let me know how to get attachments from each row from Smartsheet using Power automate using HTTP call. Thank you
-
Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
-
How to add new rows to category in smartsheet via form?
Hello, i need a form through which new products will be added. How to put them in the right category? For example, a checkbox where they offer to choose a category, and which one you choose, the line goes to that one.
-
Global Update Workspace Logo and Colors
Hoping there will be a future ability to update all Smartsheet workspace logos and colors from an administrative perspective across the board. At the very least creating some type of API call to revert to Account Color Settings and Logo so someone doesn't have to manually click on every workspace (I personally have 232…
