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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

masplin,

Do mask sensitive data before uploading scripts or screenshots.

In your scenario, add a new blank query in Power BI Desktop, then paste the following code into the Advanced Editor of your query.

let
    Source = Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download", [Headers=[Authorization="Bearer <your access token>", #"Dropbox-API-Arg"="{""path"": ""/folder/path/filename.xlsx""}"]]), null, true)
in
    Source



And I would commend you firstly test that if your API returns correct result in DropBox API Explorer.


Regards,
Lydia

  • 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