Parsing field name with a colon in JSON

Question

How can we parse if json fields contains a colon(:)? Like this:

{
  "dc:creator":"Jordan, Micheal",
  "element:publicationName":"Applied Ergonomics",
  "element:issn":"2839749823"
}

In fact I wonder how to do this with a library like restsharp, for mapping?

score 21 · Accepted Answer · answered Feb 28 '14 at 07:56

21

Using Json.Net

string json = @"{
            ""dc:creator"":""Jordan, Micheal"",
            ""element:publicationName"":""Applied Ergonomics"",
            ""element:issn"":""2839749823""
        }";

var pub = JsonConvert.DeserializeObject<Publication>(json);

public class Publication
{
    [JsonProperty("dc:creator")]
    public string creator { set; get; }
    [JsonProperty("element:publicationName")]
    public string publicationName { set; get; }
    [JsonProperty("element:issn")]
    public string issn { set; get; }
}

OR

Console.WriteLine(JObject.Parse(json)["dc:creator"]);

answered Feb 28 '14 at 07:56

L.B

114,136
19
178
224

1

+1 Really good answer, just one note: you violate naming conventions of .NET (i.e. properties should be PascalCased) – Leri Feb 28 '14 at 08:08
is there any annotation for mapping the class name? like we do for fields. – Serhat Koroglu Feb 28 '14 at 08:25
there's a field name with dash (-) how can I deserialize, not possible in csharp. – Serhat Koroglu Feb 28 '14 at 08:28
1

@SerhatKoroglu Do what you do for `:` – L.B Feb 28 '14 at 08:28
@L.B your solution is working great ..but when i fetching integer number from json string it returns ZERO please help – Dipesh Mar 01 '16 at 08:15

Leri · Answer 2 · 2014-02-28T08:03:58.180

If you use DataContractJsonSerializer, DataMemberAttribute has property Name which can be used to override default name. This means that when you deserialize json value of property dc:creator is assigned to Publication::Creator property and on the contrary when you serialize C# object.

For example:

public class Publication
{
    [DataMember(Name="dc:creator")]
    public string Creator { set; get; }
    [DataMember(Name="element:publicationName")]
    public string PublicationName { set; get; }
    [DataMember(Name="element:issn")]
    public string Issn { set; get; }
}

If you choose to use Json.Net, @L.B's answer is the way to go.

Parsing field name with a colon in JSON

2 Answers2

Linked

Related