Add array tag into JSON string value using c#

Question

I got a JSON string value :

{"refKey":"1","recordType":"address","bureauType":"consumer","controlData":{"success":"true"},"candidateRecordScores":[{"bestScore":"7","inputRecordScores":"7"}]}

I want to change candidateRecordScores node inside inputRecordScores value as array format.

Below output format i need:

"inputRecordScores":[7]

Also candidateRecordScores child element value changed as string format to INT

Below Final output i need:

{"refKey":"1","recordType":"address","bureauType":"consumer","controlData":{"success":"true"},"candidateRecordScores":[{"bestScore":7,"inputRecordScores":[7]}]}

This is my code look like this:

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using System;

using System.IO;

using System.Net;


amespace CAAS_SoftCIR

{

    public class Class1

    {
        static void Main(string[] args)

        {
            string strJson = @"{

                                  'ExpressMatch': {

                                    'refKey': '1',

                                    'recordType': 'address',

                                    'bureauType': 'consumer',

                                    'controlData': {

                                      'success': 'true'

                                    },

                                    'candidateRecordScores': [

                                      {

                                        'bestScore': '7',

                                        'inputRecordScores': '7'

                                      }

                                    ]

                                  }

                                }";


            JObject rss = JObject.Parse(strJson);

            //var rssTitle = Convert.ToString(rss["ExpressMatch"]);

            var rssTitle = (object)rss["ExpressMatch"];

            var json = JsonConvert.SerializeObject((object)rss["ExpressMatch"] , Formatting.None);

            Console.WriteLine(jsonNew);

        }


    }

}

Please show your attempt. It seems like you haven't tried anything yet. — ProgrammingLlama
– ProgrammingLlama, Commented Dec 28, 2021 at 7:40
Please refer my code above This is my code look like this:@Llama — Ivin Raj
– Ivin Raj, Commented Dec 28, 2021 at 7:41
I've seen your code above, but aside from parsing the JSON to a JObject (a good first step), nothing seems to relate to the task you're posting about. What has stopped you from looping through the items in candidateRecordScores, taking the value of inputRecordScores and then replacing the property value with an array of that value? — ProgrammingLlama
– ProgrammingLlama, Commented Dec 28, 2021 at 7:42
Pseudocode: foreach (JObject childObj in rss["ExpressMatch"]["candidateRecordScores"]) { currentValue = childObj["inputRecordScores"]; int parsedValue = int.Parse(currentValue); childObj["inputRecordScores"] = new JArray() { parsedValue }; } — ProgrammingLlama
– ProgrammingLlama, Commented Dec 28, 2021 at 7:50
Hi @Llama, can you add your code to the answer as the concept had tested and it works well. Thanks. Demo — Yong Shun
– Yong Shun, Commented Dec 28, 2021 at 7:54

Dharman · Accepted Answer · 2021-12-28 08:03:44Z

4

try it in Main method

string strJson = @"{
    'ExpressMatch': {
    'refKey': '1',
    'recordType': 'address',
    'bureauType': 'consumer',
    'controlData': {
        'success': 'true'
    },
    'candidateRecordScores': [
        {
            'bestScore': '7',
            'inputRecordScores': '7'
        }
    ]
    }
}";


JObject rss = JsonConvert.DeserializeObject<JObject>(strJson);

foreach(JObject score in rss["ExpressMatch"]["candidateRecordScores"]) {
    score["inputRecordScores"] = new JArray((int)score["inputRecordScores"]);
}

var newJson = JsonConvert.SerializeObject(rss, Formatting.Indented);

Console.WriteLine(newJson);

edited Dec 28, 2021 at 8:03

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Dec 28, 2021 at 7:57

Henry Trần

1,42113 silver badges16 bronze badges

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

1 Comment

Ivin Raj Over a year ago

Thank you @Henry Tran. Some tag is added extra like EXpressMatch Parent Node

Collectives™ on Stack Overflow

Add array tag into JSON string value using c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related