Retrieve multiple records using OData & JQuery in CRM 2011
Hi,
Below are the Jscript functions to retrieve multiple records using OData & JQuery.
function retrieveMultiple(odataSetName, select, filter, successCallback) {
var serverUrl = Xrm.Page.context.getServerUrl();
var ODATA_ENDPOINT = “/XRMServices/2011/OrganizationData.svc”;
var odataUri = serverUrl + ODATA_ENDPOINT + “/” + odataSetName + “?”;
if (select) {
odataUri += “$select=” + select + “&”;
}
if (filter) {
odataUri += “$filter=” + filter;
}
//Asynchronous AJAX function to Retrieve CRM records using OData
$.ajax({
type: “GET”,
contentType: “application/json; charset=utf-8”,
datatype: “json”,
url: odataUri,
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) {
if (data && data.d && data.d.results) {
successCallback(data.d.results, textStatus, XmlHttpRequest);
}
else if (data && data.d) {
successCallback(data.d, textStatus, XmlHttpRequest);
}
else {
successCallback(data, textStatus, XmlHttpRequest);
}
}
},
error: function (XmlHttpRequest, textStatus, errorThrown) {
if (XmlHttpRequest && XmlHttpRequest.responseText) {
alert(“Error while retrieval ; Error – ” + XmlHttpRequest.responseText);
}
}
});
}
function readRecordsOnSuccess(data, textStatus, XmlHttpRequest) {
// Loop through the retrieved records
for (var indx = 0; indx < data.length; indx++) {
alert(“Name – ” + data[indx].name);
}
}
- Copy & Paste above methods to a new .jscript file
- Replace double quotes(“) symbols with your keyboard double quotes
- Add the new .jscript file as web resource to CRM application
- Add “Jquery” & json” helper classes as web resources
How do I call this method :-
- In my sample below, I will show you how to read “Contacts” for an “Account”
function retrieveContactsByAccountId() {
// Pass ‘Contact’ set name since we are reading Contacts
var oDataSetName = “ContactSet”;
// Column names of ‘Contact’ (Pass * to read all columns)
var columns = “FirstName,LastName”;
// Read Account Guid
var accountId = Xrm.Page.data.entity.getId()
// Prepare filter
var filter = “AccountId/Id eq guid'” + accountId + “‘”;
retrieveMultiple(oDataSetName, columns, filter, readRecordsOnSuccess);
}
Note :- Import “ODataQueryDesigner” solution to prepare the Filters easily.
Hope it helps 🙂
Rajeev Pentyala - Microsoft Power Platform 
Hello,
How can i get the optionset value in retrievemultiple?
Thank you 🙂
hello,
i have a mobile CRM application with html5 and javascript. When i execute the project in ie i get the popup for authentification and with google chrome doesn’t work ( no data retrieved).
I wanna to know if there’s a solution to send the authentification parameters in the request??
How to pass multiple account id’s as a filter to retreive their attributes??
Hi,
You can prepare $filter with multiple account id’s by using OR condition and prepare OData URL as below
http://localhost/MyOrgName/xrmservices/2011/OrganizationData.svc/AccountSet?$filter=AccountId eq guid'{Guid1}’ or AccountId eq guid'{Guid2}’ or AccountId eq guid'{Guid1}’
Rajeev,
I’m creating an script to e-mail form entity. I need to retrieve on the field “FROM” the QUEUE based on the field “TO”.
So when i fill the field TO, the script retrieve the contact and auto-complete the field “FROM” with the right Queue. To find the queue in C# i used the queries below: (How can i get in jscript exactly the same result ? Could you help me?)
Contact resultContact = new Contact();
query = new QueryByAttribute(Contact.EntityLogicalName);
query.ColumnSet = new ColumnSet(“firstname”, “contactid”);
query.AddAttributeValue(“emailaddress1”, email.Sender);
var retrieved = service.RetrieveMultiple(query);
resultContact = retrieved.Entities[0].ToEntity();
var queryRecuperaConta = new QueryByAttribute(ava_account_contact.EntityLogicalName);
queryRecuperaConta.ColumnSet = new ColumnSet(“contactid”, “accountid”);
queryRecuperaConta.AddAttributeValue(“contactid”, resultContact.ContactId);
var resultconta = service.RetrieveMultiple(queryRecuperaConta).Entities[0]. ToEntity();
var queryRecuperaConta2 = new QueryByAttribute(Account.EntityLogicalName);
queryRecuperaConta2.ColumnSet = new ColumnSet(“ava_filaid”, “name”, “accountid”);
queryRecuperaConta2.AddAttributeValue(“accoutid”, resultconta.accountid);
var conta = service.RetrieveMultiple(queryRecuperaConta2).Entities[0].ToEntity();
var queryRecuperaFila = new QueryByAttribute(Queue.EntityLogicalName);
queryRecuperaFila.ColumnSet = new ColumnSet { AllColumns = true };
queryRecuperaFila.AddAttributeValue(“queueid”, conta.ava_filaid);
var resultFila = service.RetrieveMultiple(queryRecuperaConta2).Entities[0].ToEntity();
var queryTeam = new QueryByAttribute(Team.EntityLogicalName);
queryTeam.ColumnSet = new ColumnSet { AllColumns = true };
queryTeam.AddAttributeValue(“teamid”, resultFila.OwnerId);
queryTeam.AddAttributeValue(“queueid”, resultFila.QueueId);
var resultTeam = service.RetrieveMultiple(queryTeam).Entities[0].ToEntity();
var FilaPrincipal = resultTeam.QueueId.Name;
Xrm.Page.getAttribute(“from”).setValue(resultQueue.name);