create report of file type usage

To gather this information for a Dropbox Business team, you'd first need to register a Dropbox Business API app with the "team member file access" permission.

I don't believe we have an example that covers this particular use case, but you would get the full team member list using /2/team/members/list[/continue]. Then, using the "member file access" feature, for each member you can call /2/files/list_folder[/continue] to get information about all of the files in that members account. You can check the size for each file with an extension that you're interested in.

Thanks for the reply.  We have around 25K users and around TBs of data.  Have you run a query like on data this huge?  I am just thinking if there's a limit to the data that can be pulled at a certain time.  Or any other limitation that I should be aware of?  I am still learning the use of the dropbox APIs.  Thanks again. 

Can i use the search API?  I was trying Search but I dont think I can use advance search criteria there such as extension=<video extensions> createdDate=<certain date>.  Maybe I'm missing something as far as how the API can be used.  

You can use /2/files/search instead of /2/files/list_folder[/continue], but there aren't advanced search options, such as listing extensions and dates like this. You can search for specific file extensions by supplying the extension as the query, but you can only do one in a single search API call . Depending on the specifics of your team, e.g., the number of files they have, and how many extensions you're interested in, etc. this may or may not be better than just using /2/files/list_folder[/continue].