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

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?