Delete old workitems #23
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Delete old workitems | |
| on: | |
| schedule: | |
| - cron: '0 0 1 * *' | |
| workflow_dispatch: | |
| permissions: | |
| contents: read | |
| jobs: | |
| Delete: | |
| name: Delete old workitems | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Setup Node | |
| uses: actions/setup-node@v3 | |
| with: | |
| node-version: '20.x' | |
| - name: Install azure-devops-node-api | |
| run: | | |
| npm install azure-devops-node-api | |
| - name: Delete old workitems | |
| uses: actions/github-script@v7 | |
| env: | |
| TOKEN: '${{ secrets.azure_devops_token }}' | |
| ORGANIZATION_URL: 'https://dev.azure.com/EladDeveleap' | |
| with: | |
| script: | | |
| const azureDevOpsApi = require('azure-devops-node-api'); | |
| /** | |
| * Deletes work items from Azure DevOps/TFS. | |
| * | |
| * @param {import('azure-devops-node-api/WorkItemTrackingApi').IWorkItemTrackingApi} workItemTrackingApi - The Work Item Tracking API. | |
| * @returns {Promise<void>} - A promise that resolves when the work items are deleted. | |
| */ | |
| async function deleteWorkItem(workItemTrackingApi) { | |
| const wiql = 'SELECT [System.Id] FROM WorkItems'; | |
| const result = await workItemTrackingApi.queryByWiql({ query: wiql }); | |
| if (result.workItems.length > 0) { | |
| const workItemsId = result.workItems.map(item => item.id); | |
| for (const workItemId of workItemsId) { | |
| await workItemTrackingApi.deleteWorkItem(workItemId, null, true); | |
| console.log(`Deleted workitem ${workItemId}`); | |
| } | |
| } | |
| else { | |
| console.log('No workitems found'); | |
| } | |
| } | |
| /** | |
| * Entry point of the script. | |
| * | |
| * @returns {Promise<void>} - A promise that resolves when the script finishes running. | |
| */ | |
| async function run() { | |
| const { TOKEN, ORGANIZATION_URL } = process.env; | |
| const authHandler = azureDevOpsApi.getPersonalAccessTokenHandler(TOKEN); | |
| const connection = new azureDevOpsApi.WebApi(ORGANIZATION_URL, authHandler); | |
| const workItemTrackingApi = await connection.getWorkItemTrackingApi(); | |
| await deleteWorkItem(workItemTrackingApi); | |
| } | |
| run(); |