function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Rakin MohammedRakin Mohammed 

how to extract multi-picklist data to csv file?

Hi guys. I have a custom case object that prompts users upon creating a new case to select options from a picklist. Depending on which option is picked, the dependent sub-category picklist dependent options are shown. Followed by a third sub-category. I need to be able to retrieve the different options and their succeeding choices in an excel sheet, with the dependent data all on the same row. I use the Python requests library to create a session with the Salesforce server and extract information from the page css. I also have the API names of the three picklists. Could anyone point me in the right direction to pull the picklist and push to csv file.  

TLDR: Need help retrieving multi-picklist metadata and the dependent picklists. 
ShirishaShirisha (Salesforce Developers) 
Hi Rakin,

Greetings!

You can use the data loader to pull the values of multipicklist values which will be separated by semi colon(;) as mentioned in the below article:

https://help.salesforce.com/articleView?id=000339303&type=1&mode=1

Also,you can use ANT migration tool to retrieve the metadata using the below document:

https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/customfield.htm

Please mark it as best answer if it helps you to fix the issue.

Thank you!

Regards,
Shirisha Pathuri