Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
We recently switched over to using USM for license management. This broke our automated scripts that gave users a license. We have a number of non-member employees who we cannot automatically update via the API. I'm told there is no solution for this and we are left manually updating our free users to a licensed member. Please add an API call that allows us to upgrade or downgrade an existing user.
We need the API updated allow for us to manage the new user subscription model. Specifically, we need the new user types returned from your users endpoint (Member, Provisional Member, Viewer, Guest) along with the supported event counts over a period of time that one of our users took an action that qualified them for that user type so we can manage these outside of Smartsheet. This example below is from the user report, however the aggregated days need to shorter, starting at 30 days, in order to properly manage users in the new model.
Email
User domain
User Type
System Admin
Group Admin
Plan Asset Admin
Number of assets shared with user
Highest permission given on assets
Number of assets with Viewer permissions
Number of assets with Editor or Commentor permissions
Number of assets with Admin permissions
Last activity
Number of asset views (Last 30 days)
Number of asset views (Last 60 days)
Number of asset views (Last 90 days)
Number of asset views (Last 180 days)
Number of comments (Last 30 days)
Number of comments (Last 60 days)
Number of comments (Last 90 days)
Number of comments (Last 180 days)
Number of edits (Last 30 days)
Number of edits (Last 60 days)
Number of edits (Last 90 days)
Number of edits (Last 180 days)
Number of created assets (Last 30 days)
Number of created assets (Last 60 days)
Number of created assets (Last 90 days)
Number of created assets (Last 180 days)
Firmly agreed here, we were recently switched to USM (unfortunately) as well. The "update" has broken our automated processes as well and as a bonus, has given us more work.
Color me surprised that a company acquired by private equity starts providing worse service for more money.
The frustration is doubled because the error message points you to things that don't exist within current API documentation. "User subscription updates (upgrade/downgrade) cannot be performed through this method. Please use the bulk upgrade/downgrade API"
Contrary to prior history with Smartsheet, this new model feels like a half baked cash grab that wasn't properly planned or executed, which is more or less in line with what we expect from private equity. Hate to see it; we'll definitely be pushing to move away from Smartsheet ASAP.
Definitely need this functionality!
Agreed. This should have been in place before the switch to the new model
As of now there is no API for updating the license type so we need API/Bulk API call to update license type for users.
API functions are one of the determining factors of purchasing a system for an enterprise. Please fix the issue with the API and provide a way for monitoring systems can use the API for optimizations.
Here we are in August and the issue still persists. Want to make a simple PUT call like this?
{ "admin": false,"licensedSheetCreator": false,"groupAdmin": false,"resourceViewer": false} Nope! {"errorCode": 2109, "message": "User subscription updates (upgrade/downgrade) cannot be performed through this method. Please use the bulk upgrade/downgrade API", "refId": "*redacted*"} Enjoy being pointed to API documentation that still doesn't exist even eight months later! Here's the current documentation for the update user call that worked prior to the cash grab update: https://developers.smartsheet.com/api/smartsheet/openapi/users/update-user It still references the broken calls with no 'bulk upgrade/downgrade API' referenced anywhere that I can see.
At least the AI "helper" they've added confirmed that their documentation is incorrect:The documentation states that "User subscription updates (upgrade/downgrade) cannot be performed through this method. Please use the bulk upgrade/downgrade API." This indicates that while the admin and licensedSheetCreator fields are listed as updatable parameters for the PUT /users/{userId} endpoint, changes that constitute an "upgrade/downgrade" of a user's subscription (which these fields might imply) are not allowed via this specific API call.
admin
licensedSheetCreator
PUT /users/{userId}
The documentation suggests using a "bulk upgrade/downgrade API" for such operations, but details for this alternative API are not provided within the given documentation.Bravo, Smartsheet! Eight months later and still no movement or meaningful response from support.
UPDATE: If your goal is deactivation of an account, I've discovered that you no longer need to remove licenses beforehand — you can simply hit this endpoint with a POST call: https://api.smartsheet.com/2.0/users/{{SSAPIUserID}}/deactivate Thanks again for the needless update and useless support, Smartsheet!
Hi all, Here's a link to the announcement post around this feature:
API Documentation:
Cheers, Genevieve
Thank you for sharing this update. This update allows us to be informed of user seat changes, but it doesn't allow for full reporting on the type of user that exists in Smartsheet. Ideally the user type would be accurately reflected in the list users endpoint. Is that on the roadmap?
Sign in to comment or add your vote.
