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 followed the steps outlined here: https://www.thebiccountant.com/2017/06/25/import-multiple-files-dropbox-folder-powerbi-excel-via-pow... and it would have worked out just fine if we only had one user, but others need to be able to update and refresh the table I'm trying to create. But I can't figure out how to create a shared app or find a way to allow my teammates full access to the tool I'm trying to build.
And yes, we are all on the same Dropbox Business team.