Excel sheet hoosted in Dropbox - not in racine

[MathLacome]

Hi Everyone, 

I'm trying to import an excel sheet located in Dropbox.

I have read the message and create an API allowing full access to my Dropbox.

When I connect my "Web based" Query to my excel sheet via : 

https://api-content.dropbox.com/1/files/[FILE PATH]?access_token=[ACCESS TOKEN]

Is ok when my file is located in the racine folder.

The problem is that all my files are located in sub folders. So I tried this but it is not working...

https://api-content.dropbox.com/1/files/[MySubFolder1]/[MySubFolder2]/[FILE PATH]?access_token=[ACCESS TOKEN]

Is there a solution to my problem ?

All the best,

Mathieu.

[v-qiuyu-msft · Accepted solution]

Hi @MathLacome,

Based on my test, we can specify the URL in web data source like below to get the file from the subfolder:

https://api-content.dropbox.com/1/files/auto/[subfolder1]/[subfolder2]/[file]?access_token=[ACCESS TOKEN]

Best Regards,
Qiuyun Yu

[Anonymous]

hi @v-qiuyu-msft.

this answer is using API v1, and it is no more supported by dropbox.

https://blogs.dropbox.com/developers/2016/06/api-v1-deprecated/

using API v2, could you please help list/view all files inside a folder?

using web query, I am having issue to make it work with my token and the link below.

https://api.dropboxapi.com/2/files/list_folder

[MathLacome]

Perfect, it's working !

Thanks !