Writing Retrieve Method Using Web API

Mahender Pal
8y
26.8k
0
1

Article

With the release of Dynamics CRM 2016, organization data services is depreciated, so going forward we need to make sure to write scripting code using Web API only. Web API implements OData V4 and can be used for any operation that we can do using organization service, so now we can use Web API to get both data and metadata. In this article, we are providing retrieve method sample code

To use Web API we need to use URL like the following:

[Organization URI] +”/api/data/v8.0/”

Let’s take an example we want to retrieve entity specific attributes based on primary entity id, so we can create script web resource and use the following code:

function retrieveEntity(entityname,id, columnset) {
var serverURL = Xrm.Page.context.getClientUrl();
var Query = entityname+ "(" + id + ")" + columnset;
var req = new XMLHttpRequest();
req.open("GET", serverURL + "/api/data/v8.0/" + Query, 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 /* complete */ ) {
req.onreadystatechange = null;
if (this.status == 200)//to verify result is OK {
var data = JSON.parse(this.response);
if(data!=null && data.accountnumber!=null)
alert(data.accountnumber);
} else {
var error = JSON.parse(this.response).error;
alert(error.message);
}
}
};
req.send();
}

We can consume this method using following code:

var Id=entityid; //primary key (GUID) , make sure you are passing GUID without {}
var entityName="accounts";
var columnSet="?$select=accountnumber,address1_city"; //list of column that we want to fetch
retrieveEntity(entityName,Id,columnSet);