Resource Not Found

[nhk-1992]

import os
import csv
import tempfile
from datetime import datetime
from tableauserverclient import Server, PersonalAccessTokenAuth
import json
import boto3

Function to read AWS credentials from a configuration file

def read_aws_credentials(config_file_path):
with open(config_file_path, 'r') as file:
config = json.load(file)
return config['aws_access_key_id'], config['aws_secret_access_key'], config['region']

Path to the configuration file

config_file_path = 'C:/Users/Downloads/prd.json'

Read AWS credentials from the configuration file

aws_access_key_id, aws_secret_access_key, region = read_aws_credentials(config_file_path)

Initialize Tableau Server client

server_url = 'https://tableau.com/'
token_name = 'TABPRD'
token_value = 'XXXXXXX'
auth = PersonalAccessTokenAuth(token_name, token_value)
server = Server(server_url, auth)

Initialize S3 client

s3_client = boto3.client('s3', region_name=region, aws_access_key_id=aws_access_key_id,
aws_secret_access_key=aws_secret_access_key)

with server.auth.sign_in(auth):
site_id = 'prod'
project_name = 'Management'
project_id = None

# Get all projects
all_projects, _ = server.projects.get()

# Iterate through the list of projects to find the one with the matching name
for project in all_projects:
    if project.name == project_name:
        project_id = project.id
        break

if project_id is None:
    print(f"Project '{project_name}' not found.")
else:
    print(f"Found project '{project_name}' with ID {project_id}")

    # Verify the workbook ID
    workbook_id = '9946-d6ca6dbd0a11'  # Workbook ID
    try:
        workbook = server.workbooks.get_by_id(workbook_id)
        if workbook is None:
            print(f"Workbook with ID {workbook_id} not found.")
        else:
            print(f"Found workbook '{workbook.name}'")

            # Try to get the view by name
            view_name = 'Balance - Desktop'
            view = next((v for v in workbook.views if v.name == view_name), None)

            if view is None:
                print(f"View '{view_name}' not found in workbook '{workbook.name}'.")
            else:
                print(f"Found view '{view_name}'")

                # Download the CSV
                server.views.populate_csv(view)
                current_date = datetime.now().strftime('%Y-%m-%d')

                # Use os.path.join to handle file paths properly
                download_dir = 'C:/Users/Downloads'
                csv_file_path = os.path.join(download_dir, f"BAL_{current_date}.csv")

                with open(csv_file_path, 'wb') as f:
                    f.write(b''.join(view.csv))
                print(f"CSV file saved to: {csv_file_path}")

                # Upload CSV file to S3
                bucket_name = 'prod'
                subfolder = 'TABLEAU/'

                s3_object_key = f"{subfolder}BAL_{current_date}.csv"
                try:
                    s3_client.upload_file(csv_file_path, bucket_name, s3_object_key)
                    print(f"CSV file uploaded to S3 bucket: {bucket_name}, key: {s3_object_key}")
                except Exception as e:
                    print(f"Error uploading file to S3: {e}")
    except Exception as e:
        print(f"Error retrieving workbook with ID {workbook_id}: {e}")

[nhk-1992]

Hi Team,

I'm encountering the following error when running the code: "Resource Not Found: Workbook '9946-d6ca6dbd0a11' could not be found." The code works fine on the Default site, but it isn't working on any newly created sites. Could someone please help me resolve this issue?

[jorwoods]

Looks to me like the issue is you’re hardcoding a workbook ID, and that ID probably doesn’t exist on other sites. It seems to me you’re looking for the same project, workbook, view combination on each site. I suggest you take a look at Filtering and Sorting - TSC docs.

[nhk-1992]

Looks to me like the issue is you’re hardcoding a workbook ID, and that ID probably doesn’t exist on other sites. It seems to me you’re looking for the same project, workbook, view combination on each site. I suggest you take a look at Filtering and Sorting - TSC docs.

I have extracted the LUID by using below code.

sign in to Tableau Server

