Deserialising a JSON response

Question

I am trying to deserialize a JSON response.

public class CLiveExMarketPriceHistory{
public String lwin11;   //11227502005
public String lcurrency;    //GBP
public String priceFrom;    //2013-07-12
public cls_prices[] prices;
public class cls_prices {
    public String ldate;    //2013-07-12
    public Decimal marketPrice; //880
}
public static CLiveExMarketPriceHistory parse(String json){
    return (CLiveExMarketPriceHistory) System.JSON.deserialize(json, CLiveExMarketPriceHistory.class);
}

The JSON response is

{"lwin11":"11227502005","currency":"GBP","priceFrom":"2013-07-12","prices":[{"date":"2013-07-12","marketPrice":880.0},{"date":"2013-07-13","marketPrice":880.0},{"date":"2013-07-14","marketPrice":880.0},{"date":"2013-07-15","marketPrice":880.0},{"date":"2013-07-16","marketPrice":880.0},{"date":"2014-01-28","marketPrice":950.0}]}

The issue I am facing is that the JSON has attributes like date and currency which i am not able to use in my class as they are salesforce datatypes. I tried changing the class variables as lcurrency and ldate. But after deserialisation the values for these changed class variables are null as they don't match with the JSON response.

Any thoughts on how i can get values for the date and currency from JSON?

@Mike Chale can you confirm that json2apex can handle apex protected keywords ? I didn't know that. — Samuel De Rycke, Jan 28 '14 at 14:41
@MikeChale i did use json2apex, the issue is with the protected keywords. Not sure how we can handle it — Prady, Jan 28 '14 at 14:46
I was running through some of the previous posts and found this http://salesforce.stackexchange.com/questions/2276/how-do-you-deserialize-json-properties-that-are-reserved-words-in-apex?rq=1 . Probably Daniel's answer there is what we need to do. I am leaving this question open for some more time if somebody has a better answer or probably somebody can close it as a duplicate question — Prady, Jan 28 '14 at 14:51
Sorry, I missed that the problem is that a field is named date. — Mike Chale, Jan 28 '14 at 15:07

score 10 · Accepted Answer · answered Jan 28 '14 at 15:00

You have two choices: JSON.deserializeUntyped or JSON.createParser. The former returns an object that operates like a map; you can call the get function, passing in a string, to return a value. The latter returns a parser that generates token events that you can use to parse the object.

Map<String, Object> data = (Map<String, Object>)JSON.deserializeUntyped(json);
String lwin11 = (String)data.get('lwin11');
String theCurrency = (String)data.get('currency');
Date priceFrom = Date.valueOf((String)data.get('priceFrom'));
List<Map<String, Object>> prices = (List<Map<String, Object>>)data.get('prices');
for(Map<String, Object> price: prices) {
   ...
}

You may have to play with the precise syntax, but examples are in the documentation.

score 9 · Answer 2 · answered Jan 28 '14 at 14:59

9

You could use JSON.deserializeUntyped

Map<String, Object> m = (Map<String, Object>)
      JSON.deserializeUntyped(jsonInput);

String lcurrency = m.get('currency'));

answered Jan 28 '14 at 14:59

Martin Borthiry

6,961
7
50
89

score 0 · Answer 3 · answered Jan 28 '14 at 15:58

0

Another option, though it's not necessarily the best performance-wise, would be to "filter" the JSON response through a string-replace? I.e.

jsonInput = jsonInput.replace('"currency":', '"1currency":');

answered Jan 28 '14 at 15:58

Adam Michael Daw

539
2
10

Deserialising a JSON response

3 Answers3