We have different types of work items in Azure DevOps Boards. We need to export list of all fields in work items to excel or any similar format. Is there a way to use the APIs to pull a list of all fields in the system and whatever associated metadata is available? Can someone please help us on this task.

CodePudding user response：

You can use the Azure DevOps Office® Integration 2019 connector for Excel to extract data in volume. There is a limit for calling the API I think it might be 10,000 work items. you can get around this rate limit by dividing your query up when you run it with a criteria.

CodePudding user response：

You can use Rest Api to get all fields form process template:

Work Item Type Name you can get from URL while viewing your process template:

CodePudding user response：

If you have Visual Studio, you can run Developer Command Prompt and use witadmin command line.

witadmin listfields /collection:https://dev.azure.com/<org>

Witadmin syntax: https://docs.microsoft.com/en-us/azure/devops/reference/witadmin/manage-work-item-fields?view=azure-devops#syntax