Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MathLacome
Regular Visitor

Excel sheet hoosted in Dropbox - not in racine

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.

 

 

 

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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]

 

a2.PNGa3.PNGa4.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

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]

 

a2.PNGa3.PNGa4.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Perfect, it's working !

 

Thanks !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.