I am trying to create a project monitoring system that multiple people can access and edit using an API in Dropbox. I've been able to create the app, but it's in my personal Dropbox folder and not somewhere that my team can access it. I tried sharing the folder with my team, but it will only let me share with a link, which does not seem to allow my teammates to make changes. Does anyone have any suggestions for dealing with this? Thanks!
Sorry, I'm pretty new to this, so I don't know how to describe the problem very well.
You've got it exactly right - the goal is for all users of the monitoring system to be able to access all information. I'll give a little more information: I have a number of project monitors, and I've split their projects into individual Excel tables that they update monthly. I want to link these individual tables into one big table using Excel's Power Query feature so that I can see all of my information in one place and use that for reporting purposes. When I tried to set up the system initially using Power Query, I ran into the problem of all data sources being linked to my hard drive, so others on my team couldn't refresh or update the queries, even though they can access the source data stored in Dropbox. The crowd-sourced solution to this problem was to create an API in Dropbox to get around the problem of source data being stored in my hard drive.
I am not familiar with Excel Power Query, but it may be possible to solve this without writing a custom integration. Have you tried sharing the content with your colleagues with a normal Dropbox shared folder? If the shared folder is configured to all editing, each user should be able to access the same shared set of excel files and be able to both read and write the same files.