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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Itz_Me_Ram 155 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
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(); }

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

Hi ,

Did you tried with this which I shared above ?

Was this reply helpful? Yes No
Suggested answer

Itz_Me_Ram 155 on at

Like (0)

Report

Yes i tried..it is an environment issue. Thank you!!

Was this reply helpful? Yes No
Aarti Parpiyani 20 on at

Like (0)

Report

@Itz_Me_Ram Is it because of the latest update?

Was this reply helpful? Yes No