How to Generate List of All Smartsheet Objects I can Access?

Hello, I have records management policies and often need to get a list of all of the Workspaces, Sheets, Reports, and Dashboards I can at least view as an account member. I typically use the "Access.csv" report to do this, but it does not include a few useful things. I'm wondering if maybe there are workarounds I can employ to get these.

Access CSV includes:

Workspace Name
Name of object (name of sheet, etc)
Type (report, sheet, dashboard)
Owner
Shared To
Shared To Permission
Key (is this static? relative to the user?)
Last Modified Date

I also need:

Address (hyperlink)
ID (the one shown in "properties")
Workspace Address
Last Modified By
Created Date
Created By

Does anyone know if I can get an address from the Key? They value for Key here cannot be used to create the standard address, as far as I can tell.

Or, are there any tutorials or relevant discussions on how to get this detail into a recurring export or Smartsheet via Bridge?

Find more posts tagged with

Bridge

Importing and Exporting

Access Request

admin settings

Accepted answers

All comments

marc4

Do you have someplace you can run the API. A simple call:

curl --silent "https://api.smartsheet.com/2.0/sheets?includeAll=TRUE" -H "Authorization: Bearer $token"

returns data for all the sheets you have access to:

Screenshot 2023-05-09 at 6.57.18 PM.png

You can use the ID to get more details like the shares:

curl --silent "https://api.smartsheet.com/2.0/sheets/$Sheet_ID/shares?includeAll=TRUE&sharingInclude=WORKSPACE&accessApiLevel=1&include=workspaceShares" -H "Authorization: Bearer $token"

/marc

jnollet

Can never get these to work … Either get Invalid Auth or not authorized message

Tried many variations of replacing "Authorization: Bearer $token"

No luck…

kvangs

#python (via Smartsheet SDK)
#Get list of sheets from Smartsheets

import smartsheet, csv
import pandas as pd
import json

MyToken = "XXXXXXXXXXXX"

xSheet = smartsheet.Smartsheet(MyToken)

path = "C:/Users/XXXXXXXXXXX/"

xResult = xSheet.Sheets.list_sheets(include_all=True)

jsonFile = path + "jSheetList.txt"

with open(jsonFile, 'w') as f:
for item in xResult.data:
f.write("%s\n" % item)

jdata = [json.loads(line)
for line in open(jsonFile, 'r', encoding='utf-8')]

df = pd.DataFrame.from_dict(jdata)

df.to_csv(path + "SheetList.txt")

kvangs

The comment removed my indents above. You will have to fix that.

Alex Argumedo

Depending on the number of objects the previous examples will work on a short list, but if there is a long list of objects, you will get an error or a short list (limited by the page size, you will get only the first one), you can expand the page size but if you still cannot pull the whole list, then you need pagination.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.