Microsoft Dynamics 365 | Integration, Dataverse...

FetchXML Query to get contacts Associated to Accounts

(0) Share

Report

Posted on by prasanna05

Hi All,

Can anyone please help in how to get the top 1 contact associated with each Account. An account can have more than 1 contact so I wanted to get only 1 contact for each account using FetchXml.

Thanks in Advance!

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

RE: FetchXML Query to get contacts Associated to Accounts

Hi prasanna05,

As Guido Preite says, only through fetchxml can't achieve this because "top" or "page" "count" can't work on child record. You could refer to this thread:

https://stackoverflow.com/questions/22096633/auto-numbering-to-parent-and-child-columns

In this thread, he achieved this by indexing the entity record.
prasanna05 5 on at

Like (0)

Report

RE: FetchXML Query to get contacts Associated to Accounts

Thank you. I am not sure how it works, will check.
Guido Preite 54,077 Moderator on at

Like (1)

Report

RE: FetchXML Query to get contacts Associated to Accounts

if you need to use SSRS I would look to apply a filter after you retrieve the dataset, I know it's not ideal but with FetchXML (afaik) is not possible to limit the related records
prasanna05 5 on at

Like (0)

Report

RE: FetchXML Query to get contacts Associated to Accounts

Thank you for the reply. Need in FetchXml as we need to use in SSRS report.
Guido Preite 54,077 Moderator on at

Like (0)

Report

RE: FetchXML Query to get contacts Associated to Accounts

I am not aware of doing it with FetchXML but it can be done with Web API if you apply the $top to the expand with a specific syntax (; instead of &)

the query is something like this:

/api/data/v9.2/accounts?$select=name&$expand=contact_customer_accounts($select=contactid,fullname;$top=1)