Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

11 responses to “Retrieve record using OData and JQuery in CRM 2011”

1. 

   Jaques Els

   February 17, 2012

   The code works, but does not actually read the record, it goes into

   function readRecord(data, textStatus, XmlHttpRequest) {
   alert(“Record read successfully!”);
   var account = data;
   alert(“Name – ” + account.Name);
   alert(“Id – ” + account.AccountId);
   }
   But then account.Name and account.AccountId is NULL?

   Is there anything I am doing wrong?

   Reply
2. 

   Jaques Els

   February 17, 2012

   It needed the data.d.Name to work…

   function readRecord(data, textStatus, XmlHttpRequest) {

   var aName = “”;
   var aID = “”;

   var account = data;
   if (account.Name != null)
   aName = account.Name;
   else
   aName = data.d.Name;

   if (account.AccountId!= null)
   aID = account.AccountId;
   else
   aID = data.d.AccountId;
   }

   Reply
   1. 

      Rajeev Pentyala

      February 17, 2012

      Thanks for the update Jaques

      Reply
3. 

   Prasun

   February 23, 2012

   function retrieveRecord(id, odataSetName, successCallback, errorCallback) {

   var serverUrl = Xrm.Page.context.getServerUrl();
   var ODATA_ENDPOINT = “/XRMServices/2011/OrganizationData.svc”;

   alert(serverUrl);
   alert(ODATA_ENDPOINT);
   alert(id);
   alert(odataSetName);

   if (!id) {
   alert(“record id is required.”);
   return;
   }

   if (!odataSetName) {
   alert(“odataSetName is required.”);
   return;
   }

   $.ajax({
   type: “GET”,
   contentType: “application/json; charset=utf-8”,
   datatype: “json”,
   url: serverUrl + ODATA_ENDPOINT + “/” + odataSetName + “(guid’” + id + “‘)”,
   beforeSend: function (XMLHttpRequest) {
   //Specifying this header ensures that the results will be returned as JSON.
   XMLHttpRequest.setRequestHeader(“Accept”, “application/json”);
   },
   success: function (data, textStatus, XmlHttpRequest) {
   if (successCallback) {
   successCallback(data.d, textStatus, XmlHttpRequest);
   }
   },
   error: function (XmlHttpRequest, textStatus, errorThrown) {
   if (errorCallback)
   errorCallback(XmlHttpRequest, textStatus, errorThrown);
   else
   errorHandler(XmlHttpRequest, textStatus, errorThrown);
   }
   });
   }

   function errorHandler(xmlHttpRequest, textStatus, errorThrow) {
   alert(“Error : ” + textStatus + “: ” + xmlHttpRequest.statusText);
   }

   function retrieveAccount(id) {

   //alert(“ACTION: Retrieving Account with id: ” + id.toString());

   retrieveRecord(id, “AccountSet”, retrieveAccountCompleted, null);
   }

   function retrieveAccountCompleted(data, textStatus, XmlHttpRequest) {

   //Get back the Account JSON object
   //var account = data;
   //alert(“Account retrieved: account name = \”” + account.Name + “\”, id = {” + account.AccountId + “}”);

   //NEXT STEP: Update the Account
   //updateAccount(account.AccountId);
   }

   function getLocation()
   {

   var lookupObject = Xrm.Page.getAttribute(“regardingobjectid”);

   if (lookupObject != null)
   {

   var lookUpObjectValue = lookupObject.getValue();

   if ((lookUpObjectValue != null))
   {

   var doctorlookuptextvalue = lookUpObjectValue[0].name;

   var doctorlookupid = lookUpObjectValue[0].id;

   }

   }

   retrieveAccount(doctorlookupid);
   }

   I am getting a error that $ is undefined . Can you suggest me what is the wrong here ?

   Reply
   1. 

      Jaques Els

      February 23, 2012

      you need to copy json2.js and jquery-1.4.1.js into the web resources and add to your Form Libraries.

      Reply
      1. 

         nmathur

         February 25, 2012

         Hi Jaques, I have a issue and hope you or someone else can help me with that.

         Last month I created a webresource to retrieve data using oData endpoint filter, added json2.js and jquery-1.4.1.min.js. It was working fine.

         uri was : http://…../AccountSet?$filter= address1_city eq Jaipur

         Yesterday I tried oData endpoint to retrieve account by id:
         http://…../Account(Guid’xxxxxxxx’)
         also added json2.js and jquery-1.4.1.min.js., but this time I get undefined in result for data.d.fieldname.

         Then I tried json2.js and jquery-1.4.1.js, and this time my code was working fine.

         So can you please tell me what is the difference between jquery-1.4.1.min.js and jquery-1.4.1.js, and why jquery-1.4.1.min.js is not working when I am retrieving single record.

         Thanks in advance.

