Convert JSON structure to Array in C#

Question

I need to convert this -

{"Header":{ "Number" : 101, "Total" : 100.00},
"Items" : [
{"Line" : 1, "Description": "Item 1", "Price" : 25.00, "Quantity" : 2},
{"Line" : 2, "Description": "Item 2", "Price" : 50.00, "Quantity" : 1}
]}

to this -

[
{"HeaderNumber" : 101, "Total" : 100.00, "Line" : 1, "Description": "Item 1", "Price" : 25.00, "Quantity" : 2},
{"HeaderNumber" : 101, "Total" : 100.00, "Line" : 2, "Description": "Item 2", "Price" : 50.00, "Quantity" : 1}
]
enter code here

Any high level ideas on how I can achieve this? Thanks in advance.

Please tell us what you have tried and in what language solution would be? — Vaibhav Mule
– Vaibhav Mule, Commented Sep 21, 2017 at 5:29
I want to try this out in C#. I'm not getting a starting point to achieve this. Any first hand ideas? — priyeshwagh777
– priyeshwagh777, Commented Sep 21, 2017 at 5:30

Muhammad Hannan · Accepted Answer · 2017-09-21 06:17:07Z

1

Create a JSON Model class for that you can use JSONToCSharp. Once you get your JSON result store like this

JsonModel[] result = JsonConvert.DeserializeObject<JsonModel[]>(postResult);

It will convert your result into an Array of Model class. Then you can iterate over it using foreach loop.

foreach (var item in result)
{
     item.PropertyName;
}

answered Sep 21, 2017 at 6:17

Muhammad Hannan

2,60921 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

priyeshwagh777 Over a year ago

Sorry, I wasn't clear initially. Can I achieve this using XML structure?

Dan Nguyen · Accepted Answer · 2017-09-21 06:17:56Z

Try this :)

public class Header
    {
        public int Number { get; set; }
        public double Total { get; set; }
    }

    public class Item
    {
        public int Line { get; set; }
        public string Description { get; set; }
        public double Price { get; set; }
        public int Quantity { get; set; }
    }

    public class Source
    {
        public Header Header { get; set; }
        public List<Item> Items { get; set; }
    }

    public class Target
    {
        public int HeaderNumber { get; set; }
        public double Total { get; set; }
        public int Line { get; set; }
        public string Description { get; set; }
        public double Price { get; set; }
        public int Quantity { get; set; }
    }
    class Program
    {
        static void Main(string[] args)
        {
            var src = @"{""Header"":{ ""Number"" : 101, ""Total"" : 100.00},
""Items"" : [
{""Line"" : 1, ""Description"": ""Item 1"", ""Price"" : 25.00, ""Quantity"" : 2},
{""Line"" : 2, ""Description"": ""Item 2"", ""Price"" : 50.00, ""Quantity"" : 1}
]}";

            var srcObj = JsonConvert.DeserializeObject<Source>(src);

            var targetObj = srcObj.Items.Select(s => new Target()
            {
                HeaderNumber = srcObj.Header.Number,
                Total = srcObj.Header.Total,
                Description = s.Description,
                Line = s.Line,
                Price = s.Price,
                Quantity = s.Quantity
            });
            Console.WriteLine(JsonConvert.SerializeObject(targetObj));
            Console.ReadLine();

        }
    }

Sorry, I wasn't clear initially. Can I achieve this using XML structure?

Collectives™ on Stack Overflow

Convert JSON structure to Array in C#

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related