using System;

using System.Linq;

using System.Net.Http;

using System.Text.Json;

using CsvHelper.Configuration;

using CsvHelper;

using System.IO;

using System.Globalization;

using System.Collections.Generic;

public class Program

{

    public static async void Main()

    {

        // This is the private static http client you already have

        HttpClient _client = new HttpClient();

        // build a json string out of our 'body' object

        string jsonString = JsonSerializer.Serialize(new { reportType = "SOME_REPORT_TYPE", dataStartTime = "", dataEndTime = "", marketplaceIds = new [] { "SOMEID" }});

        // create an HTTP message object, set it to POST, set our url, add our content, add our headers...

        var message = MakeRequestMessage(HttpMethod.Post, "http://", "TokenHERE");

        message.Content = new StringContent(jsonString);

        // creates the report

        var createReportResponse = await _client.SendAsync(message);    

        string createReportResponseString = await createReportResponse.Content.ReadAsStringAsync();

        CreateReportResponse createReportResponseObj = JsonSerializer.Deserialize<CreateReportResponse>(createReportResponseString);

        // Get newly created report obj

        var reportResponse = await _client.SendAsync(MakeRequestMessage(HttpMethod.Get, $"https://[putfirstpartofurlhere]/reports/2021-06-30/reports/{createReportResponseObj.reportId}", "TOKEN HERE"));

        string reportResponseString = await reportResponse.Content.ReadAsStringAsync();     

        GetReportResponse reportResponseObj = JsonSerializer.Deserialize<GetReportResponse>(reportResponseString);

        // Go get Document Response

        var documentResponse = await _client.SendAsync(MakeRequestMessage(HttpMethod.Get, $"[putfirstpartofurlhere]/reports/2021-06-30/documents/{reportResponseObj.reportDocumentId}", "TOKEN HERE"));

        string documentResponseString = await documentResponse.Content.ReadAsStringAsync();

        ReportDocumentResponse documentResponseObj = JsonSerializer.Deserialize<ReportDocumentResponse>(documentResponseString);

        // This shouldnt need a header I dont think,,,

        var actualDocResponse = await _client.GetAsync(documentResponseObj.url);

        string actualDocResponseContent = await actualDocResponse.Content.ReadAsStringAsync();

        // THIS IS NEW

        List<ReportRow> reportRows = new List<ReportRow>();

        CsvConfiguration config = new(CultureInfo.InvariantCulture);

        config.Delimiter = "\t";

        using (var reader = new StringReader(actualDocResponseContent))

        using (var csv = new CsvReader(reader, config))

        {

            csv.Context.RegisterClassMap<ReportRowMap>();

            reportRows = csv.GetRecords<ReportRow>().ToList();

        }       

    }

    public static HttpRequestMessage MakeRequestMessage(HttpMethod httpMethod, string url, string accessToken)

    {

        var message = new HttpRequestMessage(httpMethod, url);

        message.Headers.Add("x-amz-access-token", accessToken);

        message.Headers.Add("x-amz-date", DateTime.Now.ToUniversalTime().ToString("o"));

        return message;

    }

    internal record CreateReportResponse(string reportId);

    internal record GetReportResponse(

        string reportId,

        string reportType,

        string[] marketplaceIds,

        string dataStartTime,

        string dataEndTime,

        string reportScheduleId,

        string createdTime,

        string processingStatus,

        string processingStartTime,

        string processingEndTime,

        string reportDocumentId);

    internal record ReportDocumentResponse(

        string reportDocumentId,

        string url,

        string compressionAlgorithm);

    public class ReportRow

    {

        public string Date { get; set; }

        public string FnSku { get; set; }

        public string Asin { get; set; }

        public string MSku { get; set; }

        public string Title { get; set; }

        public string EventType { get; set; }

        public string RefernceId { get; set; }

        public string Quantity { get; set; }

        public string FulfillmentCenter { get; set; }

        public string Disposition { get; set; }

        public string Reason { get; set; }

        public string Country { get; set; }

        public string ReconciledQuantity { get; set; }

        public string UnreconciledQuantity { get; set; }

        public string DateAndTime { get; set; }

    }

​

    public sealed class ReportRowMap : ClassMap<ReportRow>

    {

        public ReportRowMap()

        {

            Map(m => m.Date).Name("Date");

            Map(m => m.FnSku).Name("FNSKU");

            Map(m => m.Asin).Name("ASIN");

            Map(m => m.MSku).Name("MSKU");

            Map(m => m.Title).Name("Title");

            Map(m => m.EventType).Name("Event Type");

            Map(m => m.RefernceId).Name("Reference ID");

            Map(m => m.Quantity).Name("Quantity");

            Map(m => m.FulfillmentCenter).Name("Fulfillment Center");

            Map(m => m.Disposition).Name("Disposition");

            Map(m => m.Reason).Name("Reason");

            Map(m => m.Country).Name("Country");

            Map(m => m.ReconciledQuantity).Name("Reconciled Quantity");

            Map(m => m.UnreconciledQuantity).Name("Unreconciled Quantity");

            Map(m => m.DateAndTime).Name("Date And Time");

        }

    }

}