[SalesForce] Fetch dependent picklist values depending on record type

I have a two picklists PL1 and PL2. PL1 is controlling picklist and PL2 is dependent picklist.

I want to fetch values of PL1 in Apex depending on recordTypes in Apex method, which I already have using the API endpoint

/ui-api/object-info/{0}/picklist-values/{1}/{2}.

Now I want to fetch the dependent values of PL2 in a map depending on record type. Is there any API endpoint for the same?

I have already read some blogs on fetching dependent picklist values, but none of them implement record types.

Best Answer

According to UI API for Salesforce:

The endpoint:

GET /ui-api/object-info/{objectApiName}/picklist-values/{recordTypeId}/{fieldApiName}

gives you valid values for record type along with controlling fields and their values.

In the documentation, it gives an example for Country to City dependent picklist for a given recordType. The sample response would look like

{
  "picklistFieldValues" : {

    "Cities__c" : {
      "controllerValues" : {
        "Australia" : 0,
        "Brazil" : 1,
        "China" : 2,
        "Colombia" : 3,
        "France" : 4,
        "Italy" : 5,
        "Mexico" : 6,
        "New Zealand" : 7,
        "Nigeria" : 8,
        "Senegal" : 9,
        "South Korea" : 10,
        "US" : 11
      },
      "defaultValue" : null,
      "url" : "/services/data/v44.0/ui-api/object-info/account/picklist-values/012000000000000AAA/Cities__c",
      "values" : [ {
        "attributes" : null,
        "label" : "Cali",
        "validFor" : [ 3 ],
        "value" : "Cali"
      }, {
        "attributes" : null,
        "label" : "Chicago",
        "validFor" : [ 11 ],
        "value" : "Chicago"
      }, {
        "attributes" : null,
        "label" : "Dakar",
        "validFor" : [ 9 ],
        "value" : "Dakar"
      }, {
        "attributes" : null,
        "label" : "Lagos",
        "validFor" : [ 8 ],
        "value" : "Lagos"
      }, {
        "attributes" : null,
        "label" : "Los Angeles",
        "validFor" : [ 11 ],
        "value" : "Los Angeles"
      }, {
        "attributes" : null,
        "label" : "Oaxaca",
        "validFor" : [ 6 ],
        "value" : "Oaxaca"
      }, {
        "attributes" : null,
        "label" : "Wellington",
        "validFor" : [ 7 ],
        "value" : "Wellington"
      } ]
    },

Which you can easily parse and create map of dependent picklist values depending on record type

Here for dependent field City__c see the controlling values for countries in controllerValues

Src: https://developer.salesforce.com/docs/atlas.en-us.uiapi.meta/uiapi/ui_api_features_records_dependent_picklist.htm?search_text=dependent

Related Solutions

[SalesForce] Creating Picklist based on a other text field value

This will depend on your archetecture of the question record and your answers.

Lets assume the Object that holds your questions also holds the answers. You can also do this by having an answers object that has a MD relationship to the question object and iterate over those to build the lists.

As an example:

Question Object -> Question_Field__c, Answer_Field__c (Text), isPicklist__c

Then in your controller you populate your answers into the variable you define...

To populate the pick list for the questions with an isPicklist__c = true you would create a method to get the answers as a pick list:

public SelectOption[] populate_Answers(Question__c q){

    String[] tmp = q.Answer_Field__c.split(';');
    SelectOption[] ans = New SelectOption[]{};

    for(String a : tmp){
        ans.add(New SelectOption(a,a));
    }

    return ans;

}

Now, how you use this or populate it on your page you will need to figure out. A wrapper class may be necessary as well as conditional rendering on the VF page to either show a pick list, value, true false, etc.

[SalesForce] Fetching picklist values based on record type

Not sure about ForceTK ,may be this is not implemented by library yet or safe harbour and I am not sure .

But normally through standard REST API we can implement this using below REST Service

/services/data/v33.0/sobjects/Account/describe/layouts/

For different object you can change Object name and versions

/vXX.X/sobjects/Object/describe/layouts/

I just checked my dev console and it does return values as expected .There is a recordtype mappings that can give you various picklists needed

enter image description here

I see you are using visualforce and hence if you use visualforce you can directly call this REST API from Visualforce using Jquery and it will not require any ForceTK(Although I love forceTk)

      <apex:page>
     <apex:includeScript value="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.7.2.min.js"/>
    <script>
     jQuery(document).ready(function($) {
     // Pull 10 Accounts via the REST API
      $.ajax('/services/data/v33.0/sobjects/Account/describe/layouts/',
    {
      beforeSend: function(xhr) {
        // Set the OAuth header from the session ID
        xhr.setRequestHeader('Authorization', 'Bearer {!$Api.Session_ID}');
      },
      success: function(response) {
        // We got 'em - append our records to the HTML list
        $.each(response.records, function(index, record) {
          $('#responselist').append('<li>'+record.recordTypeMappings+'</li>');
        });
      },
      error: function(jqXHR, textStatus, errorThrown) {
        // Oops - what went wrong?
        alert(jqXHR.status + ': ' + errorThrown);
      }
    }
  );
    });
  </script>
   <h1>Test REST API Without Proxy</h1>
     <p>Data:</p>
        <ul id="responselist">
     </ul>
  </apex:page>

Best Answer

Related Solutions

[SalesForce] Creating Picklist based on a other text field value

[SalesForce] Fetching picklist values based on record type

Related Topic