VBA Code to list dropbox folder ownership

Question

I have to transfer the files of several coworkers from Dropbox to Onedrive. Many of these folders are being shared among themseleves. So, the folders to be transferred from each person's account should be those folders owned by each person. This way, after transferring the files, each person will be able to re-share their folders. Is there anyway I can build a vba module in Excel to make a list of Dropbox folders that includes whos the owner?

Greg-DB · Accepted Answer

Yes, Dropbox offers an API you can use to programmatically list, upload, and download files, among other operations, such as checking sharing metadata.

For example to list any/all files and folders in an account:

* https://www.dropbox.com/developers/documentation/http/documentation#files-list_folder
* https://www.dropbox.com/developers/documentation/http/documentation#files-list_folder-continue

To download files:

* https://www.dropbox.com/developers/documentation/http/documentation#files-download

To list shared folders in an account:

* https://www.dropbox.com/developers/documentation/http/documentation#sharing-list_folders
* https://www.dropbox.com/developers/documentation/http/documentation#sharing-list_folders-continue

To list the members (including the owner) of a shared folder:

* https://www.dropbox.com/developers/documentation/http/documentation#sharing-list_folder_members
* https://www.dropbox.com/developers/documentation/http/documentation#sharing-list_folder_members-continue