XML to JSON using JSON.NET

Question

I have an XML that is not well formatted but needs to be consumed:

<Users>
<User First="aaa" Second="bbb">InnerValue</User>
<User First="bbb" Second="">InnerValue</User>
</Users>

Clases definitions:

public class Users
    {            
        public List<User> User{ get; set; }
    }

 public class User
    {        
        [JsonProperty("@First")]
        public string First{ get; set; }

        [JsonProperty("@Second")]
        public string Second{ get; set; }

        //how to define a property to get the InnerValue
    }

To parse:

XDocument xmlDocument = XDocument.Parse(xmlData);
string jsonData = JsonConvert.SerializeXNode(xmlDocument);
Users users = JsonConvert.DeserializeObject<Users>(jsonData);

So everything is nicely deserialized but how to get the inner value?

hmm ok got - but if not json i hope you know that this can also be useful var usersList = from s in xml.Descendants("Users") select s; - loop through each userItem - each userItem can give you value — Baljeetsingh Sucharia
– Baljeetsingh Sucharia, Commented Feb 15, 2013 at 16:41

Matija Grcic · Accepted Answer · 2013-02-15 16:33:46Z

1

To get the inner value you must use [JsonProperty("#text")] so to update:

public class User
    {        
        [JsonProperty("@First")]
        public string First{ get; set; }

        [JsonProperty("@Second")]
        public string Second{ get; set; }

        [JsonProperty("#text")]
        public string InnerValue { get; set; }
    }

answered Feb 15, 2013 at 16:33

Matija Grcic

13.5k8 gold badges65 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

XML to JSON using JSON.NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related