Path for API: path of the empty string

Hello,

I have been trying to get a complete overview of my Dropbox, Folders and File names. With some help, I was able to figure out a code. I am just getting started on coding.

However, I keep getting the same result, saying that the folder does not exist or cannot be accessed:

API error: ApiError('41e809ab87464c1d86f7baa83d5f82c4', ListFolderError('path', LookupError('not_found', None)))
Folder does not exist or could not be accessed.
Failed to retrieve files and folders.

this is the code;

import dropbox
import pandas as pd

# Replace 'YOUR_ACCESS_TOKEN' with your new access token
dbx = dropbox.Dropbox('TOKEN')

# Define a function to list files and folders
def list_files_and_folders(folder_path):
try:
response = dbx.files_list_folder(folder_path)
entries = response.entries
if entries:
file_names = []
folder_names = []
for entry in entries:
if isinstance(entry, dropbox.files.FolderMetadata):
folder_names.append(entry.name)
elif isinstance(entry, dropbox.files.FileMetadata):
file_names.append(entry.name)
return file_names, folder_names
else:
print("Folder is empty.")
return None, None
except dropbox.exceptions.ApiError as e:
print(f"API error: {e}")
print("Folder does not exist or could not be accessed.")
return None, None
except Exception as ex:
print(f"An unexpected error occurred: {ex}")
return None, None

# Specify the Dropbox folder path
folder_path = '/Vanessa Gillier/Rioblanco Capital LLC'

files, folders = list_files_and_folders(folder_path)

# Check if files and folders are retrieved successfully
if files is not None and folders is not None:
# Create a DataFrame
df = pd.DataFrame({'File Name': files, 'Folder Name': folders})

# Export to Excel
df.to_excel('dropbox_contents.xlsx', index=False)
print("Files and folders retrieved successfully.")
else:
print("Failed to retrieve files and folders.")

The permissions are all in order, when I use cd to go to the correct location, it finds it without a problem. Where could the problem lie?

I have removed the access token, but this is also to correct one copies straight from the location. I have also removed the location for privacy reasons, I hope you are still able to help me?

If there are other ways of doing this please inform me.

Thank you for your help.