[SalesForce] Salesforce JSON Error : |FATAL_ERROR|System.JSONException: Illegal value for primitive

I am trying to run this code, I am getting this error in Apex Salesforce Console

*|FATAL_ERROR|System.JSONException: Illegal value for primitive*

public class content {
        public String MTType;
        public String MTTitle;
        public List<String> body;
    }
    // JSON string that contains a content object.
    String JSONContent =
        '{"content":{'+
          '"MTType":"text/html",'+
          '"MTTitle":"Test Builder",'+
          '"body":['+
             '" <div id=\"section_1\" class=\"mt-page-section\"><span id=\"Overview\"></span><h2 class=\"editable\">Overview</h2></div>",'+
             '{'+
              '  "@target":"toc",'+
              '  "#text":"<ol style=\"list-style-type:none; margin-left:0px; padding-left:0px;\"><li><span>1.</span> <a href=\"#Overview\" rel=\"internal\">Overview</a></li><li><span>2.</span> <a href=\"#Building_an_Objective-Based_Test\" rel=\"internal\">Building an Objective-Based Test</a><ol style=\"list-style-type:none; margin-left:0px; padding-left:15px;\"><li><span>2.1.</span> <a href=\"#What_are_Learning_Paths.3F\" rel=\"internal\">What are Learning Paths?</a></li></ol></li></ol>"'+
             '}'+
          ']'+
       '}'+
    '}';

JSONParser parser = 
   JSON.createParser(JSONContent);
// Make calls to nextToken() 
// to point to the second
// start object marker.
parser.nextToken();
parser.nextToken();
parser.nextToken();
// Retrieve the Person object
// from the JSON string.
content obj = 
   (content)parser.readValueAs(
      content.class);
System.Debug(obj.body[0]);
parser.skipChildren();

I have tested the validity of JSON String here at

http://jsonformatter.curiousconcept.com/

Here I am pasting JSON String Again

{
   "content":{
      "MTType":"text/html",
      "MTTitle":"Test Builder",
      "body":[
         " <div id=\"section_1\" class=\"mt-page-section\"><span id=\"Overview\"></span><h2 class=\"editable\">Overview</h2>  <p>You can use Test Builder to create custom objective&#8208;based tests using objectives from the Odyssey curriculum, your standard state objectives, or your own custom district or school objectives. As part of the test&#8208;building process, you first select a standard set, subject, and level; then, you select the desired associated objectives to include in the custom test.&nbsp;</p> <p>&nbsp;</p> <p>You can make changes to the order and number of objectives for each test and to the test item property settings. All of the tests you create can be saved and edited.</p> </div><div id=\"section_2\" class=\"mt-page-section\"><span id=\"Building_an_Objective-Based_Test\"></span><h2 class=\"editable\">Building an Objective-Based Test</h2>  <p><span style=\"font-size: 12px; line-height: 1.5;\">On the Test Builder page, first select a set of standards from the menu provided. </span>From the Objective Additions drop&#8208;down list on the Select Standard screen of the test builder section, specify how you want objectives to be added to a custom test:</p> <p>&nbsp;</p> <ul> <li><strong>Add to existing objectives</strong> adds newly selected objectives to existing objectives in the test, if any. Select this option when you build a custom test that includes objectives from multiple subjects and/or levels. For example, if you want to include objectives from more than one subject area&mdash;Math and Geometry&mdash;you will select Add to existing objectives.</li> <li><strong>Replace all objectives</strong> includes only the newly selected objectives in the test, replacing any existing objectives, if any, that were previously defined. This option allows you to start building a custom test from the beginning and also may be used when you are editing an existing custom test.</li> </ul> <p>&nbsp;</p> <p>It is important to know that the Objective-Based test is independent from an assignment. For instance, if you copy an assignment containing an Objective-based test, you will have control over the assignment properties, but not the test properties (unless you also created the test). Attempting to edit a test that you did not create may produce the following error message:</p> <p><strong><span style=\"background-color:#faebd7;\">CAUTION:</span></strong><span style=\"background-color:#faebd7;\">&nbsp;If you copy an assignment that includes an objective&#8208;based test, and then edit the test, your edits are applied to the original objective&#8208;based test. See Editing Custom Objective&#8208;based Tests.</span></p> <div id=\"section_3\" class=\"mt-page-section\"><span id=\"What_are_Learning_Paths.3F\"></span><h3 class=\"editable\">What are Learning Paths?</h3>  <p>Some assignments include a&nbsp;<strong>learning path</strong>, a set of activities designed to cover the objectives a student has not mastered in an objective&#8208;based test, an exit exam (for high&#8208;school level curriculum), or a test external to Odyssey. You can build an objective&#8208;based using the Odyssey curriculum; create one with custom assessment objectives; or create one using your state&rsquo;s objectives (where applicable). Odyssey will create a learning path based on objective&#8208;based tests. Learning paths based on customized objectives must be created manually.&nbsp;<br /> <br /> Also, a teacher may administer an exit exam as part of an Odyssey high school course. Alternatively, in schools that have purchased support for Odyssey&rsquo;s Test Translator, the test is administered outside of Odyssey Manager. Administrators use Test Translator to import test results into Odyssey Manager and a learning path is automatically created based on the results of the NWEA or state test.&nbsp;</p></div></div>",
         {
            "@target":"toc",
            "#text":"<ol style=\"list-style-type:none; margin-left:0px; padding-left:0px;\"><li><span>1.</span> <a href=\"#Overview\" rel=\"internal\">Overview</a></li><li><span>2.</span> <a href=\"#Building_an_Objective-Based_Test\" rel=\"internal\">Building an Objective-Based Test</a><ol style=\"list-style-type:none; margin-left:0px; padding-left:15px;\"><li><span>2.1.</span> <a href=\"#What_are_Learning_Paths.3F\" rel=\"internal\">What are Learning Paths?</a></li></ol></li></ol>"
         }
      ]
   }
}