try:
with server.auth.sign_in(tableau_auth):
# Get the list of all workbooks
all_workbooks, pagination_item = server.workbooks.get()

    # Print out the LUIDs of all workbooks
    for workbook in all_workbooks:
        print(f"Workbook Name: {workbook.name}, Workbook LUID: {workbook.id}")

except TSC.ServerResponseError as e:
print(f"Failed to sign in: {e}")
except TSC.NotSignedInError as e:
print(f"Not signed in: {e}")

The original code is working with the Default site and it's not only working with the newly created sites. I might miss a logic from the main code. can you be able to help me that?

[jorwoods]

1. How you’re defining all_workbooks is not actually ALL workbooks. It’s only one page of workbooks. Which by default is only 100 items. So if your site has more than 100 workbooks, you may be missing what you’re after.

2. Are you printing off their names and IDs so that you can later select them by ID?

[nhk-1992]

# Get a list of all sites and identify the correct site
all_sites, _ = server.sites.get()

# Replace 'new_site_name' with the name of your newly created site
site_name = 'PROD'
site_id = 'prod'
for site in all_sites:
    if site.name == site_name:
        site_id = site.id
        break

if site_id is None:
    print(f"Site '{site_name}' not found.")
else:
    print(f"Found site '{site_name}' with ID {site_id}")

    # Now, set the site context to the found site
    server.site = site_id  # Set the site context for subsequent requests

    project_name = 'Management'
    project_id = 19

    # Get all projects in the newly selected site
    all_projects, _ = server.projects.get()

    # Iterate through the list of projects to find the one with the matching name
    for project in all_projects:
        if project.name == project_name:
            project_id = project.id
            break

    if project_id is None:
        print(f"Project '{project_name}' not found.")
    else:
        print(f"Found project '{project_name}' with ID {project_id}")

        # Get all workbooks within the project
        workbooks, _ = server.workbooks.get()

        # List the LUIDs of all workbooks in the project
        print("Listing LUIDs of all workbooks in the project:")
        for workbook in workbooks:
            if workbook.project_id == project_id:
                print(f"Workbook Name: {workbook.name}, Workbook LUID: {workbook.id}")

                # Fetch the views for this workbook and list their LUIDs
                views, _ = server.views.get(workbook)
                for view in views:
                    print(f"  View Name: {view.name}, View LUID: {view.id}")

                # Optionally, if you are looking for a specific workbook or view, you can check here.
                # For example, if you want to match a specific view name:
                if any(view.name == 'Balance - Desktop' for view in views):
                    # You can perform further operations on the matching workbook/view here
                    print("Found the target view. Proceeding with CSV extraction...")

I have modified the code to list the Workbookd LUID's, even though it's not working for newly created site.

Found site 'PROD' with ID 7e514067-ab4b-4347-9b3c-5acf3be579eb
Found project 'Management' with ID fa016e84-9198-4500-a922-e6a640479c79
Listing LUIDs of all workbooks in the project:

Process finished with exit code 0

[jorwoods]

You’re still only getting one page of workbooks. Look at Page Through Results.

If you’re looking for workbooks in the “Management” project, why not query the API for workbooks with a project name of Management? Look at the Filtering and Sorting docs.

[jorwoods]

With this line workbooks, _ = server.workbooks.get() you’re discarding the PaginationItem. Have you looked at the page nation item? Have you seen how many total results that get returned by the site?

[nhk-1992]

You’re still only getting one page of workbooks. Look at Page Through Results.

If you’re looking for workbooks in the “Management” project, why not query the API for workbooks with a project name of Management? Look at the Filtering and Sorting docs.

I will go through it but I have mentioned the site_name is PROD but the Management LUID is capturing from the Default site.
because of this reason, its not giving the expected output
Do you have any idea, why its capturing from the Different site?

[jorwoods]

What I’m telling you to do is to query the site that has the workbook that you want, rather than relying on IDs from a different site. IDs are entirely unique and not consistent across sites. Or servers. If you happen to delete the workbook in republish, the workbook ID would also change.

