Crud Operation using JQuery
Retrieve Multiple(All)
Retrieve Multiple(All)
$.ajax({
type: "GET",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts",
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
XMLHttpRequest.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
},
async: true,
success: function(data, textStatus, xhr) {
var results = data;
for (var i = 0; i <
results.value.length; i++) {
var accountid =
results.value[i]["accountid"];
}
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus +
" " + errorThrown);
}
});
Retrieve Multiple (All) with Specific
Field
$.ajax({
type: "GET",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts?$select=_createdby_value",
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
XMLHttpRequest.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
},
async: true,
success: function(data, textStatus, xhr) {
var results = data;
for (var i = 0; i <
results.value.length; i++) {
var _createdby_value =
results.value[i]["_createdby_value"];
var _createdby_value_formatted =
results.value[i]["_createdby_value@OData.Community.Display.V1.FormattedValue"];
var
_createdby_value_lookuplogicalname = results.value[i]["_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
}
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus +
" " + errorThrown);
}
});
Retrieve Single
$.ajax({
type: "GET",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts(a8a19cdd-88df-e311-b8e5-6c3be5a8b200)",
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
XMLHttpRequest.setRequestHeader("Prefer", "odata.include-annotations=\"*\"");
},
async: true,
success: function(data, textStatus, xhr) {
var result = data;
var accountid =
result["accountid"];
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus +
" " + errorThrown);
}
});
Retrieve Single with Specific Field
$.ajax({
type: "GET",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts(a8a19cdd-88df-e311-b8e5-6c3be5a8b200)?$select=accountid",
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
XMLHttpRequest.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
},
async: true,
success: function(data, textStatus, xhr) {
var result = data;
var accountid =
result["accountid"];
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus +
" " + errorThrown);
}
});
Create A new Record
var entity =
{};
entity.address1_addressid
= "Pune";
entity.address1_county
= "India";
$.ajax({
type: "POST",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts",
data: JSON.stringify(entity),
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
},
async: true,
success: function(data, textStatus, xhr) {
var uri =
xhr.getResponseHeader("OData-EntityId");
var regExp = /\(([^)]+)\)/;
var matches = regExp.exec(uri);
var newEntityId = matches[1];
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus + "
" + errorThrown);
}
});
Update A Record
var entity =
{};
entity.address1_county
= "mumbai";
$.ajax({
type: "PATCH",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts()",
data: JSON.stringify(entity),
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
},
async: true,
success: function(data, textStatus, xhr) {
//Success - No Return Data - Do
Something
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus + "
" + errorThrown);
}
});
Delete A Record
$.ajax({
type: "DELETE",
contentType: "application/json;
charset=utf-8",
datatype: "json",
url: Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts(5ACCE085-4236-E711-80D6-00505603100A)",
beforeSend: function(XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion",
"4.0");
XMLHttpRequest.setRequestHeader("OData-Version",
"4.0");
XMLHttpRequest.setRequestHeader("Accept",
"application/json");
},
async: true,
success: function(data, textStatus, xhr) {
//Success - No Return Data - Do
Something
},
error: function(xhr, textStatus,
errorThrown) {
Xrm.Utility.alertDialog(textStatus +
" " + errorThrown);
}
});
Associate A Record
Associate A Record
var association =
{ "@odata.id": Xrm.Page.context.getClientUrl() + "/api/data/v8.2/vtv_marketingsources(" + sourceCodeId + ")" }; $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", datatype: "json", url: Xrm.Page.context.getClientUrl() + "/api/data/v8.2/opportunities(" + recordId + ")/vtv_opportunity_vtv_marketingsource/$ref", data: JSON.stringify(association), beforeSend: function (XMLHttpRequest) { XMLHttpRequest.setRequestHeader("OData-MaxVersion", "4.0"); XMLHttpRequest.setRequestHeader("OData-Version", "4.0"); XMLHttpRequest.setRequestHeader("Accept", "application/json"); }, async: true, success: function (data, textStatus, xhr) { Xrm.Page.ui.controls.get("ClubsInvolved").refresh(); }, error: function (xhr, textStatus, errorThrown) { } });
Crud Operation using XMLHTTP
Retrieve Multiple(All)
var req =
new XMLHttpRequest();
req.open("GET",
Xrm.Page.context.getClientUrl() + "/api/data/v8.2/accounts", true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var results =
JSON.parse(this.response);
for (var i = 0; i <
results.value.length; i++) {
var accountid =
results.value[i]["accountid"];
}
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
Retrieve Multiple (All) with Specific
Field
var req =
new XMLHttpRequest();
req.open("GET",
Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts?$select=address1_city", true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var results =
JSON.parse(this.response);
for (var i = 0; i <
results.value.length; i++) {
var address1_city =
results.value[i]["address1_city"];
}
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
Retrieve Single
var req =
new XMLHttpRequest();
req.open("GET",
Xrm.Page.context.getClientUrl() + "/api/data/v8.2/accounts()", true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var result =
JSON.parse(this.response);
var accountid =
result["accountid"];
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
Retrieve Single with Specific Field
var req =
new XMLHttpRequest();
req.open("GET",
Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts()?$select=address1_city", true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.setRequestHeader("Prefer",
"odata.include-annotations=\"*\"");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var result =
JSON.parse(this.response);
var address1_city =
result["address1_city"];
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
Create A new Record
var entity =
{};
entity.address1_city
= "Pune";
var req =
new XMLHttpRequest();
req.open("POST",
Xrm.Page.context.getClientUrl() + "/api/data/v8.2/accounts", true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 204) {
var uri =
this.getResponseHeader("OData-EntityId");
var regExp = /\(([^)]+)\)/;
var matches = regExp.exec(uri);
var newEntityId = matches[1];
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send(JSON.stringify(entity));
Update A Record
var entity =
{};
entity.address2_telephone2
= "999988880";
var req =
new XMLHttpRequest();
req.open("PATCH",
Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts(475b158c-541c-e511-80d3-3863bb347ba8)",
true);
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 204) {
//Success - No Return Data - Do
Something
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send(JSON.stringify(entity));
Delete A Record
var req =
new XMLHttpRequest();
req.open("DELETE",
Xrm.Page.context.getClientUrl() +
"/api/data/v8.2/accounts(5ACCE085-4236-E711-80D6-00505603100A)",
true);
req.setRequestHeader("Accept",
"application/json");
req.setRequestHeader("Content-Type",
"application/json; charset=utf-8");
req.setRequestHeader("OData-MaxVersion",
"4.0");
req.setRequestHeader("OData-Version",
"4.0");
req.onreadystatechange
= function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 204 || this.status
=== 1223) {
//Success - No Return Data - Do
Something
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();