Remove property name from Json when its array

Question

I am converting XML to JSON.

Input:

<emp
    id="17377"/>
<CustomerList>
    <Customer
     id="67149"/>
    <Customer id="64260"/>
   </CustomerList>

OutPut:

"emp": {
      "id": "17377"
    },
"CustomerList": {
      "Customer": [
        {
          "id": "67149"
        },
        {
          "id": "64260"
        }
      ]
    }

But I need the below output. But I can not remove <Customer from <CustomerList> in the input. Also Please note that I need accept dynamic name of array input. But always i want to remove the inner property name to be removed. in this example its Customer.But I may get MarkList->Mark then I need to remove remove Mark, etc.,:

"emp": {
      "id": "17377"
    },
"CustomerList":  [
        {
          "id": "67149"
        },
        {
          "id": "64260"
        }
      ]

Is this possible please.

I use below code to convert XML to Json:

var xml = new XmlDocument();
xml.XmlResolver = null;
xml.LoadXml(richTextBox1.Text);
var jsonText = JsonConvert.SerializeXmlNode(xml,Newtonsoft.Json.Formatting.Indented);

Note:

One solution would be find the char "[" and remove before "[" and after "{".

Barr J · Accepted Answer · 2018-02-25 06:48:21Z

1

This is not possible, as it is simply trying to change to JSON scheme in which it was orignally built.

what you can do, is use JObject to change the value of customer to feet your needs:

JObject rss = JObject.Parse(json);
JObject customers = rss.SelectToken("CustomerList");
customers ["Customer"] = newValue;

This is the snippet, modify this in your code to feet your needs.

answered Feb 25, 2018 at 6:48

Barr J

11k2 gold badges31 silver badges49 bronze badges

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

4 Comments

Vetriramasamy Over a year ago

Thank you Barr. But the array name will be dynamic input. So I can not hard code like "CutomerList". The only hind is its array.

Barr J Over a year ago

then parse the object and give it the dynamic value of the inner array, this can be as dynamic as it gets :)

Vetriramasamy Over a year ago

@ Barr, CutomerList is just part of the whole json.

Barr J Over a year ago

The example still stands :)

Collectives™ on Stack Overflow

Remove property name from Json when its array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related