[SalesForce] JSON.deserialize Array of Objects

I'm trying use the Box 2.0 API which returns everything in JSON. This is great because I can use JSON.deserialize. I've run into one issue when getting the folder and file structure. Box returns it as an array of objects that can contain both files and folders. I'd like to have different Apex classes that represent files and folders, but can't figure out if it is possible to deserialize the JSON into these two different classes. The other option I have is to create a single class that is a superset of all fields. Here's a snippet of the JSON.

{"item_collection": {
    "total_count": 2,
    "entries": [
        {
            "type": "folder",
            "id": "344470651",
            "sequence_id": "0",
            "etag": "0",
            "name": "Signed and returned by you"
        },
        {
            "type": "file",
            "id": "2778062467",
            "sequence_id": "0",
            "etag": "0",
            "sha1": "92da54134a52f3e264ab9ed346b3be95c9b2cdad",
            "name": "Welcome.pdf"
        }
    ]
}

Am I stuck doing the superset class or is there a way to get them split into separate classes?

Best Answer

Using the http://json2apex.herokuapp.com app developed by metadady and superfell was able to parse your JSON into apex class

//
// Generated by JSON2Apex http://json2apex.herokuapp.com/
//

public class JSON2Apex {

    public Item_collection item_collection;

    public class Item_collection {
        public Integer total_count;
        public List<Entries> entries;
    }

    public class Entries {
        public String type;
        public String id;
        public String sequence_id;
        public String etag;
        public String name;
        public String sha1;
    }


    public static JSON2Apex parse(String json) {
        return (JSON2Apex) System.JSON.deserialize(json, JSON2Apex.class);
    }

    static testMethod void testParse() {
        String json = '{\"item_collection\": {'+
        '    \"total_count\": 2,'+
        '    \"entries\": ['+
        '        {'+
        '            \"type\": \"folder\",'+
        '            \"id\": \"344470651\",'+
        '            \"sequence_id\": \"0\",'+
        '            \"etag\": \"0\",'+
        '            \"name\": \"Signed and returned by you\"'+
        '        },'+
        '        {'+
        '            \"type\": \"file\",'+
        '            \"id\": \"2778062467\",'+
        '            \"sequence_id\": \"0\",'+
        '            \"etag\": \"0\",'+
        '            \"sha1\": \"92da54134a52f3e264ab9ed346b3be95c9b2cdad\",'+
        '            \"name\": \"Welcome.pdf\"'+
        '        }'+
        '    ]'+
        '}'+
        '}';
        JSON2Apex obj = parse(json);
        System.assert(obj != null);
    }
}

Please try and it does magic .Thanks to metadady and Superfell and whoever built this app on herouku platform

Once we have the List of Entries(List entries)you can separated by using the Type in an another list .

Related Solutions

[SalesForce] What are the different capabilities between the @RemoteAction serializer and JSON.serialize

I've experienced a couple gotchas and differences:

DateTimes de/serialize as quoted strings:

String christmasLunch = '2013-12-25T12:30:59.500Z'; //looks reasonable, runs ok too
Json.deserialize(christmas, DateTime.class); //2013-01-01 00:00:00 - no month! no day!

String independenceDay = '"2014-07-04T09:00:00.00Z"'; //carefully note double quotes
Json.deserialize(independenceDay, DateTime.class); //2014-07-04 09:00:00 - better

The serializer used by REST services can return nested result sets, for example:

//SELECT Id, Name (SELECT Id, Name FROM Contacts) FROM Account
[{
    "Id": "001000000000000AAA",
    "Name": "Test Account",
    "Contacts": [{
        "Id: "003000000000000AAA"
        "Name": "Test Contact"
    }
}]

For a time, the @RemoteAction serializer did not. (Until v28.0 - this is now documented).

Whacky types may be serializable, but rightly throw a System.JSONException on deserialize:
- Type Type unsupported in JSON: common.apex.runtime.bytecode.BytecodeSObjectType
- DescribeSObjectResult No suitable constructor found for type

@RemoteAction methods can serialize, but not deserialize ENUM values

//apex:
public enum SEASON {WINTER, SPRING, SUMMER, AUTUMN}
@RemoteAction static public void parseSeason(SEASON which) {}

//javascript:
RemoteController.parseSeason('WINTER', function() {})
//Exception: Unable to convert parameter to Apex type: expected SEASON, got String

SObject DateTime must be transmitted Long unix timestamp format:

//apex:
@RemoteAction static public void parseUser(User me) {}

//javascript:
RemoteController.parseUser({CreatedDate: 1234567890000}, function() {})
//this works fine

but Apex DateTime must be transmitted in a different UTC String format:

//apex
@RemoteAction static public void parseDateTime(DateTime now) {}

//javascript:
RemoteController.parseDateTime(1234567890000, function() {})
//Exception: Unable to convert date '1234567890000' to Apex type Datetime.

watch out for crazy getter/setter action. Like SoapClient class mappings in PHP, they're not called!

[SalesForce] Deserialize JSON Array With Integer Index

You are going to laugh at this, but it turns out that REENCODING as JSON at each step gets you your quoted values. Strange but true!! Try this:

String jsonData = '{"data": {"1500":{"id":"1500","last_name":"Test1"},"298":{"id":"298","last_name":"Test2"}},"status_code":200}';

//get top level map
Map<String,Object> jsonMap = (Map<String, Object>)JSON.deserializeUntyped(jsonData);

//extract data as JSON
String jsonSubset = JSON.serialize(jsonMap.get('data'));

//re-encode as a Map
Map<String,Object> jsonSubsetMap = (Map<String, Object>)JSON.deserializeUntyped(jsonSubset);

MyContact[] contacts = new MyContact[]{};
for (Object obj : jsonSubsetMap.values()){
    //re-encode as json, again!
    String jsonObj = JSON.serialize(obj);
    //deserialize that b@#$ard!!
    MyContact contact = (EBTestDeleteMe.MyContact)JSON.deserialize(jsonObj, MyContact.class);
    contacts.add(contact);
}

System.debug(contacts);

This outputs:

DEBUG|(MyContact:[id=298, last_name=Test2], MyContact:[id=1500, last_name=Test1])

This assumes you have a class called MyContact that looks like this:

public class MyContact {
    public String id;
    public String last_name;
}

Best Answer

Related Solutions

[SalesForce] What are the different capabilities between the @RemoteAction serializer and JSON.serialize

[SalesForce] Deserialize JSON Array With Integer Index

Related Topic