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

Hi Lydia

 

I'm obviously doing somethnig stupid.  the path to my file is U:\Dropbox\DataModel\SourceFiles\Input.xlsx

 

In API explorer I got this

 

 

Can you tell me where i've gone wrong please?

 

Thanks

Mike

granthworth's avatar
granthworth
Kudo Kingpin
8 years ago

Hey masplin

 

I am still working on getting ours resolved also. I have not gotten around the issue completely yet but I was able to get at least a portion of Lydia's fix to work. See below for my info. Hope this helps.

 

  • masplin's avatar
    masplin
    Impactful Individual
    8 years ago

    let an "s" of the file name Duh!!!!

     

    Brilliant

    • 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.