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 System.Net;

​

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/66931791/net-parser-json-from-a-open-api

​

    public static class JsonExtensions

    {

        public static T GetFromJson<T>(string url, JsonSerializerSettings settings = default)

        {

            var request = (HttpWebRequest)HttpWebRequest.Create(url);

            // User-Agent as suggested by this answer https://stackoverflow.com/a/6905471/3744182

            // by https://stackoverflow.com/users/873595/borg8

            // To https://stackoverflow.com/questions/3272067/webclient-403-forbidden

            request.UserAgent = "Other";

​

            using (var response = (HttpWebResponse)request.GetResponse())

            {

                if (response.StatusCode == HttpStatusCode.OK)

                {

                    using (var stream = response.GetResponseStream())

                    using (var textReader = new StreamReader(stream))

                    {

                        settings = settings ?? new JsonSerializerSettings { CheckAdditionalContent = true };

                        return (T)JsonSerializer.CreateDefault(settings).Deserialize(textReader, typeof(T));

                    }

                }

                else

                {

                    throw new ApplicationException(); // Throw some exception with a message of your choice

                }

            }

        }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var url = "https://api.upx.world/bigdata/query?neighborhood=210&neighborhood=359&neighborhood=367&neighborhood=366&neighborhood=356&neighborhood=364&city=0&status=All&mintMin=0&mintMax=100000000&saleMin=0&saleMax=100000000&skip=0&fsa=All&sort=mint_price&ascOrDesc=1"; 

​

            var dobj = JsonExtensions.GetFromJson<JToken>(url);

            var prices = dobj["data"]["properties"].Select(t => (decimal?)t["last_paid_price_upx"]).ToList(); // Or cast to (string) if you prefer

​

            //var prices = dobj["data"]["properties"].Select(t => t["last_paid_price_upx"]?.ToString()).ToList();

​

            Console.WriteLine(JsonConvert.SerializeObject(prices));

            //Console.WriteLine(dobj);

        }   

    }

​

    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.Location.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;

        }

    }

​