4. 

   nmathur

   February 25, 2012

   nmathur :
   Hi Jaques, I have a issue and hope you or someone else can help me with that.
   Last month I created a webresource to retrieve data using oData endpoint filter, added json2.js and jquery-1.4.1.min.js. It was working fine.
   uri was : http://…../AccountSet?$filter= address1_city eq Jaipur
   Yesterday I tried oData endpoint to retrieve account by id:
   http://…../Account(Guid’xxxxxxxx’)
   also added json2.js and jquery-1.4.1.min.js., but this time I get undefined in result for data.d.fieldname.
   Then I tried json2.js, jquery-1.4.1.min.js and jquery-1.4.1.js, and this time my code was working fine.
   So can you please tell me what is the difference between jquery-1.4.1.min.js and jquery-1.4.1.js, and why jquery-1.4.1.min.js and json2.js are not working when I am retrieving single record.
   Thanks in advance.

   Reply
5. 

   nmathur

   February 25, 2012

   nmathur :
   sorry forgot to mention, jquery.1.4.1.min.js was also there with json2.js and jquery.1.4.1.js

   Reply
6. 

   Prasun

   February 25, 2012

   Hello All,

   I have the below query where I read a custom field location from the parent form (Contact) using JQuery . I am trying to get the parent customer id of contact also using the same way . However I am not able to get it . In the alert I get a object . But dont know how to get the id , name or entitytypename of the object .

   Could you help me ?

   function retrieveContactReqCallBack(retrieveContactReq) {
   if (retrieveContactReq.readyState == 4 /* complete */) {
   if (retrieveContactReq.status == 200) {
   //Success

   var retrievedContact = JSON.parse(retrieveContactReq.responseText).d;

   alert(retrievedContact.ParentCustomerId);
   Xrm.Page.getAttribute(“location”).setValue(retrievedContact.insyweb_Location);

   Xrm.Page.getAttribute(“insyweb_Location”).setValue(retrievedContact.ParentCustomerId);

   }
   else {
   //Failure
   errorHandler(retrieveContactReq);
   alert(“retrieveContactReqCallBack function failure END”);
   }
   }
   }

   Thanks,
   Prasun

   Reply
7. 

   Rajeev Pentyala

   February 26, 2012

   Hi Prasun,
   Please try this
   function retrieveReqCallBack(retrieveReq) {
   if (retrieveReq.readyState == 4 /* complete */) {
   var retrieved = this.parent.JSON.parse(retrieveReq.responseText).d;
   var EmailAddress = retrieved.results[0].EMailAddress1;
   alert(EmailAddress);
   }
   }

   ** Make sure field names are same as scehema names.
   Tip :- If you have Query Designer read the names from that

   Reply
   1. 

      Jaques

      March 7, 2012

      I am trying to Qualify/Disqualfy (Set State in Lead using Java Script) I am not successful… can you please help

      var requestMain = “”
      requestMain += “”;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” EntityMoniker”;
      requestMain += ” “;
      requestMain += ” ” + target + ““;
      requestMain += ” ” + entityName + ““;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” State”;
      requestMain += ” “;
      // requestMain += ” 1“;
      requestMain += ” ” + stateValue + ““;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” Status”;
      requestMain += ” “;
      requestMain += ” ” + statusCodeValue + ““;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” SetState“;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += ” “;
      requestMain += “”;

      var serverUrl = _getServerUrl();
      var req = new XMLHttpRequest();
      req.open(“POST”, serverUrl, false)
      // Responses will return XML. It isn’t possible to return JSON.
      req.setRequestHeader(“Accept”, “application/xml, text/xml, */*”);
      req.setRequestHeader(“Content-Type”, “text/xml; charset=utf-8”);
      req.setRequestHeader(“SOAPAction”, “http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Execute”);
      var successCallback = null;
      var errorCallback = null;
      req.onreadystatechange = function () {
      setStateResponse(req);
      //SetStateResponse(req, successCallback, errorCallback);
      };
      req.send(requestMain);

      }

      function setStateResponse(req) {

      //Xrm.Page.data.entity.save();
      //Xrm.Page.data.entity.save(“SaveAndClose”);

      debugger;
      var id = Xrm.Page.data.entity.getId();

      if (req.readyState == 4) {
      if (req.status == 200) {
      //Xrm.Page.data.entity.save(“SaveAndClose”);
      alert(“Success !!!”);
      }
      else {
      //alert(“Error – ” + req.responseXML);
      }
      }
      }

      // This function gets called after the execution
      function SetStateResponse(req, successCallback, errorCallback) {
      debugger;
      if (req.readyState == 4) {
      if (req.status == 200) {
      if (successCallback != null)
      { successCallback(); }
      }
      else {
      errorCallback(_getError(req.responseXML));
      }
      }
      }

      function _getError(faultXml) {
      var errorMessage = “Unknown Error (Unable to parse the fault)”;
      if (typeof faultXml == “object”) {
      try {
      var bodyNode = faultXml.firstChild.firstChild;
      //Retrieve the fault node
      for (var i = 0; i < bodyNode.childNodes.length; i++) {
      var node = bodyNode.childNodes[i];
      //NOTE: This comparison does not handle the case where the XML namespace changes
      if ("s:Fault" == node.nodeName) {
      for (var j = 0; j < node.childNodes.length; j++) {
      var faultStringNode = node.childNodes[j];
      if ("faultstring" == faultStringNode.nodeName) {
      errorMessage = faultStringNode.text;
      break;
      }
      }
      break;
      }
      }
      }
      catch (e) { };
      }
      return new Error(errorMessage);
      }

      Reply