\u00a0If you want to fetch Max value from CRM entity record using Javascript, you can use below code, remember to change entity and field name accordingly<\/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
“<RetrieveMultiple xmlns=’http:\/\/schemas.microsoft.com\/crm\/2007\/WebServices’>”+<\/p>\n
“<query xmlns:q1=’http:\/\/schemas.microsoft.com\/crm\/2006\/Query'”+<\/p>\n
” xsi:type=’q1:QueryExpression’>”+<\/p>\n
“<q1:EntityName>EntityName<\/q1:EntityName>”+ \/\/change entity name<\/p>\n
“<q1:ColumnSet xsi:type=’q1:ColumnSet’>”+<\/p>\n
“<q1:Attributes>”+<\/p>\n
“<q1:Attribute>FieldName<\/q1:Attribute>”+ \/\/change field name<\/p>\n
“<\/q1:Attributes>”+<\/p>\n
“<\/q1:ColumnSet>”+<\/p>\n
“<q1:Orders>” +<\/p>\n
“<q1:Order>” +<\/p>\n
“<q1:AttributeName>FieldName<\/q1:AttributeName>” + \/\/change field name<\/p>\n
“<q1:OrderType>Descending<\/q1:OrderType>” +<\/p>\n
“<\/q1:Order>” +<\/p>\n
“<\/q1:Orders>” +<\/p>\n
“<\/query>”+<\/p>\n
“<\/RetrieveMultiple>”+<\/p>\n
“<\/soap:Body>”+<\/p>\n
“<\/soap:Envelope>”;<\/p>\n
\/\/ Prepare the xmlHttpObject and send the request.<\/p>\n
var xHReq = new ActiveXObject(“Msxml2.XMLHTTP”);<\/p>\n
xHReq.Open(“POST”, “\/mscrmservices\/2007\/CrmService.asmx”, false);<\/p>\n
xHReq.setRequestHeader(“SOAPAction”,”http:\/\/schemas.microsoft.com\/crm\/2007\/WebServices\/RetrieveMultiple”);<\/p>\n
xHReq.setRequestHeader(“Content-Type”, “text\/xml; charset=utf-8”);<\/p>\n
xHReq.setRequestHeader(“Content-Length”, xml.length);<\/p>\n
xHReq.send(xml);<\/p>\n
\/\/ Capture the result.<\/p>\n
var resultXml = xHReq.responseXML;<\/p>\n
\/\/ Check for errors.<\/p>\n
var errorCount = resultXml.selectNodes(‘\/\/error’).length;<\/p>\n
if (errorCount != 0)<\/p>\n
{<\/p>\n
var msg = resultXml.selectSingleNode(‘\/\/description’).nodeTypedValue;<\/p>\n
alert(msg);<\/p>\n
}<\/p>\n
else<\/p>\n
{<\/p>\n
var results = resultXml.getElementsByTagName(‘BusinessEntity’);<\/p>\n
var msg = “”;<\/p>\n
if (results.length == 0)<\/p>\n
{<\/p>\n
alert(msg);<\/p>\n
return;<\/p>\n
}<\/p>\n
else<\/p>\n
{<\/p>\n
if(results[0].selectSingleNode(‘.\/q1:FieldName’)!=null)<\/p>\n
{<\/p>\n
var MaxValue = results[0].selectSingleNode(‘.\/q1:FieldName’).nodeTypedValue;\u00a0\u00a0 \/\/change name of the field to get Max value<\/p>\n
alert(MaxValue);<\/p>\n
}<\/p>\n
}}<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0If you want to fetch Max value from CRM entity record using Javascript, you can use below code, remember to change entity and field name accordingly var authenticationHeader = GenerateAuthenticationHeader(); \/\/ Prepare the SOAP message. var xml = “<?xml version=’1.0′ encoding=’utf-8′?>”+ “<soap:Envelope xmlns:soap=’http:\/\/schemas.xmlsoap.org\/soap\/envelope\/’”+ ” xmlns:xsi=’http:\/\/www.w3.org\/2001\/XMLSchema-instance’”+ ” xmlns:xsd=’http:\/\/www.w3.org\/2001\/XMLSchema’>”+ authenticationHeader+ “<soap:Body>”+ “<RetrieveMultiple xmlns=’http:\/\/schemas.microsoft.com\/crm\/2007\/WebServices’>”+ “<query xmlns:q1=’http:\/\/schemas.microsoft.com\/crm\/2006\/Query’”+ ” xsi:type=’q1:QueryExpression’>”+ “<q1:EntityName>EntityName<\/q1:EntityName>”+ \/\/change entity name “<q1:ColumnSet… 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":[24,25],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/410"}],"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=410"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/410\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}