Query TFS/VSTS for past build history

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.TeamFoundation.Build.WebApi;
using Microsoft.VisualStudio.Services.Client;
using Microsoft.VisualStudio.Services.WebApi;`

namespace GetBuildHistory
{
    class Program
    {
        static void Main(string[] args)
        {
            MainAsync().Wait();
        }

        static async Task MainAsync()
        {
            var collectionUri = "http://tfs:8080/collection/";
            var teamProjectName = "{Your_Project_Name}";
            var targetBuildName = "{Your_BUILD_Name}";

            VssConnection connection = new VssConnection(new Uri(collectionUri), new VssClientCredentials());
            var buildserver = connection.GetClient<BuildHttpClient>();
            var builds = await buildserver.GetBuildsAsync(
                statusFilter: BuildStatus.Completed,
                project: teamProjectName);
            var targetedBuilds = builds
                .Where(definition => definition.Definition.Name.Contains(targetBuildName))
                .OrderBy(b => b.FinishTime)
                .ToList();

            ProcessBuilds(targetedBuilds);
        }

        private static void ProcessBuilds(List<Build> targetedBuilds)
        {
            var pathString = $@"C:\results\general_fullBuildResults.csv";
            var stringBuilder = new StringBuilder();
            stringBuilder.AppendLine("Name, Date, Passed, Build Time, Queue Time");
            foreach (var build in targetedBuilds)
            {
                var buildInfo = new BuildInfo
                {
                    Name = build.BuildNumber,
                    Passed = build.Result != null && build.Result.Value == BuildResult.Succeeded,
                    FinishTime = build.FinishTime.Value,
                    Started = build.StartTime.Value,
                    QueueStartTime = build.QueueTime.Value
                };

                stringBuilder.AppendLine(buildInfo.ToString());
            }

            File.WriteAllText(pathString, stringBuilder.ToString());
        }
    }

    internal class BuildInfo
    {
        public string Name { private get; set; }
        public bool Passed { private get; set; }
        public DateTime Started { private get; set; }
        public DateTime FinishTime { private get; set; }
        public DateTime QueueStartTime { private get; set; }

        private string InQueueTimeMinutes => this.CalculateTimeInQueue();

        /// <summary>
        /// The time the build took to run.
        /// </summary>
        public string TimeRanInMinutes => this.CalculateTimeRan();

        private string CalculateTimeRan()
        {
            var diff = this.FinishTime - this.Started;
            return (diff.TotalSeconds / 60).ToString(CultureInfo.CurrentCulture);
        }

        private string CalculateTimeInQueue()
        {
            var diff = this.Started - this.QueueStartTime;
            return (diff.TotalSeconds / 60).ToString(CultureInfo.CurrentCulture);
        }

        public override string ToString()
        {
            return $"{this.Name}, {this.Started.ToLocalTime():g}, {this.Passed}, {this.TimeRanInMinutes}, {this.InQueueTimeMinutes}";
        }
    }
}

 /// <summary>
    /// Get the timeline information from the REST API
    /// </summary>
    /// <remarks>
    /// reference of the REST API: https://www.visualstudio.com/en-us/docs/integrate/api/build/builds
    /// </remarks>
    /// <param name="buildId"></param>
    private static async Task<Timeline> GetTimelineAsync(int buildId)
    {
        Console.WriteLine($"Getting timeline for {buildId}....");
        return await buildServerClient.GetBuildTimelineAsync(teamProjectName, buildId);
    }

public string GetTimelineCsvRow()
{
    // Build Name, Date, Passed, Task Name, Time in Minutes, State, Result
    var sb = new StringBuilder();
    var orderedRecords = this.Timeline.Records
        .OrderBy(record => record.StartTime).ToList();

    orderedRecords.ForEach(record =>
    {
        try
        {

        sb.AppendLine($"{this.Name}, {record.StartTime.Value.ToLocalTime():g}, " +
                    $"{this.Passed}, {record.Name}, " +
                    $"{this.CalculateTimeRan(record.StartTime.Value, record.FinishTime.Value)}, ${record.State}, ${record.Result}, ${record.Url}");

        }
        catch (Exception e)
        {
            Console.WriteLine(e);
            sb.AppendLine("Exception");
        }
    });

    return sb.ToString();
}