Forum Discussion

JohnSwid's avatar
JohnSwid
New Member
9 years ago

Connecting to data source hosted on Dropbox

Hello PowerBI-Ites,   Has anyone had any luck connecting to Dropbox as a data source.  Couldn't find many articles on this topic.  Here's one  article that had a solution we couldn't get to work: h...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

JAkerblom, I really apreciate if you could test the list_folder command for me.

once I can connect to Dropbox using my token and view all files, I can handle them myself. but first I need to connect to the files and view them inside PBI query editor.

 

using web query or M language, I am having issue to make it work with my token and the supposed-to-be link below.

https://api.dropboxapi.com/2/files/list_folder

 

as I learned in Dropbox,

API v1 is: api-content.dropbox.com/1/etc

API v2 is: api.dropboxapi.com/2/etc

This is why I believe your code is using the old v1 API.

https://www.dropbox.com/developers/reference/migration-guide

JAkerblom's avatar
JAkerblom
Frequent Visitor
9 years ago

Follow these images below.

And second, you're not supposed to use that link as you implied. Use the one I mentioned, and use it the way I described and all will be alright.

https://api-content.dropbox.com/1/files/auto/<Path to file>?access_token=<token>

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    yes, I followed these steps correctly, but this link only works when a file name is provided.

    I created a new token for the new command list_folder.

     

    I don´t want to load a single file, I need to load the contents of a folder, and view all files inside the folder.

    I tried many times, many different codes. I got a lot of errors each test: 400, 404 and 405.

    And so far nothing is loaded.