Forum Discussion

sshweky's avatar
sshweky
Helper III
10 years ago
Solved

Data source hosted on Dropbox

Hi,   I am using Power Query in Excel and need to pull in some data via a query from an Access file on Dropbox. If I add the local version of the file, other users can't use the file b/c they dont ...
  • sshweky's avatar
    sshweky
    10 years ago

    Can you please look at my URL below and see if I did it correctly because it still says "authentication failed". What is the proper format of the filepath?

    ankitpatira wrote:

    sshweky URL should be as below and you choose anonymous method as you already have api token specified in URL

     

     

    https://api-content.dropbox.com/1/files/auto/{FILE PATH}?access_token={YOURAPITOKEN} 

     

     

     

sshweky's avatar
sshweky
Helper III
10 years ago

ankitpatira

 

Hi Ankit,

 

 

Thank you so much! However, I ran into 1 small roadblock. When I hit connect I get this box where I need to sign in.

 

Here is s screenshot of what I am seeing...

https://www.dropbox.com/s/3ssfx6c2hq5p5kr/Capture.PNG?dl=0

 

I tried to log in a bunch of different ways and it tells me 'user not authourized'. Any ideas?

 

Here is the final link tot he file with API Token & Path.

https://api-content.dropbox.com/1/files/auto/https://www.dropbox.com/s/vyt5wxklr9sh5ns/fc.mdb?dl=0?access_token=lNRU4j3IhxEAAAAAAAY_xJ1RC1SiSylWAhLbJRXlDhfv2Qds7ye4Qomt6Zt1NGE5

 

Thank you so much for your help!!!

 

 

Steven