[SalesForce] How to update picklist using REST API

Would anyone have an example on how to update a picklist?

I have a System Custom Field that I want to append add new items to as it comes up.

The details of the field are the following:

Field Label: Device Status
Field Name: Device_Status
API Name: Device_Status__c
Object Name: System Data
Type: Picklist

How can I append one picklist value using REST API?

Best Answer

As the other answer says, you can do this via the Tooling API if you want to use a REST call. You can find the details on their answer. The other option is to use the Metadata API which is a SOAP API. This stackexchange post has some example code about updating picklists using the Metadata API. The first link to the Metadata API docs should get you started on how to use it. If you are trying to do this in Apex, there is an apex wrapper for the Metadata API on Github.

There is an idea for implementing the Metadata API in Apex natively here, and it appears that the latest update on that idea indicates that as of October 2019 they are not planning on updating that API in the near future.

Related Solutions

[SalesForce] REST API: How to update active values for picklist

I was finally able to figure it out. It was a combination of using the RecordType with the metadata.update() call:

public void recordTypeSample() throws InterruptedException
{
  try
  {
    RecordType productInfo = new RecordType();
    productInfo.setFullName("Product_Information__c.OHM");
    productInfo.setLabel("OHM");

    PicklistValue version1 = new PicklistValue();
    version1.setFullName("7.4.5");

    RecordTypePicklistValue ohmVersions = new RecordTypePicklistValue();
    ohmVersions.setPicklist("Licensed_Version__c");
    ohmVersions.setValues(new PicklistValue[] { version1 });
    productInfo.setPicklistValues(new RecordTypePicklistValue[] { ohmVersions });

    UpdateMetadata updateMetadata = new UpdateMetadata();
    updateMetadata.setMetadata(productInfo);
    updateMetadata.setCurrentName(productInfo.getFullName());

    AsyncResult[] asyncResults = this.metadataConnection.update(new UpdateMetadata[] { updateMetadata });

    AsyncResult asyncResult = asyncResults[0];

    // set initial wait time to one second
    long waitTimeMilliSecs = 1000;
    while(!asyncResult.isDone())
    {
      Thread.sleep(waitTimeMilliSecs);
      // double the wait time for the next iteration
      waitTimeMilliSecs *= 2;
      asyncResult = metadataConnection.checkStatus(new String[] { asyncResult.getId() })[0];
    }
  }
  catch(ConnectionException ce)
  {
    ce.printStackTrace();
  }
}

[SalesForce] Workflow Field Update formula function TEXT() using picklist API values, not label values

So I have found a workaround...with help from Salesforce:

Under "Data Management" -> "Picklist Settings" enable the sole setting of "Disable editing picklist values' API names"
Go to your picklist field and delete the entry
Add the value back into the picklist

By default the API Name is an exact copy of the Value, it includes spaces, special characters etc.

By enabling the first setting I can avoid encountering this problem by stopping the developers playing with the API names...

Best Answer

Related Solutions

[SalesForce] REST API: How to update active values for picklist

[SalesForce] Workflow Field Update formula function TEXT() using picklist API values, not label values

Related Topic