161
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?
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.
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.
Which Dynamics product do you mean?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (