While extending Dynamics CRM, retrieving entity information is a very common programming requirement whether we are working with Forms, SDK Plugins or Workflow Custom Assemblies or ASP.Net extensions. In the following sample code we will retrieve entity information by Entity Id via Jscript (can be used in Entity Forms, CRM HTML web resource etc.) and C # code (can be used with in SDK Plugins, Workflow Custom Assemblies, Asp.Net etc.)
Updated Code for Retrieving Lookup Attribute Values
[Jscript Code]
|
// Only make changes to this function; you may add this function to Form Onload Event, |
// Field OnChange events etc. |
function GetDetails() { |
|
var EntityName, EntityId, AccountNumber, AccountEmailAddress, LookupFieldObject; |
var PrimaryContactLookupId, PrimaryContactLookupName, PrimaryContactLookupType; |
var resultXml; |
|
LookupFieldObject = Xrm.Page.data.entity.attributes.get('parentcustomerid'); |
|
// If lookup field has value then the code will only run |
if (LookupFieldObject.getValue() != null) { |
|
//Fetch and place Entity Id (GUID) and Name (String) form lookup field into local variables |
EntityId = LookupFieldObject.getValue()[0].id; |
EntityName = LookupFieldObject.getValue()[0].entityType; |
|
// Paramter explaination for function call |
// RetrieveEntityById('account', AccountId, 'accountnumber,emailaddress1'); |
|
// 1st paramter requires entity name (not display or schema name) just pass it in a string |
// i.e. for Account entity use 'account' for opportunity entity use 'opportunity' |
|
// 2nd paramter requires entity Id (GUID Type) field which we have retrieved and stored in |
// AccountId local variable |
|
// 3rd paramter requires attributes to be retrieved schema name, if thrid attributed is |
// required to be retrieved then use like: i.e. 'accountnumber,emailaddress1,telephone2' |
|
resultXml = RetrieveEntityById(EntityName, EntityId, 'accountnumber,emailaddress1,primarycontactid'); |
|
// In retrieved XML document check if it has accountnumber attribute |
if (resultXml != null && resultXml.selectSingleNode('//q1:accountnumber') != null) { |
|
// If XML document has account number attribute then assign to local variable AccountNumber |
AccountNumber = resultXml.selectSingleNode('//q1:accountnumber').nodeTypedValue; |
|
//Display Account Number Value in a Message Box |
alert("Account Number :" + AccountNumber); |
|
//If required then use the below code line to set value in field on form |
//Xrm.Page.data.entity.attributes.get('new_myaccountnumber').setValue(AccountNumber); |
} |
|
// In retrieved XML document check if it has emailaddress1 attribute |
if (resultXml != null && resultXml.selectSingleNode('//q1:emailaddress1') != null) { |
|
// If XML document has account number attribute then assign to local variable AccountEmailAddress |
AccountEmailAddress = resultXml.selectSingleNode('//q1:emailaddress1').nodeTypedValue; |
|
alert("Email Address :" + AccountEmailAddress); |
|
//If required then use the below code line to set value in field on form |
//Xrm.Page.data.entity.attributes.get('new_myemailaddress').setValue(AccountEmailAddress); |
} |
|
// In retrieved XML document check if it has primarycontactid lookup attribute |
if (resultXml != null && resultXml.selectSingleNode('//q1:primarycontactid') != null) { |
|
// If XML document has primarycontactid lookup attribute then assign to local variable |
PrimaryContactLookupId = resultXml.selectSingleNode('//q1:primarycontactid').nodeTypedValue; |
|
// If XML document has primarycontactid lookup attribute then assign to local variable |
PrimaryContactLookupName = resultXml.selectSingleNode('//q1:primarycontactid').getAttribute("name"); |
|
// If XML document has primarycontactid lookup attribute then assign to local variable |
PrimaryContactLookupType = resultXml.selectSingleNode('//q1:primarycontactid').getAttribute("type") ; |
|
alert("Primary Contact Lookup Id :" + PrimaryContactLookupId); |
|
alert("Primary Contact Lookup Name :" + PrimaryContactLookupName); |
|
alert("Primary Contact Lookup Type :" + PrimaryContactLookupType); |
|
} |
|
} |
} |
|
// Do not make any changes to this function |
function RetrieveEntityById(prmEntityName, prmEntityId, prmEntityColumns) { |
|
var resultXml, errorCount, msg, xmlHttpRequest, arrayEntityColumns, xmlEntityColumns; |
|
arrayEntityColumns = prmEntityColumns.split(","); |
|
for (var i = 0; i < arrayEntityColumns.length; i++) { |
xmlEntityColumns += "<q1:Attribute>" + arrayEntityColumns[i] + "</q1:Attribute>"; |
} |
|
var authenticationHeader = Xrm.Page.context.getAuthenticationHeader(); |
|
//Prepare the SOAP message. |
var xml = "<?xml version='1.0' encoding='utf-8'?>" + |
"<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'" + |
" xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'" + |
" xmlns:xsd='http://www.w3.org/2001/XMLSchema'>" + |
authenticationHeader + |
"<soap:Body>" + |
"<Retrieve xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>" + |
"<entityName>" + prmEntityName + "</entityName>" + |
"<id>" + prmEntityId + "</id>" + |
"<columnSet xmlns:q1='http://schemas.microsoft.com/crm/2006/Query' xsi:type='q1:ColumnSet'>" + |
"<q1:Attributes>" + |
xmlEntityColumns + |
"</q1:Attributes>" + |
"</columnSet>" + |
"</Retrieve></soap:Body></soap:Envelope>"; |
|
//call function to create Soap Request to ms crm webservice |
xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP"); |
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false); |
xmlHttpRequest.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Retrieve"); |
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8"); |
xmlHttpRequest.setRequestHeader("Content-Length", xml.length); |
xmlHttpRequest.send(xml); |
|
resultXml = xmlHttpRequest.responseXML; |
|
var errorCount = resultXml.selectNodes('//error').length; |
|
if (errorCount != 0) { |
var msg = resultXml.selectSingleNode('//description').nodeTypedValue; |
alert("Error Message : " + msg); |
} |
else { |
return resultXml; |
} |
} |
|
|
very useful article, thank you for posting it.
ReplyDeleteI do have a question though.
On Line 27, you have the code:
Xrm.Page.data.entity.attributes.get('new_myaccountnumber').setValue(AccountNumber);
for updating fields on the page - which works very well. However, how would I update a field that is a lookup?
Example: if I use this code on the QUOTE entity and get the GUID from the Account for OwnerID, how can I update the OwnerID on the QUOTE form with the returned data from the account.
I am looking online for the solution but if you have time to answer, it would be appreciated.
Thanks
Matt
themattpod@gmail.com
Hi,
ReplyDeleteYou set the value in Owner Field using the following code below:
var lookupData = new Array();
//Create an Object add to the array.
var lookupItem = new Object();
//Set the id, typename, and name properties to the object.
// Make sure to replace UserId variable with User GUID value or assign User GUID to it
lookupItem.id = UserId;
lookupItem.typename = "systemuser";
// Make sure to replace UserName variable with User Name value or assign User Name to it
lookupItem.name = UserName;
// Add the object to the array.
lookupData[0] = lookupItem;
// Set the value of the lookup field to the value of the array.
Xrm.Page.getAttribute("ownerid").setValue(lookupData);
Hi, It's really helpful article thanks for posting . However wanted to ask you that i want to retrieve the values tax on invoice entity by selecting the price list from look up view and on price list there is another look up view which will give me the rate of tax on invoice entity. So i am a little confused on retrieving values from double look up view. so please can you guide me? thanks
ReplyDeleteI think I'm in love with you. This has helped me soooo much !
ReplyDeleteI am glad that it helps you :)
DeleteHi,
ReplyDeleteinstead of parsing the responce xml "by hand" you could use one of the following libraries:
- CrmRestKit.js (OData)[http://crmrestkit.codeplex.com/]
- CrmFetchKit.js (SOAP) [http://crmfetchkit.codeplex.com/]
Daniel
Hi Daniel,
ReplyDeleteThank you for posting the links to the kits :), this post is little older, was published on June, 2011 and the purpose was to help understanding the SOAP Retrieve request.
Thank you very much , the code works like cream and excellent explantion.
ReplyDeleteQuery-
I created a custome entity new_contact on Lead form in order to fetch required field value(Email,telephone) from Contact to Lead.
I am tryiing to get the values of a Parent Customer(lookup) from Contact entity to Lead Entity in Company Name(Text).
The Schema name for Parent Customer is parentcustomerid, which is a guid value. How can we get the Value in Text?
Thanks in Advance.
Thank you very much for the post, it works fine.
ReplyDeleteIf i have optionset, then i am getting its' value not the lable.
could you please show me how to display optionset label.
Thanks
Hello Jehanzeb Javeed ,
ReplyDeleteThank you very much for your post .Saved me a ton of work .However ,this seems to be working on IE only .Other browsers seem not to support this .Any modifications that could assist ?
Regards,
Patrick Mwangi
good post but dont work in cross browser
ReplyDeleteI am new to CRM and I have a question on how to auto populate text from lookup value.
I went through many forum, and got solution for 2 entites, but i am looking for 4 entities mentioned below:
In our CRM instance, there are 4 entities mentioned below:
Case
Location
Finance Region Location
Finance Region
Case has N:1 Relationship with Location and Finance Region.
Location has 1:N relationship with Finance Region Location.
Finance Region Location has N:1 relationship with Finance Region.
When user select one value in Location lookup in case form, Finance Region should be auto populate
for example: if user enter asia as location, in finance region field(Read only text box) APAC as finance Region should be autopopulate.
Could you please let me know help to write javascript code to autopopulate Finance Region text box Please help me out
Thanks in advance
good post but don't work with CRM 2013
ReplyDeletegood post but don't work with CRM 2013
ReplyDeleteHi, Jehanzeb Javeed. Good post! I interested to know more about Dynamics CRM plus my company currently want to use Microsoft Dynamics CRM and I am who discharge to learn it. If you don't mind and have any free time, can you teach me a little bit about CRM?
ReplyDeleteActually, I have one issue. I already google it and post a few questions in forum, but still can't solve one of my issue. The issue is I want to pass a parameter from one field in form to another form for validation. For example, field minimum sales price in Product form need to pass to Price List Item form to validate either the sales price less or greater than minimum sales price. I already solve to get the value of sales price in Price List Item form but still can't get the value for pass parameter.
The situation is first, I fill the Product form and insert the minimum sales price. Then, I save it. After that, the button '+' in grid at Product form come out then I insert the price in Price List Item. So, I need to pass the value of minimum sales price when user click '+' button. When I write in the forum, they ask me to do a mapping between two forms. Yesterday, I did mapping for both of forms but when I test it, it seem like I can't modify the value of sales price. Can you help me on how to solve this issue?
ralph lauren outlet
ReplyDeletemichael kors handbags
coach factory outlet
michael kors outlet
toms outlet
michael kors outlet
nike basketball shoes
louis vuitton
adidas nmd
coach factory outlet
rolex submariner
kobe bryant shoes
louis vuitton
coach outlet
coach outlet
air jordan 13
nike trainers
ralph lauren polo
louis vuitton outlet
kobe bryant shoes
louis vuitton outlet
ray ban sunglasses outlet
louis vuitton handbags
toms shoes
jordan 11s
air jordan pas cher
michael kors handbags
true religion
kate spade
michael kors outlet
celine
coach outlet online
nike free run
louis vuitton outlet
michael kors outlet
ralph lauren polo
adidas shoes
louis vuitton handbags
ray-ban sunglasses
oakley sunglasses
20167.19wengdongdong
replica watches, christian louboutin outlet, nike air max, nike roshe run, jordan shoes, louis vuitton, longchamp outlet, michael kors, louis vuitton outlet, longchamp pas cher, nike free, louboutin pas cher, ray ban sunglasses, louboutin outlet, oakley sunglasses, longchamp outlet, air max, kate spade outlet, nike air max, uggs on sale, sac longchamp, polo ralph lauren outlet, louboutin shoes, ugg boots, tory burch outlet, prada handbags, cheap oakley sunglasses, burberry, tiffany and co, oakley sunglasses, tiffany jewelry, ray ban sunglasses, ray ban sunglasses, ralph lauren pas cher, longchamp, oakley sunglasses, louis vuitton outlet, replica watches, louis vuitton, louboutin, oakley sunglasses, ugg boots, gucci outlet, nike free, polo ralph lauren outlet, air jordan pas cher, nike outlet, prada outlet, chanel handbags, louis vuitton
ReplyDeletemichael kors, nike free run uk, ray ban pas cher, nike air max, michael kors, coach outlet, michael kors outlet, converse pas cher, north face, lululemon, nike air max, lacoste pas cher, ralph lauren uk, ugg boots, nike roshe, ugg boots, nike blazer, new balance pas cher, burberry, mulberry, ray ban uk, hogan, tn pas cher, vanessa bruno, vans pas cher, true religion jeans, replica handbags, north face, burberry outlet online, oakley pas cher, air force, hollister pas cher, michael kors outlet, coach purses, michael kors, hermes, michael kors outlet, sac guess, kate spade handbags, abercrombie and fitch, true religion jeans, michael kors, true religion outlet, nike air max, timberland, hollister, michael kors outlet, michael kors outlet, true religion jeans, coach outlet
ReplyDeletelancel, jimmy choo shoes, chi flat iron, new balance, vans, celine handbags, asics running shoes, gucci, converse, soccer jerseys, vans shoes, north face outlet, ralph lauren, reebok shoes, herve leger, nike roshe, timberland boots, ferragamo shoes, nfl jerseys, beats by dre, abercrombie and fitch, birkin bag, hollister, mac cosmetics, soccer shoes, lululemon, ghd, iphone cases, hollister, valentino shoes, longchamp, instyler, p90x workout, oakley, mcm handbags, ray ban, nike air max, babyliss, hollister, north face outlet, bottega veneta, nike trainers, insanity workout, baseball bats, louboutin, nike huarache, wedding dresses, nike air max, mont blanc, converse outlet
ReplyDeletecanada goose outlet, canada goose, replica watches, louis vuitton, montre pas cher, canada goose, doudoune canada goose, juicy couture outlet, swarovski crystal, moncler, bottes ugg, louis vuitton, canada goose, pandora jewelry, toms shoes, louis vuitton, ugg pas cher, swarovski, karen millen, juicy couture outlet, moncler, pandora charms, canada goose uk, links of london, canada goose outlet, wedding dresses, marc jacobs, pandora charms, hollister, ugg boots uk, moncler, moncler, moncler, moncler outlet, pandora jewelry, ugg,ugg australia,ugg italia, louis vuitton, supra shoes, sac louis vuitton pas cher, moncler, moncler, canada goose, coach outlet, ugg,uggs,uggs canada, thomas sabo
ReplyDeletehttp://www.prokr.net/2016/09/tanks-isolation-companies-4.html
ReplyDeletehttp://www.prokr.net/2016/09/tanks-isolation-companies-3.html
http://www.prokr.net/2016/09/tanks-isolation-companies-2.html
http://www.prokr.net/2016/09/tanks-isolation-companies.html
goyard
ReplyDeleteyeezy
yeezy shoes
balenciaga
golden goose sneakers
yeezys
golden goose
golden goose
lebron shoes
ReplyDeletegolden goose shoes
jordan shoes
kobe sneakers
hermes online
retro jordans
golden goose outlet
moncler jackets
jordan shoes
golden goose sneakers
There is definately a great deal to learn about this subject. I really like all of the points you have made.|
ReplyDelete토토사이트
Greetings! Very useful advice within this
ReplyDeletearticle! It’s the little changes that make the greatest changes.
Thanks a lot for sharing! 스포츠토토
Excellent web site. Lots of useful info here. I am sending it to a few friends ans also sharing in delicious. And naturally, thank you in your effort!| 온라인카지노
ReplyDelete카지노사이트 It’s really a great and helpful piece of info. I’m glad that you just shared this useful information with us. Please keep us up to date like this. Thank you for sharing.
ReplyDeleteThat is a great tip particularly to those new to the blogosphere.
ReplyDeleteSimple but very accurate info? Thank you for sharing this one.
A must read post!
Appreciating the hard work you put into your site and detailed information you present.
Wonderful read!
토토사이트
CasinoMecca
ReplyDelete