You need to sign in to do that
Don't have an account?
Rakin 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.
TLDR: Need help retrieving multi-picklist metadata and the dependent picklists.
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