CODEWITHSUNDEEP
apirestazure-devopstfs
Ankit
Ankit

Reputation: 41

How to create TFS/Azure DevOps Work Items query across TFS collections and Export the same to Wor/Excel/Outlook etc. using and API

We have a script which programmatically creates the Work Items, now we need to export all those work items to Excel/Word/Outlook/etc.

Key point is to have a query across TFS/ADO collections and finally export them to may be excel via an API if there is any sample to export the Work Items via API it will be great we just have to change the connection strings.

Thanks & Regards Ankit Khare

Upvotes: 0

Views: 557

Answers (1)

SauravDas-MT
SauravDas-MT

Reputation: 1444

Currently there is no direct support to export Work Item to excel via APIs. Based on this Work Items documentation which we have form Microsoft, we can see that REST APIs can provide JSON response for work items.

REST API response need to be parsed and excel conversion logic needs to be implemented to get your desired result.

But there is way to export Work Items data to csv without API, that is by using Export to CSV option in Queries. Check export list to csv for more information. You can specify the data types you need in the csv file via Column Option.

Upvotes: 0

Related Questions