Microsoft Dynamics 365 | Integration, Dataverse...

Pull query based on two entities

(0) Share

Report

Posted on by RyeTeacher

163

I need to pull a query of all contacts with a Parent contact type and a role from the connections table of primary contact. Is there an easy way to pull queries like this in Dynamics? In SQL I could just write a query. Is there something similar in Dynamics?

All responses (3)

Answers (0)

Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report

RE: Pull query based on two entities

Hi RyeTeacher,

If you want to query the data using code, you can use the Web API:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api

Unlike databases, Web APIs can also be used in conjunction with FetchXML, which is a proprietary query language.
Suggested answer

Charan Raju C R 3,155 Super User 2024 Season 1 on at

Like (0)

Report

RE: Pull query based on two entities

If I have understood your requirement correctly, you need to retrieve all the contacts where the relationship with other contacts via Connection Role is 'Parent'. If so, you can build a fetch xml query from advanced find as below -

This fetch xml query can be downloaded and utilized in plug-in or reports based on your requirement.
Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

RE: Pull query based on two entities

Which Dynamics product do you mean?