API access token queries

gery.elrahweise
edited 12/09/19 in API & Developers

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:

  1. Assuming that only one person will create Sheets, how many Sheets will the application be able to access?  Is it limited to 100?
  2. 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.

Comments

  • Lee Joramo
    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
    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.