[SalesForce] Convert JSON Array into Wrapper class in Salesforce

In certain callout I want to send JSON Array in following format. And based on this I want to parse this into doPost method and generate a dynamic query to query on Account object. But, I cannot access the List of Country into doPost method from wrapper class.

JSON Format I have to send:

{

"country":[ "IN", "PH", "KR" ], "Type":[ "Installation Partner",
"Technology Partner"], "industry":[ "Energy", "Education" ]

}

The Wrapper class I have written:

public class accountforPostRequestWrapper {

    public List<String> country{get; set;}
    public List<String> Type{get; set;}
    public List<String> industry{get; set;}

    public static List<accountforPostRequestWrapper> parse(String json){
         return (List<accountforPostRequestWrapper>) System.JSON.deserialize(json, List<accountforPostRequestWrapper>.class);
    }

}

Am I missing something.
In RestResource Class I have write something like below.

but its throwing error:

"Variable does not exist: country"

global with sharing class AccountResource {
@HttpPost
global static void doPost() {
    RestRequest req = RestContext.request;
    Blob body = req.requestBody;
    String jsonString = body.toString();

    List<String> listofCountry = new List<String>();
    listofCountry.clear();

    List<accountforPostRequestWrapper> accWr = accountforPostRequestWrapper.parse(jsonString);
    listofCountry.addAll(accWr.country);

    // In Above line this giving ERROR: "Variable does not exist: country"

    //Generate dynamic SOQL based on JSON Input       
    String searchStr = 'SELECT Id,Name,Industry,Type,Country_code__c FROM Account WHERE';
    String conditionStr = 'Country_code__c =: null';
    if(!accWr.isEmpty()){
            //to generate dynamic conditionStr here based on 
            //   country,Type, and industry value
        }
    }
}

Please help me how to parse this kind of JSON and how to fetch value from wrapper class and to generate the dynamic query considering null as well. Scenario is possible also that JSON contains no country, but has Type and industry. Please help.

Best Answer

Problem is accWr is declared as a List.

parse method must return an object:

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

And your code would be as:

List<String> listofCountry = new List<String>();
listofCountry.clear();

AccountforPostRequestWrapper accWr = AccountforPostRequestWrapper.parse(jsonString);
listofCountry.addAll(accWr.country);

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

This is untested so you may need to have play, however this should return a List of the RevenueWrapper classes which contains the 4 columns you are looking to use in your VF page:

public class RevenueController{

Map<String, RevenueWrapper> ResultList = new Map<String, RevenueWrapper>(); 

public RevenueController(){
    List<AggregateResult> result =  [
    SELECT FISCAL_YEAR(Date__c) Date, Type__c, sum(Amount__c) Amount
    FROM Revenue__c
    GROUP BY FISCAL_YEAR(Date__c), Type__c];

    for(AggregateResult ar : result){

        RevenueWrapper RW = new RevenueWrapper();

        //If the RevenueWrapper already exists grab it from the Map
        if(ResultList.containsKey(String.valueOf(ar.get('Date')))){
            RW = ResultList.get(String.valueOf(ar.get('Date')));
        }

        //Set the amount
        RW.setAmount(ar);

        //Save back to the Map
        ResultList.put(String.valueOf(ar.get('Date')), RW);
    }
}

public List<RevenueWrapper> getResults() {
    return ResultList.values();
}


public class RevenueWrapper{
    public String revenueDate { get; set; }
    public Integer budgetAmount { get; set; }
    public Integer actualAmount { get; set; }
    public Integer varianceFYPercent { set; }
    public Integer varianceFYAmount { set; }

    public RevenueWrapper(){

    }

    public void setAmount(AggregateResult ar){
        revenueDate = String.valueOf(ar.get('Date'));

            //Set the amount value based on type
        if(ar.get('Type__c') == 'Budget'){
            budgetAmount = Integer.valueOf(ar.get('Amount'));
        }else if(ar.get('Type__c') == 'Actual'){
            actualAmount = Integer.valueOf(ar.get('Amount'));
        }else{ //Catch all for a type that isn't recognised
            return;
        }

    }

    public Integer getVarianceFYAmount(){
        return actualAmount - budgetAmount;
    }

    public Decimal getVarianceFYPercent(){
        if(budgetAmount != 0){
            return Decimal.valueOf((Double.valueOf(actualAmount) / Double.valueOf(budgetAmount)) * 100).setscale(1);
        } else{
            return 0;
        }
    }
}

}

[SalesForce] Wrapper class, Rest and json

Assuming the scenario is as simple as you have mentioned in the question you could add the query parameter in the requesturl in your REST call:

url : "SELECT+name,account.name,account.id,Name+from+contact+where+account.activstatus=true"

also set the contentType as "application/json":

 content-Type: "application/json"

This should give you a result in the json format. But you will not get all the records at once, you will get in batches (max 2000). Each response will contain url to which you can make your next request to so as to get the next batch of data..

Related Topic