JSON to C# Class Names with Spaces

Question

I am returning the following JSON Class from an API Request

"Top Uncommitted Spend": [
                {
                  "AccountID": 99999991,
                  "H1": "Liabilities",
                  "H2": "Top Uncommitted Spend",
                  "H3": "",
                  "SH1": "",
                  "Description": "FUEL (ATM,ATM FEE)",
                  "Count": 4,
                  "FrequencyDescription": "Mostly 17 Days",
                  "FrequencyDuration": "Ongoing",
                  "FrequencyDurationDate": "11Aug - 30Sep",
                  "FrequencyWeekday": "",
                  "FrequencyAmount": 116,
                  "FrequencyAmountRange": "(2-280)",
                  "TotalAmount": 464,
                  "TotalInAmount": 0,
                  "TotalOutAmount": 464,
                  "MonthlyAmount": 305.5481,
                  "GroupID": "128081-1241",
                  "Display": "FUEL",
                  "FrequencyExactness": "Mostly",
                  "FrequencyPeriod": "17 Days",
                  "ScoreEmployer": null,
                  "ScoreDirCr": null,
                  "ScoreWeekday": null,
                  "ScoreFrequency": null,
                  "ScoreAmount": null,
                  "ScoreTotal": 0
                },

When I use json2csharp to generate my class I get this because the tag has spaces in the name.

    public class Liabilities
{
    public List<Rent> Rent { get; set; }
    public List<Periodic> Periodic { get; set; }
    public List<NonPeriodic> __invalid_name__Non-Periodic { get; set; }
    public List<TopUncommittedSpend> __invalid_name__Top Uncommitted Spend { get; set; }
}

When I remove the "__invalid_name__" and the from the name. My parses but when run it throws an "Object reference not set to an instance of an object" error.

My question is how do I derseriaise this in order to get the data out without removing the spaces?

Well, it's obviously null because you've changed the property name and thus it's not being populated - I don't see how that's relevant to the question. Check the documentation of your serialization library to see how you can map a property to a different JSON property name. Likely involves adding attributes. — Rob
– Rob ♦, Commented Apr 24, 2017 at 5:43

Community · Accepted Answer · 2017-05-23 10:31:20Z

3

Try removing the spaces to get a valid c# class using json2csharp first.

Then use data annotation to get the model binder to recognise it.

Example:

public class Liabilities
{
    //removed other collections for simplicity
    [JsonProperty(PropertyName = "Top Uncommitted Spend")]  // <-- *add this*
    public List<TopUncommittedSpend> TopUncommittedSpend { get; set; }
}

public class TopUncommittedSpend
{
    public int AccountID { get; set; }
    public string H1 { get; set; }
    public string H2 { get; set; }
    //removed for simplicity
}

Now if you do a post to your api controller using the below:

{
    "Top Uncommitted Spend": [{
            "AccountID": 99999991,
            "H1": "Liabilities",
            "H2": "Top Uncommitted Spend"
        }
    ]
}

It should work.

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Apr 24, 2017 at 6:09

spinalfrontier

8771 gold badge15 silver badges22 bronze badges

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

1 Comment

Lucas Perrett Over a year ago

Awesome thanks. This was what I was struggling with.

Collectives™ on Stack Overflow

JSON to C# Class Names with Spaces

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related