How to get the count of projects, repositories and teams created in Azure DevOps?

Question

How to get the list of projects, repositories and teams created in Azure DevOps. Also the administrators, contributors and pull request approver's list. I have seen the API mentioned in Azure docs but it provides the info in json format which has a lot of info and is really difficult to pull out the project and repository name. How can I get that data in excel or word document?

Answer 1

Best option looks like Rest APIs which returns json, but I am afraid there is no easy way to export them to excel or word.

For people who are searching what exactly are the Rest API endpoints to fetch them, here are the details;

How to get git repositories?

You can follow following steps to see the count of repositories

1. Login to Azure DevOps
2. Open one of following links by modifying your organization and project name

https://dev.azure.com/{ORGANIZATION_NAME}/{PROJECT_NAME}/_apis/git/repositories/ https://dev.azure.com/{ORGANIZATION_NAME}/{PROJECT_ID}/_apis/git/repositories/

3. Scroll to the end of the json response and you should see the count at the end of the page

How to get projects?

Follow step 1 and then open the link below

https://dev.azure.com/{ORGANIZATION_NAME}/_apis/projects

How to get teams?

Follow step 1 and then open the link below

https://dev.azure.com/{ORGANIZATION_NAME}/_apis/teams

How to find the project Id?

In Chrome, open the developer tools, open Azure DevOps and navigate to your project then you should see following calls which will give you the project id