[SalesForce] JSON.deserializeUntyped returns “unrecognized token: ‘NULL'”, when JSON token has a null value

We're creating our JSON responses to my salesforce callouts in house, so I'm guessing the issue has to do with how we're representing NULL in the JSON response. Here's a snippet of the response SF gets:

{"recordCount":5559,"records":[{"LaunchCount":"1","Country":NULL,"AccountSalesforceID":"0018000000anaaK","YearStart":"2014"}

Note the NULL value for Country, which isn't a string because it isn't in quotes. That seemed to be the proper way to do it from what I've seen online, but attempting to map response using JSON.deserializeUntyped got me the 'unrecognized token' error. Replacing null with any string, including "null", fixes the error.

So is my issue with not correctly representing NULL in my JSON, or is this an issue with the salesforce deserialize method?

Best Answer

In JavaScript/JSON null is defined but NULL isn't. Try null. (Which is different from "null" or 'null' which are strings.)

I just checked and Apex's JSON.deserializeUntyped throws System.JSONException: Unrecognized token 'NULL' for NULL but works with null i.e. it is (not to surprisingly) consistent with JavaScript/JSON.

Related Solutions

[SalesForce] deserializing JSON returns a null object

I think you just need to use saJSONwrapper class when you deserialize instead of saJSON:

List<saJSON> saj=(List<saJSONwrapper >) JSON.deserialize(body,List<saJSONwrapper >.class);

because in your JSON you have list of saJSONwrapper not saJSON.

[SalesForce] HTTP/ JSON Response – Developer Console

You need to deserialize into the proper type. In this case, that's the top level class (WeatherLocation). I stripped out some irrelevant attributes from your payload and it came through clean. Here's the Execute Anonymous script I used to demonstrate:

public with sharing class WeatherLocation
{
    final Location location;
}
public class Location
{
    public final String country_iso3166, zip, magic, country;
    public final String wmo, state_name, latitude, state;
    public final String longitude, city, elevation, full;
}

String payload = '{"location":{"type":"INTLCITY","country":"SP","country_iso3166":"ES","country_name":"Spain","state":"SE","city":"Sevilla","tz_short":"CEST","tz_long":"Europe/Madrid","lat":"37.38000107","lon":"-5.98000002","zip":"00000","magic":"2","wmo":"WLEEC","l":"/q/zmw:00000.2.WLEEC","requesturl":"global/stations/WLEEC.html","wuiurl":"https://www.wunderground.com/global/stations/WLEEC.html"}}';
WeatherLocation instance = (WeatherLocation)JSON.deserialize(payload, WeatherLocation.class);
system.debug(instance);

Best Answer

Related Solutions

[SalesForce] deserializing JSON returns a null object

[SalesForce] HTTP/ JSON Response – Developer Console

Related Topic