Your workflow is unique 👨‍💻 -  tell us how you use Dropbox here.

Forum Discussion

janeR's avatar
janeR
Explorer | Level 3
8 years ago

create report of file type usage

I need to create a usage report of our whole company's dropbox instance.  For example, we need to know how much video files (in data size) are stored within the whole instance.  How do I go about fin...
API
Greg-DB's avatar
Greg-DB
Icon for Dropbox Community Moderator rankDropbox Community Moderator
8 years ago

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.

 

  • janeR's avatar
    janeR
    Explorer | Level 3
    8 years ago

    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. 

    • Greg-DB's avatar
      Greg-DB
      Icon for Dropbox Community Moderator rankDropbox Community Moderator
      8 years ago
      I haven't written something quite like this for a team that large. It may take a long time to run for that many users unfortunately, and I'm afraid I don't have a better solution to offer.

      Also, the Dropbox API does have a rate limiting system, but it's mainly meant to prevent abuse so I wouldn't expect it to be an issue for this.
      • janeR's avatar
        janeR
        Explorer | Level 3
        8 years ago

        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.  

About Dropbox API Support and Feedback

Node avatar for Dropbox API Support and Feedback
Get help with the Dropbox API from fellow developers and experts.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!