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 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/56893389/extract-values-from-json-or-jarray-elements

​

    public class Sales

    {

        public string name { get; set; }

        public string requested_date { get; set; }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var stringCachedAddresses = GetJson();

​

            TestDeserialize(stringCachedAddresses);

​

            TestDistinct(stringCachedAddresses);

        }   

​

        public static void TestDeserialize(string stringCachedAddresses)

        {

            var parsedObject = JArray.Parse(stringCachedAddresses);

            // Your requested date

            var requested_date = "2019-06-28";

            // Construct a JSONPath query

            var pathTemplate = "[*].properties.*[?(@.requested_date == '{0}')]";

            var path = string.Format(pathTemplate, requested_date);

            // Query for and deserialize all sales from the specified requested date

            var query = parsedObject.SelectTokens(path)

                .Select(t => t.ToObject<Sales>());

​

            // Materialize the query as a list.

            var list = query.ToList();

            Console.WriteLine("\nResult of selecting all {0} objects using the path \"{1}\":", typeof(Sales), path);

            Console.WriteLine(JsonConvert.SerializeObject(list, Formatting.Indented));

            Assert.IsTrue(list.All(s => s.requested_date == requested_date));

        }

        public static void TestDistinct(string stringCachedAddresses)

        {

            var parsedObject = JArray.Parse(stringCachedAddresses);

            // Query for all values of requested_date, convert them to strings, and take all distinct values:

            var query = parsedObject.SelectTokens("[*].properties.*[*].requested_date")

                .Select(t => t.ToString()) 

                .Distinct();

            // Materialize the query as a list.

            var list = query.ToList();

            Console.WriteLine("\nAll distinct requested_date values:");

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

            Assert.IsTrue(list.Count == 2 && list.Contains("2019-06-28") && list.Contains( "2019-06-29"));

        }

        static string GetJson()

        {

            var json = @"[

    {

        ""type"": ""type1"",

        ""id"": ""id1"",

        ""properties"": 

        {

            ""sales"": 

            [

                {

                    ""name"": ""name1"",

                    ""requested_date"": ""2019-06-28""

                }

            ]

        }

    },

    {

        ""type"": ""type1"",

        ""id"": ""id2"",

        ""properties"": 

        {

            ""sales"": 

            [

                {

                    ""name"": ""name2"",

                    ""requested_date"": ""2019-06-28""

                }

            ]

        }

    },

    {

        ""type"": ""type1"",

        ""id"": ""id3"",

        ""properties"": 

        {

            ""sales"": 

            [

                {

                    ""name"": ""name3"",

                    ""requested_date"": ""2019-06-29""

                }

            ]

        }

    }

]

";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: " + Environment.Version);

            Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

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

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​