API access token queries

Hello,

We currently access SmartSheet Sheets using the latest version of the SmartSheet SDK.

In our use-case, the plan is that only one person will create Sheets. It is this person that will have created the access token.

There is only one application using this access token. This application is configured with the same (and only 1) access token.

We now have a concern that if we have multiple licenses (currently we have 3), that we will not be able to access all Sheets.

We have the following questions:

Assuming that only one person will create Sheets, how many Sheets will the application be able to access? Is it limited to 100?
If multiple people create sheets, do we need to use multiple accesstokens to access all of these sheets, or are people somehow linked to a single “entity” (Maybe an organisation)?

Thank you.

Find more posts tagged with

API and Developers

IT & Operations

Comments

Lee Joramo

Your API can act as any user in your account by invoking "Assume User".

https://smartsheet-platform.github.io/api-docs/#assume-user

So it is possible to have only one account with API access.

dave-inden

The number of sheets that can be created by Licensed Users is determined by your plan. But, one user could create all of those sheets using their license. The plan has a larger pool of available sheets that anyone with a license can create.

For a user to have access to a sheet they need to be the owner of the sheet or be shared access to it. There isn't a method for one account to be automatically shared to all sheets.

As noted above, using the Assume-User header a System Admin account on a multi-user plan can assume the role of any user on the plan and act as them via the API. Using this you could list all of the sheets across the plan by assuming each user and working as them as you need.

Sign in to join the conversation!

Quick Links

Trending discussions

Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Smartsheet API Bug: Copy Sheet with include=forms Fails (Regression)
Hello Support Team, We are experiencing an issue with the Smartsheet Copy Sheet API when attempting to include forms. Endpoint: POST https://api.smartsheet.com/2.0/sheets/1097094865571716/copy?include=forms Request Body: { "destinationType": "folder", "destinationId": 608151415351172, "newName": "new_sheet_included_Forms"…
Issue with Searching a sheet with more than 10k rows
Hello, I am using the Smartsheet Search rows module in make : I am querying a sheet with 18k rows If i search for data in the first 10k rows it find is. if its after that, it doesnt find it. please help Kind Regards, Wesley.