[nhk-1992]

What I’m telling you to do is to query the site that has the workbook that you want, rather than relying on IDs from a different site. IDs are entirely unique and not consistent across sites. Or servers. If you happen to delete the workbook in republish, the workbook ID would also change.

i didnt hardcoded the workbookluid and trying to get the by viewname, still its reading the project_luid from different site(Default)

Function to get the site ID based on site name

def get_site_id_by_name(all_sites, site_name):
for site in all_sites:
if site.name == site_name:
return site.id
return None

Function to authenticate for a specific site

def authenticate_for_site(site_id):
# Create the server instance without passing auth initially
server = Server(server_url)
# Explicitly set the site context
server.site = site_id
# Now, authenticate for this site
server.auth.sign_in(auth)
return server

Main execution to handle the CSV download and upload to S3

def main():
# First sign in with the default site context
server = Server(server_url)
server.auth.sign_in(auth)

# Get all sites
all_sites, _ = server.sites.get()

# The newly created site name you want to work with
site_name = 'PROD'  # Replace with your actual site name
site_id = get_site_id_by_name(all_sites, site_name)

if site_id is None:
    print(f"Site '{site_name}' not found.")
    return

print(f"Found site '{site_name}' with ID {site_id}")

# Now authenticate explicitly to that site
server = authenticate_for_site(site_id)

# Get all projects in the newly selected site
all_projects, _ = server.projects.get()

project_name = 'Management'
project_id = 19

# Iterate through the list of projects to find the one with the matching name
for project in all_projects:
    if project.name == project_name:
        project_id = project.id
        break

if project_id is None:
    print(f"Project '{project_name}' not found in site '{site_name}'.")
    return

print(f"Found project '{project_name}' with ID {project_id} in site '{site_name}'.")

# Now, query for workbooks inside this project
workbooks, _ = server.workbooks.get()

print("Listing LUIDs of all workbooks in the project:")

workbook = None
for wb in workbooks:
    if wb.project_id == project_id:
        print(f"Workbook Name: {wb.name}, Workbook LUID: {wb.id}")

        # Fetch views associated with this workbook
        views, _ = server.views.get(wb)
        for view in views:
            print(f"  View Name: {view.name}, View LUID: {view.id}")

            # Check if the desired view exists
            if view.name == 'Balance - Desktop':
                workbook = wb
                target_view = view
                break

        if workbook:  # If we found the workbook and view
            break

if workbook is None:
    print(f"View 'Balance - Desktop' not found in project '{project_name}'")
    return

print(f"Found the target view '{target_view.name}'. Proceeding with CSV extraction...")

output:
Found site 'PROD' with ID 7e514067-ab4b-4347
Found project 'Management' with ID fa016e84-9198-4500 in site 'PROD'.
Listing LUIDs of all workbooks in the project:
View 'Balance - Desktop' not found in project 'Management'

Process finished with exit code 0

[jorwoods]

You may have identified the site, but you did not switch to it. You need to actually sign into the new site. You cannot read data across sites. They are entirely logically separated entities.

[nhk-1992]

You may have identified the site, but you did not switch to it. You need to actually sign into the new site. You cannot read data across sites. They are entirely logically separated entities.

with server.auth.sign_in(auth):
# Get a list of all sites and identify the correct site
all_sites, _ = server.sites.get()

# Replace 'new_site_name' with the name of your newly created site
site_name = 'PROD'
site_id = None
for site in all_sites:
    if site.name == site_name:
        site_id = site.id
        break

if site_id is None:
    print(f"Site '{site_name}' not found.")
