{"id":15362,"date":"2019-04-10T12:01:54","date_gmt":"2019-04-10T12:01:54","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=15362"},"modified":"2021-12-06T14:55:38","modified_gmt":"2021-12-06T09:25:38","slug":"retrieval-of-many-to-many-nn-relationship-records-using-web-api-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/04\/retrieval-of-many-to-many-nn-relationship-records-using-web-api-dynamics-365\/","title":{"rendered":"Retrieval of Many-to-Many (N:N) Relationship Records using Web API in Dynamics 365"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

In this blog we will learn to retrieve Dynamic CRM entity records in respect of Many to Many relationships between two Dynamic CRM entities (OOB\/Custom).<\/p>\n

So let\u2019s take a look at the following example:<\/p>\n

In the below screeshot, there is one Many-to-Many relationship present between Account and Territory Entity of Dynamic CRM.<\/p>\n

\"Web<\/p>\n

One Territory entity subgrid is added to the Account entity form.<\/p>\n

\"Web<\/p>\n

So, now we need to retrieve Account entity records which are associated with the three territories shown in the above screenshot (i.e California, Nevada, New York). For this, we need to first prepare the fetchXml query for retrieving the Account entity records.<\/p>\n

<fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”true”><\/p>\n

<entity name=”account”><\/p>\n

<attribute name=”name” \/><\/p>\n

<order attribute=”name” descending=”false” \/><\/p>\n

<link-entity name=”new_account_territory_entity_name” from=”accountid” to=”accountid”\u00a0\u00a0\u00a0 visible=”false” intersect=”true”><\/p>\n

<link-entity name=”territory” from=”territoryid” to=”territoryid” alias=”ab”><\/p>\n

<filter type=”and”><\/p>\n

<filter type=”or”><\/p>\n

<condition attribute=”name” operator=”eq” value=”Nevada” \/><\/p>\n

<condition attribute=”name” operator=”eq” value=”New York” \/><\/p>\n

<\/filter><\/p>\n

<\/filter><\/p>\n

<attribute name=”name” \/><\/p>\n

<attribute name=”territoryid” \/><\/p>\n

<\/link-entity><\/p>\n

<\/link-entity><\/p>\n

<\/entity><\/p>\n

<\/fetch><\/p>\n

 <\/p>\n

Note:<\/strong><\/p>\n

new_account_territory_entity_name: It is defined as IntersectEntityName which you can get from N:N relationship record as shown in the screenshot below.<\/strong><\/p>\n

accountid:\u00a0 It is defined as Entity1IntersectAttribute attribute which you can get from N:N relationship record.<\/strong><\/p><\/blockquote>\n

\"Web<\/p>\n

Now run this fetchXml query using Web API.<\/p>\n

\/\/create AJAX request<\/p>\n

Maplytics_jQ.ajax({<\/p>\n

type: “GET”,<\/p>\n

contentType: “application\/json; charset=utf-8”,<\/p>\n

datatype: “json”,<\/p>\n

\/\/async: false,<\/p>\n

url: this.getWebAPIPath() + entitySetName + “?fetchXml=” + fetchXml,<\/p>\n

beforeSend: function (xhr) {<\/p>\n

\/\/Specifying this header ensures that the results will be returned as JSON.<\/p>\n

xhr.setRequestHeader(“Accept”, “application\/json”);<\/p>\n

xhr.setRequestHeader(“Content-Type”, “application\/json; odata.metadata=minimal”);<\/p>\n

xhr.setRequestHeader(“OData-MaxVersion”, “4.0”);<\/p>\n

xhr.setRequestHeader(“OData-Version”, “4.0”);<\/p>\n

xhr.setRequestHeader(“Prefer”, “odata.include-annotations=*”);<\/p>\n

},<\/p>\n

success: function (data, textStatus, xhr) {<\/p>\n

 <\/p>\n

},<\/p>\n

error: function (xhr, textStatus, errorThrown) {<\/p>\n

retrieveUsingFetchError(Inogic.Maplytics.ApiLib.errorHandler(xhr));<\/p>\n

}<\/p>\n

});<\/p>\n

Conclusion<\/strong><\/h2>\n

The above query will help to retrieve Account records which are associated with three territories records (i.e Nevada, New York, California).<\/p>\n

One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n

Get optimum visualization of Dynamics 365 CRM data with –<\/em>
\nKanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
\nMap My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In this blog we will learn to retrieve Dynamic CRM entity records in respect of Many to Many relationships between two Dynamic CRM entities (OOB\/Custom). So let\u2019s take a look at the following example: In the below screeshot, there is one Many-to-Many relationship present between Account and Territory Entity of Dynamic CRM. One Territory\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":15366,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[18,19,65],"tags":[1823],"class_list":["post-15362","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365-v9-2","category-dynamics-crm","category-webapi","tag-web-api-in-dynamics-365"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/15362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=15362"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/15362\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/15366"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=15362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=15362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=15362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}