\u00a0Most of the time i found this question on microsoft forum to get product information based on productid. I have develped this code for the same requirement.<\/p>\n
You can just paste this code on the onchange event of the product lookup. You just need to chage field names accordingly.<\/p>\n
__________________________________________________<\/p>\n
GetProductInformation();<\/p>\n
function GetProductInformation()<\/p>\n
{<\/p>\n
var resultXml;<\/p>\n
var errorCount;<\/p>\n
var msg;<\/p>\n
var EntityName=”product”;<\/p>\n
var xmlHttpRequest;<\/p>\n
FetchID =crmForm.all.[name of your lookup field].DataValue[0].id<\/p>\n
var AttributeNameList = new Array(‘vendorname’);<\/p>\n
var authenticationHeader = GenerateAuthenticationHeader();<\/p>\n
\/\/Prepare the SOAP message.<\/p>\n
var xml = “<?xml version=’1.0′ encoding=’utf-8′?>” +<\/p>\n
“<soap:Envelope xmlns:soap=’http:\/\/schemas.xmlsoap.org\/soap\/envelope\/'” +<\/p>\n
” xmlns:xsi=’http:\/\/www.w3.org\/2001\/XMLSchema-instance'” +<\/p>\n
” xmlns:xsd=’http:\/\/www.w3.org\/2001\/XMLSchema’>”+<\/p>\n
authenticationHeader +<\/p>\n
“<soap:Body>” +<\/p>\n
“<Retrieve xmlns=’http:\/\/schemas.microsoft.com\/crm\/2007\/WebServices’>” +<\/p>\n
“<entityName>”+EntityName+”<\/entityName>” +<\/p>\n
“<id>” + FetchID + “<\/id>” +<\/p>\n
“<columnSet xmlns:q1=’http:\/\/schemas.microsoft.com\/crm\/2006\/Query’ xsi:type=’q1:ColumnSet’>” +<\/p>\n
“<q1:Attributes>”;<\/p>\n
for (var i = 0; i < AttributeNameList.length; i++) {<\/p>\n
xml = xml +<\/p>\n
‘<q1:Attribute>’ + AttributeNameList[i] + ‘<\/q1:Attribute>’;<\/p>\n
}<\/p>\n
xml = xml +<\/p>\n
‘<\/q1:Attributes><\/columnSet>’;<\/p>\n
xml = xml +<\/p>\n
“<\/Retrieve><\/soap:Body><\/soap:Envelope>”;<\/p>\n
\/\/call function to create Soap Request to ms crm webservice<\/p>\n
xmlHttpRequest =new ActiveXObject(“Msxml2.XMLHTTP”);<\/p>\n
xmlHttpRequest.Open(“POST”, “\/mscrmservices\/2007\/CrmService.asmx”, false);<\/p>\n
xmlHttpRequest.setRequestHeader(“SOAPAction”, “http:\/\/schemas.microsoft.com\/crm\/2007\/WebServices\/Retrieve”);<\/p>\n
xmlHttpRequest.setRequestHeader(“Content-Type”, “text\/xml; charset=utf-8”);<\/p>\n
xmlHttpRequest.setRequestHeader(“Content-Length”, xml.length);<\/p>\n
xmlHttpRequest.send(xml);<\/p>\n
resultXml = xmlHttpRequest.responseXML;<\/p>\n
var errorCount = resultXml.selectNodes(‘\/\/error’).length;<\/p>\n
if (errorCount != 0)<\/p>\n
{<\/p>\n
var msg = resultXml.selectSingleNode(‘\/\/description’).nodeTypedValue; \/\/Process and display the results.<\/p>\n
}<\/p>\n
else<\/p>\n
{<\/p>\n
if (resultXml.selectSingleNode(‘\/\/q1:vendorname’) != null)<\/p>\n
crmForm.all.[customfieldnametostorevendorname].DataValue = resultXml.selectSingleNode(‘\/\/q1:vendorname’).nodeTypedValue; }}}<\/p>\n
_____________________________________________________<\/p>\n
May be this code can help somebody at right time.<\/p>\n
Best of luck !!!\u00a0\u00a0\u00a0 \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0Most of the time i found this question on microsoft forum to get product information based on productid. I have develped this code for the same requirement. You can just paste this code on the onchange event of the product lookup. You just need to chage field names accordingly. __________________________________________________ GetProductInformation(); function GetProductInformation() { var resultXml; var errorCount; var msg;… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/66"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=66"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}