You’re offline. This is a read only version of the page.
1,562
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.2/" + 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.a != null)
alert(data.accountnumber);
if (data != null && data._primarycontactid_value != null)
alert(data.primarycontactid_value); //for lookup id
} else {
var error = JSON.parse(this.response).error;
alert(error.alert);
}
};
req.send();
}
function getInfo() {
debugger;
var Id = null; //primary Account key (GUID)
try { Id = Xrm.Page.getAttribute('customerid').getValue()[0].id.replace('{', '').replace('}', '');} catch (ex) { Id = null; }
if (Id !== null) {
var entityName = "accounts";
var columnSet = "?$select=customfield"; //list of column that we want to fetch
retrieveEntity(entityName, Id, columnSet);
}
}
output - not getting customelookup_Id value:
[org_url]/api/data/v8.2/$metadata#accounts(name,customelookup_Id,emailaddress1)/$entity",
"@odata.etag":"W/\"5570886\"",
"name":"Test user","emailaddress1":null,
"accountid":"15026883-1642-e311-899e-005056ab004d"
*This post is locked for comments
I have the same question (0)
Hello Tin,
If your custom field is a lookup then you have to select it using the 'lookup pattern' which is:
_fieldname_value
If your custom field's name is 'new_customfieldid' (don't forget the prefix), then the select would be
$select=_new_customfieldid_value
Reference docs:
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/webapi/query-data-web-api#retrieve-data-about-lookup-properties (see section 'Retrieve data about lookup properties')
Share
Report
All responses (
Answers (
