Forum Discussion

masplin's avatar
masplin
Impactful Individual
8 years ago

Dropbox API v2, as API1 has been turned off

Hi   I have been linking severla single files stored on dropbox using API! whiuch seems to have bene disabled last night. I think there are a lot of us in the same boat.  Can someone say what the...
Need Help
masplin's avatar
masplin
Impactful Individual
8 years ago

Ok so I got a repsonse from the API explorer uses this token and path, and can download the file however i then put this code in Power Query and get an error "unable to conenct to the remote server"? Any idea?

 

let
    Source = Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download", [Headers=[Authorization="Bearer lkPfa4vOd-AAAAAAAAAAXpFuGV2UKJk0D3WGQtPjNeIeZNwdopvcaSs_y3gguRYY", #"Dropbox-API-Arg"="{""path"": ""/DataModel/SourceFiles/Inputs.xlsx""}"]]), null, true)
in
    Source
granthworth's avatar
granthworth
Kudo Kingpin
8 years ago

That, I am not sure about. 

 

I was able to finally get our entire system up and running again. I updated ONLY the first line of code in each query under the Advanced Editor (only the code highlighted in blue below) as shown below. I left all other code the same and all queries now return with no error.

 

 

 

  • masplin's avatar
    masplin
    Impactful Individual
    8 years ago

    Must have been an issue on my workcomputer as now works fine.

     

    Last question as you can see in my old API1 code I used 2 subset queries one ot hold the Token and one to hold the path. Made it easier if either changed. 

     

    I tried this code by doesn't seem to work unless you write both out in full

     

    let
    Source = Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download", [Headers=[Authorization="Bearer Token", #"Dropbox-API-Arg"="{""path"": ""DropboxSourcePath & Inputs.xlsx""}"]]), null, true)
in
    Source

    Where DropboxSourcePath is 

     

    let
    Source = "/DataModel/SourceFiles/"
in
    Source

     and Token is

     

    let
    Source = "lkPfa4vOd-AAAAAAAAAAKjmGh93HWPeYF-CY0LSTVss5JF53HOGK46xxk"
in
    Source

    Assume i have an error in my syntax?

     

    Mike

    • Dindo's avatar
      Dindo
      Frequent Visitor
      8 years ago

      If you're running with on premise gateway, how would you add this data source?

      In V1 it's easy since it reads as a web url source. Anyone has luck trying this out?

      • masplin's avatar
        masplin
        Impactful Individual
        8 years ago

        The code above works fine except you have to put the exact tokena nd path in the source line.  i managed to get it to read the table.

         

        I'm just hoping to be able to use some sub queries ot make it look neater and easier to manage