else:
    print(f"Found site '{site_name}' with ID {site_id}")

    # Now, set the site context to the found site (this step is crucial)
    server.site = site_id  
    print(f"Successfully switched to site '{site_name}'.")

    project_name = 'Management'
    project_id = None  

    # Get all projects in the newly selected site
    all_projects, _ = server.projects.get()

    # Iterate through the list of projects to find the one with the matching name
    for project in all_projects:
        if project.name == project_name:
            project_id = project.id
            break

    if project_id is None:
        print(f"Project '{project_name}' not found.")
    else:
        print(f"Found project '{project_name}' with ID {project_id}")

        workbook_name = 'Balance - Desktop'  

        # Get all workbooks in the current site
        all_workbooks, _ = server.workbooks.get()

        # Find the workbook by name
        workbook = next((wb for wb in all_workbooks if wb.name == workbook_name), None)

        if workbook is None:
            print(f"Workbook '{workbook_name}' not found.")
        else:
            print(f"Found workbook '{workbook.name}' with ID {workbook.id}")

            # Try to get the view by name
            view_name = 'Balance - Desktop'
            view = next((v for v in workbook.views if v.name == view_name), None)

            if view is None:
                print(f"View '{view_name}' not found in workbook '{workbook.name}'.")
            else:
                print(f"Found view '{view_name}'")

I have modified the code but still the Project is capturing from the Default site.
If you can send me the portion of the code, that should be great

[jorwoods]

Assigning the site name on the server object does nothing. You need to actually call the switch_site method.

[nhk-1992]

Thanks, mate! I have finally achieved the solution I was looking for. Below are the changes I made to my original code:

Searching for the workbook by name instead of referencing the workbook LUID.
Using the switch_site function to switch to a newly created site in Tableau.
Once again, thanks for your support!

In addition to that, I have multiple sheets in the view. How can I extract the specific sheet information.

Function to switch to a different site on Tableau Server

def switch_site(server, site_item):
try:
# Switch to the new site
server.auth.switch_site(site_item)
print(f"Successfully switched to site '{site_item.name}'.")
except Exception as e:
print(f"Error switching to site '{site_item.name}': {e}")
raise

Start the main logic

try:
with server.auth.sign_in(auth):
# Get a list of all sites and identify the correct site
all_sites, _ = server.sites.get()

    # Replace 'PROD' with the actual site you want to switch to
    site_name = 'PROD'
    site_item = None
    for site in all_sites:
        if site.name == site_name:
            site_item = site
            break

    if site_item is None:
        print(f"Site '{site_name}' not found.")
    else:
        print(f"Found site '{site_name}' with ID {site_item.id}")

        # Switch to the site using the switch_site method
        switch_site(server, site_item)

        # List all available projects after switching
        all_projects, _ = server.projects.get()
        print(f"Available Projects in '{site_name}':")
        for project in all_projects:
            print(f"  - {project.name}")

        # Proceed with fetching the specific project and workbook
        project_name = 'Management'
        project_id = None  

        for project in all_projects:
            if project.name == project_name:
                project_id = project.id
                break

        if project_id is None:
            print(f"Project '{project_name}' not found.")
        else:
            print(f"Found project '{project_name}' with ID {project_id}")

            workbook_name = 'Balance - Desktop'

            # Get all workbooks in the current site
            all_workbooks, _ = server.workbooks.get()

            workbook = next((wb for wb in all_workbooks if wb.name == workbook_name), None)

            if workbook is None:
                print(f"Workbook '{workbook_name}' not found.")
            else:
                print(f"Found workbook '{workbook.name}' with ID {workbook.id}")

                # Populate the workbook to load its views
                server.workbooks.populate_views(workbook)  

                # Try to get the view by name
                view_name = 'Balance - Desktop'
                view = next((v for v in workbook.views if v.name == view_name), None)

                if view is None:
                    print(f"View '{view_name}' not found in workbook '{workbook.name}'.")
                else:
                    print(f"Found view '{view_name}'")

[jorwoods]

See #1132 for your last question. But it sounds like you may need to look into the VizQL Data Service.

I'd also advise again that your method for querying all_workbooks is not actually ALL. You're still only getting the first page, so you if you have more than 100 workbooks on your site, you're ending up sort of lucky that you're getting it on the first call.

Did you know that you can filter views and directly ask for a view by name, and by workbook name, and by project name? You can even pass all 3 at once so you ensure you're getting only that specific view you care about.