using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization.Formatters;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;    

​

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

​

//https://stackoverflow.com/questions/60620156/cant-read-multiple-values-from-json-file-with-c-sharp-function

​

    public class Metric

    {

        public string __name__ { get; set; }

        public string core { get; set; }

        public string instance { get; set; }

        public string job { get; set; }

    }

​

    public class Result

    {

        public Metric metric { get; set; }

        public IList<object> value { get; set; }

    }

​

    public class Data

    {

        public string resultType { get; set; }

        public IList<Result> result { get; set; }

    }

​

    public class CpuUsageResponse

    {

        public string status { get; set; }

        public Data data { get; set; }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var apiResponse = GetJson();

            CpuUsageResponse dataGetAll;

            // Download the apiResponse JSON string (code omitted)

            dataGetAll = JsonConvert.DeserializeObject<CpuUsageResponse>(apiResponse);

​

            double sum1 = 0;

            NumberFormatInfo provider = new NumberFormatInfo();

            provider.NumberGroupSeparator = ".";

​

            //Compilation error (line 63, col 43): foreach statement cannot operate on variables of type 'CpuUsageResponse' because 'CpuUsageResponse' does not contain a public instance definition for 'GetEnumerator'

            foreach(CpuUsageResponse x in dataGetAll)

            {

                sum1 += Convert.ToDouble(x.data.result[1].value[1], provider);

            }           

​

            Console.WriteLine(sum1);

        }   

        static string GetJson()

        {

            var json = @"{""status"":""success"",""data"":{""resultType"":""vector"",""result"":[{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,0"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""79186.65625""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,1"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""85518.546875""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,2"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""77787.5625""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,3"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""84295.765625""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,4"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""80077.3125""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,5"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""84062.078125""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,6"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""82094.75""]},{""metric"":{""__name__"":""wmi_cpu_time_total"",""core"":""0,7"",""instance"":""192.168.1.101:9182"",""job"":""Server-monitoring-Api""},""value"":[1583851813.666,""73822.078125""]}]}}";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());

            Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Assembly.GetName().Name,  typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

        public static string GetNetCoreVersion()

        {

            //https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be

            //

            var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;

            var assemblyPath = assembly.CodeBase.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);

            int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");

            if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)

                return assemblyPath[netCoreAppIndex + 1];

            return null;

        }

    }

​