CRM FetchXML Parent Company Name Attribute

(1) Share

Report

Posted on by Community Member

Hi all,

i simply try to get the Company Name from XML but it doesn't work for me. My FetchXML looks like this. What is the correct attribute to get the company name?

*This post is locked for comments

All responses (6)

Answers (2)

gdas 50,091 Moderator on at

Like (0)

Report

RE: CRM FetchXML Parent Company Name Attribute

This is not the right answers you verified.
gdas 50,091 Moderator on at

Like (0)

Report

RE: CRM FetchXML Parent Company Name Attribute

Please close the thread by verifying any of above answer so that in future people can get help with this thread.
Verified answer

Mick_4711 552 on at

Like (1)

Report

RE: CRM FetchXML Parent Company Name Attribute

Hey Dario,

You can download the XRMToolBox and start FetchXML Builder.

With this tool you can check the FetchXML and its output(s).

What do wanna do exactly?
Community Member on at

Like (0)

Report

RE: CRM FetchXML Parent Company Name Attribute

hi goutam,

thank you for your reply. that sounds like rocket science for me :-) i am not very familiar with programming. maybe i have to outsouce that task.

kind regards
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report

RE: CRM FetchXML Parent Company Name Attribute

Hi ,

As already suggested above from "parentcustomerid" lookup normally for any contact parent account or company name. As "parentcustomerid" field is lookup you need to retrieve name from once results will retrieve using name property.

You can refer below references how to retrieve using C# .

arunpotti.wordpress.com/.../retrieve-records-using-query-expression-c-sdk-in-crm

arunpotti.wordpress.com/.../retrieve-records-using-fetchxml-c-sdk-in-crm

If you are using JavaScript then you can write web api query instead of Fetch XML as well .

syednizamsyed.blogspot.com/.../query-data-using-web-api.html

Please share your code if you are still facing issue.
Suggested answer

Sreevalli 3,256 on at

Like (2)

Report

RE: CRM FetchXML Parent Company Name Attribute

Hi,

"parentcustomerid" is right field for Company Name out of box field of Contact. which you already using.

but since it is Customer field, if you are trying to find contact and the existing data is account or vise versa then it will return null value. please check and target for right entity based on data.

also share us how you are using the above fetch - Console/JS etc.