function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
grajgraj 

Metadata API object for Industry List

Hi,

In our system we have few picklist like Industry, JobTitle, Country, No Of Employees. I was told by SF that I need to use the Metadata API to retrieve this list. I am able to set the Metadata service and SF connection but what object do I need to query in order to get the list.

Any help is appreciated.

 

Goutam

A_SmithA_Smith

What are you trying to do with these picklists?  You can always print the list from setup.  Just pull up the field and click printable view button.
grajgraj

I am working on a scheduled job in MVC3 to sync the list in SF with our local DB tables in Sql Server. I am trying to avoid the manual entry and the job will also help to keep the data in sync if a new entry is added to the list in SF.

 

 
A_SmithA_Smith

So you need to query for all the objects in the system.  Then each object will include the field details.  Something like this in your package.xml file.  

 

<types>

        <members>*</members>

        <members>Account</members>

        <members>AccountContactRole</members>

        <members>Activity</members>

        <members>Asset</members>

        <members>Campaign</members>

        <members>CampaignMember</members>

        <members>Case</members>

        <members>CaseContactRole</members>

        <members>Contact</members>

        <members>ContentVersion</members>

        <members>Contract</members>

        <members>ContractContactRole</members>

        <members>Event</members>

        <members>Idea</members>

        <members>JigsawSavedSearch</members>

        <members>Lead</members>

        <members>Opportunity</members>

        <members>OpportunityContactRole</members>

        <members>OpportunityLineItem</members>

        <members>PartnerRole</members>

        <members>Product2</members>

        <members>Site</members>

        <members>Solution</members>

        <members>Task</members>

        <members>User</members>

        <members>UserLicense</members>

        <name>CustomObject</name>

    </types>
Apex LearnerApex Learner

hi i have been  woring on METADATA Api 

 

and i have successfully create soap envelope to add new picklist value in picklist field

via

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:met="http://soap.sforce.com/2006/04/metadata">
   <soapenv:Header>
      <met:CallOptions>
         <met:client>---</met:client>
      </met:CallOptions>
      <met:SessionHeader>
         <met:sessionId>---</met:sessionId>
      </met:SessionHeader>
   </soapenv:Header>
   <soapenv:Body>
      <update xmlns="http://soap.sforce.com/2006/04/metadata">
     <!--Zero or more repetitions:-->
      <UpdateMetadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="customfield">
		    <currentName>lead.number__c</currentName>
		                
		      <metadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CustomField">
		      <!--Optional:-->
		       <fullName>lead.number__c</fullName>
		       <label>number</label>
		    		<picklist>
		              <picklistValues>
		         			<fullName>new</fullName>
		              </picklistValues>
		         		 <sorted>false</sorted>
		  		</picklist>
		         <type>Picklist</type>
		    </metadata>
         </UpdateMetadata>
       </update>
   </soapenv:Body>
</soapenv:Envelope>

 Now issues I am facing , is

Is there any way to update / edit any particular picklist value ???

 

e.g , Object : Lead , field : number__c, type : picklist , picklist values : new , old 

 

any way i can edit "new " to "new_value" via meta data API .

 

Thanks in advance