WebApi cannot retrieve lookuplogicalname

(0) Share

Report

Posted on by Itz_Me_Ram

155

I'm trying to access logical name of the entity referenced by the lookup but for some reason the response doesn't contain Microsoft.Dynamics.CRM.lookuplogicalname property.

sts_origmeeting is a lookup to appointment entity. As appointment can be created from contact/account. i'm trying to access the lookuplogicalname but i don't see this in the response. Please suggest me a solution to access lookuplogicalname.

function TestApp()
{
	var serverURL = Xrm.Page.context.getClientUrl();
	var origmeetingvalue = window.parent.Xrm.Page.getAttribute("sts_origmeeting").getValue();
	var appid = origmeetingvalue[0].id.toString();
	appid = appid.replace('{', '');
	appid = appid.replace('}', '');
	var req = new XMLHttpRequest();
	req.open("GET",
	Xrm.Page.context.getClientUrl() +
		"/api/data/v8.1/appointments(" + appid + ")?$select=_regardingobjectid_value",
	false);
	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.setRequestHeader("Prefer", "odata.maxpagesize=10");
	req.onreadystatechange = function ()
	{
		if (this.readyState == 4 /* complete */ )
		{
			req.onreadystatechange = null;
			if (this.status == 200)
			{
				var data = JSON.parse(this.response);
                alert(data.value[0]["_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname"]);
			}
			else
			{
				var error = JSON.parse(this.response).error;
				alert(error.message);
			}
		}
	};
	req.send();
}

*This post is locked for comments

All responses (6)

Answers (1)

Aarti Parpiyani 20 on at

Like (0)

Report

RE: WebApi cannot retrieve lookuplogicalname

@Itz_Me_Ram Is it because of the latest update?
Suggested answer

Itz_Me_Ram 155 on at

Like (0)

Report

RE: WebApi cannot retrieve lookuplogicalname

Yes i tried..it is an environment issue. Thank you!!
gdas 50,089 Moderator on at

Like (0)

Report

RE: WebApi cannot retrieve lookuplogicalname

Hi ,

Did you tried with this which I shared above ?
Verified answer

gdas 50,089 Moderator on at

Like (0)

Report
RE: WebApi cannot retrieve lookuplogicalname

Hi ,

Try to do like below , its should work ,

function TestApp() { var serverURL = Xrm.Page.context.getClientUrl(); var origmeetingvalue = window.parent.Xrm.Page.getAttribute("sts_origmeeting").getValue(); var appid = origmeetingvalue[0].id.toString(); appid = appid.replace('{', ''); appid = appid.replace('}', ''); var req = new XMLHttpRequest(); req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.1/appointments?$select=activityid,actualend,actualstart,_regardingobjectid_value&$filter=activityid eq "+appid+"", 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 activityid = results.value[i]["activityid"]; var actualend = results.value[i]["actualend"]; var actualstart = results.value[i]["actualstart"]; var _regardingobjectid_value = results.value[i]["_regardingobjectid_value"]; var _regardingobjectid_value_formatted = results.value[i]["_regardingobjectid_value@OData.Community.Display.V1.FormattedValue"]; var _regardingobjectid_value_lookuplogicalname = results.value[i]["_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname"]; alert(_regardingobjectid_value_lookuplogicalname); } } else { Xrm.Utility.alertDialog(this.statusText); } } }; req.send(); }
Itz_Me_Ram 155 on at

Like (0)

Report

RE: WebApi cannot retrieve lookuplogicalname

I tried using Rest builder.I can see _regardingobjectid_value in the response.But data[_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname] is undefined.
Suggested answer

gdas 50,089 Moderator on at

Like (0)

Report

RE: WebApi cannot retrieve lookuplogicalname

Why don't you generate your code using CRMRestBuilder. You will get auto generate code.

www.youtube.com/watch

You can also check here for sample code-

community.dynamics.com/.../900404

community.dynamics.com/.../899799