How to issue FetchXML in ONLOAD

All Replies

• Wednesday, November 04, 2009 5:13 PMAndriy a33ik Butenko

   
  

  0

  Sign In to Vote
  Hi, Bill.
  
  You code is definitely wrong.
  
  Errors you have:
  1. After soap:Body tag your code must contain something like
  
  "<Fetch xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
  "<fetchXml>...
  
  instead your code.
  
  2. You have to encode your fetch request like
  
  "&lt;fetch mapping='logical'&gt;"+
  "&lt;entity name='mdv_notetest'&gt;"+
  "&lt;attribute name='mdv_name'/&gt;"+
  "&lt;attribute name='mdv_notetestid'/&gt;"+
  "&lt;/entity&gt;"+
  "&lt;/fetch&gt;"+
  
  instead your code.
  
  3. When you parse fetch - you can't use code like
  var buNodes = buXml.selectNodes("//BusinessEntity/q1:statecode");
  
  Try toy use following code (I haven't tested it so you can):
  
  

  var results = GetMyFetch();
  
  if (results != null) 
  {
  	var icnt = results.length;
  
  	if (document.getElementById('navcontacts') != null && icnt > 0) 
  	{
  		document.getElementById('navcontacts').getElementsByTagName('NOBR')[0].innerText = document.getElementById('navcontacts').getElementsByTagName('NOBR')[0].innerText + " (" + icnt + ")";
  	}
  }
  
   
  
  function GetMyFetch() {
  var authenticationHeader = GenerateAuthenticationHeader();
  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>" +
  "<Fetch xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+ 
  "<fetchXml>&lt;fetch mapping='logical'&gt;"+
  "&lt;entity name='mdv_notetest'&gt;"+
  "&lt;attribute name='mdv_name'/&gt;"+
  "&lt;attribute name='mdv_notetestid'/&gt;"+
  "&lt;/entity&gt;"+
  "&lt;/fetch&gt;</fetchXml>"+
  "</Fetch>"+
  "</soap:Body>" +
  "</soap:Envelope>";
  var xHReq = new ActiveXObject("Msxml2.XMLHTTP");
  xHReq.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
  xHReq.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Fetch");
  xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
  xHReq.setRequestHeader("Content-Length", xml.length);
  xHReq.send(xml);
  var resultXml = xHReq.responseXML;
  var resultSet = resultXml.text;
  
  resultSet.replace('&lt;','<');
  resultSet.replace('&gt;','>');
  
  var oXmlDoc = new ActiveXObject("Microsoft.XMLDOM");
  oXmlDoc.async = false; 
  oXmlDoc.loadXML(resultSet);
  var results = oXmlDoc.getElementsByTagName('result');
  return results;
  } 
  

  
  And here is the sample how to work with Fetch requests.

  ---

  Truth is opened the prepared mind My blog - http://a33ik.blogspot.com

  • Marked As Answer byBILL_TETRAULT Wednesday, November 04, 2009 7:50 PM
  •  
  • Reply
  • Quote

   
• Wednesday, November 04, 2009 9:00 PMDaniel Cai

   
  

  0

  Sign In to Vote
  Hi Bill,
  
  As a side note, you might want to use a reusable CRM Web Service helper / toolkit to do it. I have a CRM Web Service Helper available at my blog, which will probably make your life a little bit easier.
  
  Cheers,

  ---

  Daniel Cai | http://danielcai.blogspot.com
  • Reply
  • Quote

   
• Wednesday, November 04, 2009 9:19 PMBILL_TETRAULT

   
  

  0

  Sign In to Vote

  Thanks, will take a look

  • Reply
  • Quote