How to get access token in Smartsheet

haribabubhagam

I have a my service account with email id , using that I have to get access token from Smartsheet to do more calls

Is there any API for that ?

Sameer Karkhanis

Login to SS. Click on your account icon on the left bottom corner. Select Personal Settings from the menu. Select API Access from left nav menu. Generate the access token.

natebi

Hi I'm seeing a very limited number of sheet names when I use:

smartsheet_client = smartsheet.Smartsheet([usersecret])
response = smartsheet_client.Sheets.list_sheets()

Then loop through response.data[i].name and store the results in a list.

How do I get the list of all sheet names that I have access to using the usual smartsheet UI?

Genevieve P.

Hi @natebi

Two things to clarify here:

1. List Sheets will only return a list of sheets that your specific account/email has been shared to, the ones you can see in the UI (it sounds like you already identified this!)
2. The default page size with List Sheets is 100. If you only see 100 sheets being returned, check your page and page size

See: https://smartsheet.redoc.ly/tag/sheets#operation/list-sheets

Cheers,

Genevieve