Derserialized JSON with NULL values to Output Buffer C#

Question

I am trying to return a JSON dataset that looks like the following. Let me caveat this by saying I am restricted to Visual Studio 2010 and .NET 4.0. how do I either output the NULL or convert to blank?

  "Application": {
  "AppID": 3119385,
  "ReportID": 4171130,
  "AppReference": "Doran 23-Nov-16 10:46:59AM",
  "CreateDT": "2016-11-23 10:48:38.5800000",
  "ClientName": "GoGetta Brisbane",
  "StoreName": "Brokers",
  "Email": "",
  "StoreCode": "GGT08",
  "AppShortReference": "02",
  "ClientNameShort": "GGT Bris",
  "StoreNameShort": "GGT08",
  "VerifyEmployer": null,
  "VerifyAmount": null,
  "VerifyFrequency": null,
  "VerifyWeekday": null,
  "LocalityCode": "en_AU",
  "TemplateReportID": 12,
  "daysRange": 90,
  "templateReportName": "Enhanced Income Liabilities Full Report",
  "isReportGraphEnabled": 1,

I am trying to process this into an output buffer of a script component in SSIS. However I keep getting a "cannot convert null to value type" error despite checking for it.

  if (String.IsNullOrEmpty(rptContentOutput.Applications.Application.VerifyEmployer) == true)
            {
                ApplicationDetailsBuffer.VerifyEmployer = "";
            }
            else
            {
                ApplicationDetailsBuffer.VerifyEmployer = rptContentOutput.Applications.Application.VerifyEmployer;
            }

My class has been defined as the following.

public class Application
{
    [JsonProperty("AppID")]
    public int? AppID { get; set; }
    [JsonProperty("ReportID")]
    public int? ReportID { get; set; }
    [JsonProperty("AppReference")]
    public string AppReference { get; set; }
    [JsonProperty("CreateDT")]
    public string CreateDT { get; set; }
    [JsonProperty("ClientName")]
    public string ClientName { get; set; }
    [JsonProperty("StoreName")]
    public string StoreName { get; set; }
    [JsonProperty("Email")]
    public string Email { get; set; }
    [JsonProperty("StoreCode")]
    public string StoreCode { get; set; }
    [JsonProperty("AppShortReference")]
    public string AppShortReference { get; set; }
    [JsonProperty("ClientNameShort")]
    public string ClientNameShort { get; set; }
    [JsonProperty("StoreNameShort")]
    public string StoreNameShort { get; set; }
    [JsonProperty("VerifyEmployer")]
    public string VerifyEmployer { get; set; }
    [JsonProperty("VerifyAmount")]
    public double VerifyAmount { get; set; }
    [JsonProperty("VerifyFrequency")]
    public string VerifyFrequency { get; set; }
    [JsonProperty("VerifyWeekday")]
    public string VerifyWeekday { get; set; }
    [JsonProperty("LocalityCode")]
    public string LocalityCode { get; set; }
    [JsonProperty("TemplateReportID")]
    public int? TemplateReportID { get; set; }
    [JsonProperty("daysRange")]
    public int? daysRange { get; set; }
    [JsonProperty("templateReportName")]
    public string templateReportName { get; set; }
    [JsonProperty("isReportGraphEnabled")]
    public string isReportGraphEnabled { get; set; }

}

You don't specify what is VerifyFrequency - are those classes or structs? — LB2
– LB2, Commented May 31, 2017 at 0:10
@LB2 what do you mean. I am not outputting that as yet because I could get the first value out. — Lucas Perrett
– Lucas Perrett, Commented May 31, 2017 at 0:12
Perhaps I misunderstood the question: are you trying to serialize into JSON, or deserialize from JSON? — LB2
– LB2, Commented May 31, 2017 at 0:15
What is the type for ApplicationDetailsBuffer.VerifyEmployer. Please show the code — CodingYoshi
– CodingYoshi, Commented May 31, 2017 at 0:18

LB2 · Accepted Answer · 2017-05-31 00:26:25Z

1

Ok, I misread the code with prior comments, but I see it now.

The issue is:

public double VerifyAmount { get; set; }

which is a value type, and the JSON contains:

"VerifyAmount": null,

which causes the error. The fix is:

public double? VerifyAmount { get; set; }

answered May 31, 2017 at 0:26

LB2

4,86023 silver badges37 bronze badges

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

1 Comment

Lucas Perrett Over a year ago

THANK YOU!!!! I have been looking at this for hours but clearly focusing on the wrong end of the equation. I though because I was not outputting it, that it wasn't being used.

Collectives™ on Stack Overflow

Derserialized JSON with NULL values to Output Buffer 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