Can anybody please advice, what am I doing wrong here ?

Here is the content class

public class content {
        public String MTType;
        public String MTTitle;
        public List<String> body;
    }

In here, I want to ignore the child of body, we only want to show the body on the Visualforce page, by ignoring the child, i therefore had used Salesforce method called

parser.skipChildren();

Best Answer

The problem seems to be your body is String array

public List<String> body;

But you second object in json is an object.

{
        "@target":"toc",
...

Add a 4th object to your content class and it should be ok.

public class content {
    public String MTType;
    public String MTTitle;
    public List<String> body;
    public TargetText targetText;
}

public class TargetText{
    String target;
    String text;
}

And the json would be something like this

"content":{
...
body : ["...."],
   targetText:{
   target:"..."
   text:"..."
   }
}

Related Solutions

[SalesForce] Issue JSON parsing illegal(?) characters

This wasn't a Salesforce issue, so much as it was an issue with the input. I was using PHP to json_encode in a PHP4.3 environment with JSONWrapper, and the ampersands in the data were not being escaped. Salesforce was trying to parse JSON values with ampersands and treating it as a new parameter. Once I added urlencode($data) within my PHP file prior to sending it to Salesforce it was resolved.

[SalesForce] Illegal Value for primitive when trying to parse the json data

To parse a JSON into a class, you need to check below points first:

If you are using standard JSON.deserialize method you need to check that json should not have any key which is reserved key word in salesforce

Json must not have any key which is not of type string

If you are going to parse your json manually, you can have any valid json and parse it in your class varraible as per your need.

So if you want an easy solution and have rights to change the JSON, Please change the JSON so that you can simply parse it using JSON.Serialize method.

If you cant change the JSON you need to parse it manually like below

public class JSON2Apex {
    public static void consumeObject(JSONParser parser) {
        Integer depth = 0;
        do {
            JSONToken curr = parser.getCurrentToken();
            if (curr == JSONToken.START_OBJECT || 
                curr == JSONToken.START_ARRAY) {
                depth++;
            } else if (curr == JSONToken.END_OBJECT ||
                curr == JSONToken.END_ARRAY) {
                depth--;
            }
        } while (depth > 0 && parser.nextToken() != null);
    }

    public class Description {
        public Boolean validated {get;set;} 
        public String language {get;set;} 
        public String source {get;set;} 
        public String text {get;set;} 

        public Description(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'validated') {
                            validated = parser.getBooleanValue();
                        } else if (text == 'language') {
                            language = parser.getText();
                        } else if (text == 'source') {
                            source = parser.getText();
                        } else if (text == 'text') {
                            text = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Description consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Address {
        public List<Double> location {get;set;} 
        public String formatted {get;set;} 
        public Details details {get;set;} 
        public String source {get;set;} 
        public String raw {get;set;} 

        public Address(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'location') {
                            location = new List<Double>();
                            while (parser.nextToken() != JSONToken.END_ARRAY) {
                                location.add(new Double(parser));
                            }
                        } else if (text == 'formatted') {
                            formatted = parser.getText();
                        } else if (text == 'details') {
                            details = new Details(parser);
                        } else if (text == 'source') {
                            source = parser.getText();
                        } else if (text == 'raw') {
                            raw = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Address consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public Revenue revenue {get;set;} 
    public List<Emails> emails {get;set;} 
    public String lead_enrichment_date {get;set;} 
    public Name name {get;set;} 
    public Integer year_of_establishment {get;set;} 
    public Industry industry {get;set;} 
    public Revenue size {get;set;} 
    public Ranking ranking {get;set;} 
    public List<Revenue> automation {get;set;} 
    public String enrichment_date {get;set;} 
    public String country {get;set;} 
    public List<Leads> leads {get;set;} 
    public Object feedback {get;set;} 
    public Tax_id tax_id {get;set;} 
    public List<String> websites {get;set;} 
    public List<Description> description {get;set;} 
    public List<Phones> phones {get;set;} 
    public Address address {get;set;} 
    public List<Links> links {get;set;} 
    public String id {get;set;} 

    public JSON2Apex(JSONParser parser) {
        while (parser.nextToken() != JSONToken.END_OBJECT) {
            if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                String text = parser.getText();
                if (parser.nextToken() != JSONToken.VALUE_NULL) {
                    if (text == 'revenue') {
                        revenue = new Revenue(parser);
                    } else if (text == 'emails') {
                        emails = new List<Emails>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            emails.add(new Emails(parser));
                        }
                    } else if (text == 'lead_enrichment_date') {
                        lead_enrichment_date = parser.getText();
                    } else if (text == 'name') {
                        name = new Name(parser);
                    } else if (text == 'year_of_establishment') {
                        year_of_establishment = parser.getIntegerValue();
                    } else if (text == 'industry') {
                        industry = new Industry(parser);
                    } else if (text == 'size') {
                        size = new Revenue(parser);
                    } else if (text == 'ranking') {
                        ranking = new Ranking(parser);
                    } else if (text == 'automation') {
                        automation = new List<Revenue>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            automation.add(new Revenue(parser));
                        }
                    } else if (text == 'enrichment_date') {
                        enrichment_date = parser.getText();
                    } else if (text == 'country') {
                        country = parser.getText();
                    } else if (text == 'leads') {
                        leads = new List<Leads>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            leads.add(new Leads(parser));
                        }
                    } else if (text == 'feedback') {
                        feedback = new Object(parser);
                    } else if (text == 'tax_id') {
                        tax_id = new Tax_id(parser);
                    } else if (text == 'websites') {
                        websites = new List<String>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            websites.add(new String(parser));
                        }
                    } else if (text == 'description') {
                        description = new List<Description>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            description.add(new Description(parser));
                        }
                    } else if (text == 'phones') {
                        phones = new List<Phones>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            phones.add(new Phones(parser));
                        }
                    } else if (text == 'address') {
                        address = new Address(parser);
                    } else if (text == 'links') {
                        links = new List<Links>();
                        while (parser.nextToken() != JSONToken.END_ARRAY) {
                            links.add(new Links(parser));
                        }
                    } else if (text == 'id') {
                        id = parser.getText();
                    } else {
                        System.debug(LoggingLevel.WARN, 'Root consuming unrecognized property: '+text);
                        consumeObject(parser);
                    }
                }
            }
        }
    }

    public class Leads {
        public Seniority seniority {get;set;} 
        public String name {get;set;} 
        public Boolean current {get;set;} 
        public String status {get;set;} 
        public String role {get;set;} 
        public List<Links> links {get;set;} 

        public Leads(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'seniority') {
                            seniority = new Seniority(parser);
                        } else if (text == 'name') {
                            name = parser.getText();
                        } else if (text == 'current') {
                            current = parser.getBooleanValue();
                        } else if (text == 'status') {
                            status = parser.getText();
                        } else if (text == 'role') {
                            role = parser.getText();
                        } else if (text == 'links') {
                            links = new List<Links>();
                            while (parser.nextToken() != JSONToken.END_ARRAY) {
                                links.add(new Links(parser));
                            }
                        } else {
                            System.debug(LoggingLevel.WARN, 'Leads consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Tax_id {
        public String formatted {get;set;} 
        public String raw {get;set;} 

        public Tax_id(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'formatted') {
                            formatted = parser.getText();
                        } else if (text == 'raw') {
                            raw = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Tax_id consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Seniority {
        public Integer month {get;set;} 
        public Integer year {get;set;} 
        public String raw {get;set;} 

        public Seniority(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'month') {
                            month = parser.getIntegerValue();
                        } else if (text == 'year') {
                            year = parser.getIntegerValue();
                        } else if (text == 'raw') {
                            raw = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Seniority consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Name {
        public String raw {get;set;} 
        public String formatted {get;set;} 
        public String business_type {get;set;} 
        public String business_alias {get;set;} 
        public String business_name {get;set;} 

        public Name(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'raw') {
                            raw = parser.getText();
                        } else if (text == 'formatted') {
                            formatted = parser.getText();
                        } else if (text == 'business_type') {
                            business_type = parser.getText();
                        } else if (text == 'business_alias') {
                            business_alias = parser.getText();
                        } else if (text == 'business_name') {
                            business_name = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Name consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Industry {
        public List<Revenue> codes {get;set;} 
        public List<String> raw {get;set;} 

        public Industry(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'codes') {
                            codes = new List<Revenue>();
                            while (parser.nextToken() != JSONToken.END_ARRAY) {
                                codes.add(new Revenue(parser));
                            }
                        } else if (text == 'raw') {
                            raw = new List<String>();
                            while (parser.nextToken() != JSONToken.END_ARRAY) {
                                raw.add(new String(parser));
                            }
                        } else {
                            System.debug(LoggingLevel.WARN, 'Industry consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Ranking {
        public Integer delta {get;set;} 
        public Integer phone {get;set;} 
        public Integer social {get;set;} 
        public Integer value {get;set;} 
        public Integer email {get;set;} 

        public Ranking(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'delta') {
                            delta = parser.getIntegerValue();
                        } else if (text == 'phone') {
                            phone = parser.getIntegerValue();
                        } else if (text == 'social') {
                            social = parser.getIntegerValue();
                        } else if (text == 'value') {
                            value = parser.getIntegerValue();
                        } else if (text == 'email') {
                            email = parser.getIntegerValue();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Ranking consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Details {
        public String icon {get;set;} 
        public String permanently_closed {get;set;} 
        public String url {get;set;} 
        public String name {get;set;} 
        public String place_id {get;set;} 
        public String website {get;set;} 
        public String utc_offset {get;set;} 
        public String rating {get;set;} 
        public String international_phone_number {get;set;} 
        public String vicinity {get;set;} 
        public List<String> types {get;set;} 

        public Details(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'icon') {
                            icon = parser.getText();
                        } else if (text == 'permanently_closed') {
                            permanently_closed = parser.getText();
                        } else if (text == 'url') {
                            url = parser.getText();
                        } else if (text == 'name') {
                            name = parser.getText();
                        } else if (text == 'place_id') {
                            place_id = parser.getText();
                        } else if (text == 'website') {
                            website = parser.getText();
                        } else if (text == 'utc_offset') {
                            utc_offset = parser.getText();
                        } else if (text == 'rating') {
                            rating = parser.getText();
                        } else if (text == 'international_phone_number') {
                            international_phone_number = parser.getText();
                        } else if (text == 'vicinity') {
                            vicinity = parser.getText();
                        } else if (text == 'types') {
                            types = new List<String>();
                            while (parser.nextToken() != JSONToken.END_ARRAY) {
                                types.add(new String(parser));
                            }
                        } else {
                            System.debug(LoggingLevel.WARN, 'Details consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Phones {
        public String raw {get;set;} 
        public String area_code {get;set;} 
        public String country {get;set;} 
        public Integer country_code {get;set;} 
        public String number_Z {get;set;} // in json: number
        public String description {get;set;} 
        public String formatted {get;set;} 

        public Phones(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'raw') {
                            raw = parser.getText();
                        } else if (text == 'area_code') {
                            area_code = parser.getText();
                        } else if (text == 'country') {
                            country = parser.getText();
                        } else if (text == 'country_code') {
                            country_code = parser.getIntegerValue();
                        } else if (text == 'number') {
                            number_Z = parser.getText();
                        } else if (text == 'description') {
                            description = parser.getText();
                        } else if (text == 'formatted') {
                            formatted = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Phones consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Links {
        public Integer contacts {get;set;} 
        public Boolean validated {get;set;} 
        public String source {get;set;} 
        public String url {get;set;} 

        public Links(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'contacts') {
                            contacts = parser.getIntegerValue();
                        } else if (text == 'validated') {
                            validated = parser.getBooleanValue();
                        } else if (text == 'source') {
                            source = parser.getText();
                        } else if (text == 'url') {
                            url = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Links consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Revenue {

        public Revenue(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        {
                            System.debug(LoggingLevel.WARN, 'Revenue consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }

    public class Emails {
        public String grade {get;set;} 
        public String type_Z {get;set;} // in json: type
        public String email {get;set;} 

        public Emails(JSONParser parser) {
            while (parser.nextToken() != JSONToken.END_OBJECT) {
                if (parser.getCurrentToken() == JSONToken.FIELD_NAME) {
                    String text = parser.getText();
                    if (parser.nextToken() != JSONToken.VALUE_NULL) {
                        if (text == 'grade') {
                            grade = parser.getText();
                        } else if (text == 'type') {
                            type_Z = parser.getText();
                        } else if (text == 'email') {
                            email = parser.getText();
                        } else {
                            System.debug(LoggingLevel.WARN, 'Emails consuming unrecognized property: '+text);
                            consumeObject(parser);
                        }
                    }
                }
            }
        }
    }


    public static JSON2Apex parse(String json) {
        return new JSON2Apex(System.JSON.createParser(json));
    }
}

This class is generated using JSON2APEX online tool. So please change it as per your need.

thanks

Best Answer

Related Solutions

[SalesForce] Issue JSON parsing illegal(?) characters

[SalesForce] Illegal Value for primitive when trying to parse the json data

Related Topic