Yesterday came across a requirement to list down Lead Convert Custom Field Mappings in terms of API Names ie Lead Field1__c maps to Account\/Contact\/Opportunity Field1__c. Salesforce UI doesn’t give that option to extract same. Neither any metadata API got that, really strange that there’s no way I can extract Lead Convert Custom Field Mappings (in terms of API Names). Is there any? please help in case I’m missing some standard way of extracting that out?<\/p>\n
Easiest option could have been that I sit down and do manual and tedious way of reading each field label finding its API Name and record the same in excel, but this doesn’t seem viable option for an org with 100+ lead convert field mappings. As I couldn’t find one using all standard approaches, I started thinking of wicked ways of achieving it. And as usual Javascript (jQuery) comes to rescue party!<\/p>\n
Login to Salesforce Org in Chrome or FF Browser,
\nNavigate to lead convert field mappings page (Select Your Name | Setup | Customize | Leads | Fields | Map Lead Fields),
\nOpen Javascript Console,
\nNow load jQuery first (you can do same by loading any existing jQuery booklet or userscript too) by executing below code in JS Console.<\/p>\n
\nvar jq = document.createElement('script');
\njq.src = \"\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.8.2\/jquery.min.js\";
\ndocument.getElementsByTagName('head')[0].appendChild(jq);
\n$j=jQuery.noConflict();<\/code><\/p><\/blockquote>\nNow comes the main code which will output LeadFieldAPIName, Account\/Contact\/Opportunity Field APIName, Account or Contact or Opportunity. Execute below code too in JS Console.<\/p>\n
\/\/Traverse across all Select elements
\n$j(\"select\").each(function () {<\/code><\/p>\n\/\/Consider only the ones with a mapping selected
\nif (this.value != '') {<\/code><\/p>\n\/\/Fetch Object Name to which this particular Lead field is mapped, whether its Account or Contact or Opportunity
\nvar objectname = $(this).find('option:selected').text().split(\".\")[0];<\/code><\/p>\n\/\/Tricky Part : As this lead convert field mappings page doesn’t store Lead field API Names, it only contains lead field ID (15 digit SFDC ID) so we will have to do AJAX request of LEAD field detail webpage to fetch LEAD API Name corresponding to lead field ID
\nvar contentText = $.ajax({url: \"\/\" + this.name,async: false}).responseText;<\/code><\/p>\n\/\/In fetched content, search and extract field API Name
\nvar fromfield = $(contentText).find('td').filter(function () {
\nreturn $(this).text().indexOf('API Name') === 0;
\n}).closest('td').next().html();<\/code><\/p>\n\/\/Similarly AJAX request for Account\/Contact\/Opportunity field detail page to fetch respective field API Name
\ncontentText = $.ajax({url: \"\/\" + this.value,async: false}).responseText;<\/code><\/p>\n\/\/In fetched content, search and extract field API Name
\nvar tofield = $(contentText).find('td').filter(function () {
\nreturn $(this).text().indexOf('API Name') === 0;
\n}).closest('td').next().html();<\/code><\/p>\n\/\/Output LeadAPIName, Account\/Contact\/Opportunity APIName, Account or Contact or Opportunity
\nconsole.log(fromfield + ',' + tofield + ',' + objectname);<\/code><\/p>\n
}});<\/code><\/p><\/blockquote>\nPlease Note:<\/p>\n
\n
- This isn’t most neat and recommended way, so if you come across\u00a0something\u00a0really clean and less network consuming solution please share your solutions in comments below<\/li>\n
- I’m not an expert in jQuery, so there might be obvious and recommended ways of coding jQuery and my above coding might sound nascent way of handling jQuery, so please ignore my lack of knowledge around jQuery and help me to optimize same.<\/li>\n
- Fetching Lead\/Account\/.. Field API Name from Field ID might be done using other ways too (describe API Calls?), but thought of doing it in just one script, so did that using AJAX calls and parsing retrieved webpage content<\/li>\n
- As always, feedback\/suggestions are always welcome<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Yesterday came across a requirement to list down Lead Convert Custom Field Mappings in terms of API Names ie Lead Field1__c maps to Account\/Contact\/Opportunity Field1__c. Salesforce UI doesn’t give that option to extract same. Neither any metadata API got that, really strange that there’s no way I can extract Lead Convert Custom Field Mappings (in […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[151,150,147,149,146,148,143,144,145,169],"class_list":["post-2575","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-ajax","tag-api-names","tag-chrome","tag-console","tag-field-mappings","tag-firefox","tag-jquery","tag-js","tag-lead-convert","tag-salesforce","post-preview"],"_links":{"self":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/comments?post=2575"}],"version-history":[{"count":31,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2575\/revisions"}],"predecessor-version":[{"id":2598,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2575\/revisions\/2598"}],"wp:attachment":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/media?parent=2575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/categories?post=2575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/tags?post=2575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}