How to get Lookup Details while retrieve or fetch record using XrmServiceToolkit Library

(1) Share

Report

Posted on by Ishan Sharma

314

Hello All,

I have retrieved one Entity record using XrmServiceToolkit. In this entity there is a lookup field(mentioned in filter) also get. Now i want to access particular properties of this Lookup like name, id, entityType ? How can i get all these? basically i think we use the following code to execute the query for Rest:

var result = XrmServiceToolkit.Soap.Retrieve(EntityName,EntityId,col);

and to Retrieve any field value we write the following code,

var x = result.attributes['fieldname'].value; 

here, x can store normal values like single line, whole number etc but in my case the field is lookup 
and i want to access the lookup properties?? If i simply write alert(x) then it shows the error because 
x is referring to Another Record, and I want to simply get the name of that record??

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Ishan,

This is WebApi , so here is how you can achieve it :

http://himbap.com/blog/?p=2077

mark my suggestion as verified if helpful.

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Helo Ishan ,

Try with this . Hope this helps -

var cols = ["new_textfield", "primarycontactid"]; var resultXml = XrmServiceToolkit.Soap.Retrieve(EntityName, EntityId, cols); // Get Lookup Value if (resultXml != null && resultXml.attributes['primarycontactid'] != null) { var lookupValue = new Array(); lookupValue[0] = new Object(); lookupValue[0].id = resultXml.attributes['primarycontactid'].id; lookupValue[0].name = resultXml.attributes['primarycontactid'].name; lookupValue[0].entityType = resultXml.attributes['primarycontactid'].logicalName; Xrm.Page.data.entity.attributes.get("parentcontactid").setValue(lookupValue); } else Xrm.Page.data.entity.attributes.get("parentcontactid").setValue(null);

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report

Hi Ishan,

I am not sure which version of CRM you are using and why you are still depends on XrmServiceToolkit ?

Microsoft introduce XRM method WebApi which uses OData V4 and as well as you can retrieve using rest API using XMLHttpRequest which was already shared by Rawish .

So you don't need to depends on external reference or SDK. So start using XRM method WebAPI or rest API using XMLHttpRequest .

Please have a look below reference -

docs.microsoft.com/.../xrm-webapi

msdn.microsoft.com/.../gg334279.aspx

To create REST API using tool you can download the CRM rest builder and import the solution in your CRM instance which will give you a button in solution area Ribbon. You can easily create your XMLHttpRequest .

github.com/.../CRMRESTBuilder

Hoe this helps

Was this reply helpful? Yes No

Community site session details

How to get Lookup Details while retrieve or fetch record using XrmServiceToolkit Library

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

How to get Lookup Details while retrieve or fetch record using XrmServiceToolkit Library

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates