PointSync
An automation tool designed to reduce manual work-item tracking by connecting directly with the Azure DevOps REST API.
View on GitHub
Overview
PointSync was created to improve an existing manual process at Web Surfing Studios. Instead of reviewing completed Azure DevOps tickets and entering their information individually, the application retrieves completed work items and records their details automatically.
The Challenge
One of the biggest challenges was working directly with the Azure DevOps REST API and understanding how to interpret its JSON responses. I also had to account for differences between UTC timestamps and the program's Pacific Time reporting schedule.
The Approach
I built the application using ASP.NET Core MVC and Entity Framework Core. It uses WIQL queries to find qualifying work items, retrieves their details through the REST API, and maps the returned data into application records. A background service handles scheduled synchronization.
Key Features & Implementation
- Direct integration with the Azure DevOps REST API using HttpClient
- WIQL queries to filter completed work items by user and project
- JSON parsing and mapping into application data models
- Duplicate prevention during synchronization
- Scheduled background synchronization at 3:00 AM Pacific
- Manual work-item management through an ASP.NET Core MVC dashboard