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.

I see you're including your user name in the "folder_path" value, but note that the root for API calls defaults to your member folder automatically, so you shouldn't include the name of the member folder. Try taking out that path component.

Also, when calling 'files_list_folder', you can supply a 'path' of the empty string '' to list the root for the call. That's generally a helpful first step for debugging issues like this.

This is my new code after removing my username. but the problem remains. 

The second part of you answer also confuses me a bit, although I believe I did it.

I am very new to all of this, so dumming it down might be useful.

I see you've removed the first component with your name, but it looks like you've also changed the rest of it now.

Specifically, the path from your original post but without the user name component would be:

folder_path = '/Rioblanco Capital LLC'

but now you have:

folder_path = '/Rioblanco Dropbox'

Make sure you're using the right path values based on the current contents of your account.

Also, my other comment means that you can try the following to see the contents of whatever the root folder for the call is:

folder_path = ''

If you look at the 'result' from that, it will contain metadata about the items there that you can use to build other path values as needed.

The new error message i get is the following;

C:\Users\Vanessa RioBlanco\Dropbox (Personal)\PC\Desktop\LEX 2024\Path Shortening\Python> python import_dropbox2.py
An unexpected error occurred: BadInputError('beaa26a4df804ca984f4c5c31a9382e0', 'Error in call to API function "files/list_folder": This API function operates on a single Dropbox account, but the OAuth 2 access token you provided is for an entire Dropbox Business team. Since your API app key has team member file access permissions, you can operate on a team member\'s Dropbox by providing the "Dropbox-API-Select-User" HTTP header or "select_user" URL parameter to specify the exact user <https://www.dropbox.com/developers/documentation/http/teams>.')
Failed to retrieve files and folders.

Could this be related to the fact I added all permission options? I did this because I kept finding on the internet it could be related to permissions. 

Which ones would I need. 

The dropbox is indeed a shared dropbox. 

Based on that error message, you're now using an access token with "team scopes" enabled. For the sake of simplicity and security, and so you can use the code as you've written it, I recommend getting a new access token without the team scopes enabled again. You can change the scopes and then generate a new token using the app's page on the App Console.

You already have been such a help thank you.

The next problem is this;

File "C:\Users\Vanessa RioBlanco\Dropbox (Personal)\PC\Desktop\LEX 2024\Path Shortening\Python\import_dropbox2.py", line 42, in <module>
df = pd.DataFrame({'File Name': files, 'Folder Name': folders})
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vanessa RioBlanco\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\core\frame.py", line 778, in __init__
mgr = dict_to_mgr(data, index, columns, dtype=dtype, copy=copy, typ=manager)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vanessa RioBlanco\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\core\internals\construction.py", line 503, in dict_to_mgr
return arrays_to_mgr(arrays, columns, index, dtype=dtype, typ=typ, consolidate=copy)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vanessa RioBlanco\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\core\internals\construction.py", line 114, in arrays_to_mgr
index = _extract_index(arrays)
^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vanessa RioBlanco\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\core\internals\construction.py", line 677, in _extract_index
raise ValueError("All arrays must be of the same length")
ValueError: All arrays must be of the same length

I believe I figured that out. Is this an error you can help with.

Failed to retrieve files and folders or their lengths are different.