How to print projects and workbook names based on site id in tableau server client

Question

SIGN IN

    tableau_auth = TSC.TableauAuth(args.username, password, args.site)

    server = TSC. Server(args.server, use_server_version=True)

    with server.auth.sign_in(tableau_auth):

        print("Your server contains the following sites:")

        for site in TSC.Pager(server.sites.get):

            print(site.name)

        i=input("Enter the site name :")

        print(i)

    for project in TSC.Pager(server.sites.projects.get):

        print(project.name)

In the Tableau server client I am able to print the site ID. Based on the site ID, I need to print a project and workbook. In the above code the user gets the list of siteIDs that belong to his role. The user selects the site ID and I have stored an object "i" based on the site name. How can I drill down to a project and workbook?

Answer 1

Here's how I do it once I've got my site id.

auth = TSC.TableauAuth('username', 'password', site_id=i)
server = TSC.Server(serverAddress) 
with server.auth.sign_in(auth):
    all_project_items, pagination_item = server.projects.get()
    for proj in all_project_items:
        print(proj.id)

    all_workbooks, pagination_item = server.workbooks.get()
    for workbook in all_workbooks:
        print(workbook.name)