Fetch picklist values through SOQL query in Salesforce

Question

I am using Django & Salesforce.

I establish a connection between them through simple-salesforce

I have created a custom picklist on Contact Object of Salesforce.

I wont to fetch all the 20 values of my picklist & display in Django.

I am looking for SOQL to fetch values from Salesforce.

sf = Salesforce(instance_url='https://test.salesforce.com', session_id='')

sf1 = Salesforce(connection parameters)

sf3 = sf1.query("SELECT Color__c FROM Contact")

sf3 will give me values set for respective Contact records.

I want to fetch all the 20 values I have entered while creating Color__c on Contact object. In Apex we can do that, something like below

public class PicklistUtil { 

    public static List<Schema.PicklistEntry> getContactColor() { 

        return Contact.Color__c.getDescribe().getPicklistValues(); 

   } 

}

I am looking to do the same in Django. Can someone please help?

Answer 1

There might be a stable way, but the following should work:

d = sf1.Contact.describe()

for f in d['fields']:

    if f['name'] == 'Color__c':

        break

picklist = f['picklistValues']

picklist should then be a list of OrderedDicts.

To learn in-depth about Workflow in Salesforce, sign up for an industry based Salesforce administrator certification.