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!

I have the same question (0)

All responses (5)

Answers (0)

Guido Preite 54,086 Moderator on at

Like (0)

Report

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)

Was this reply helpful? Yes No
prasanna05 5 on at

Like (0)

Report

Thank you for the reply. Need in FetchXml as we need to use in SSRS report.

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
prasanna05 5 on at

Like (0)

Report

Thank you. I am not sure how it works, will check.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No