Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
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.
Perfect, it's working !
Thanks !
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |