• Not Answered

Sitecore 9 Mapping with Dynamics CRM thru DAta Exchange Framework with Related Entities

Hi, currently, I am updating an existing connection between Sitecore and Dynamic CRM Thru Data Exchange Framework, the current problem I am facing is that whenever I tried to get a value from a Related Entity, I am getting an error. IS there a way to map items from an account entity and get it's related entity fields? Sample XML I have is:

 

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="account">
<attribute name="name" />
<attribute name="primarycontactid" />
<attribute name="telephone1" />
<attribute name="address1_city" />
<attribute name="erpid" />
<attribute name="industrysectorid" />
<attribute name="subcategoryindustrysectorid" />
<attribute name="emailaddress1" />
<attribute name="ownerid" />
<attribute name="address1_postalcode" />
<attribute name="crmcustomernumber" />
<attribute name="statecode" />
<attribute name="createdon" />
<attribute name="createdby" />
<attribute name="accountid" />
<order attribute="name" descending="false" />
<link-entity name="contact" from="contactid" to="id" visible="false" link-type="outer" alias="contactcontactid">
<attribute name="emailaddress1" />
</link-entity>
<link-entity name="loyaltyscheme" from="account" to="accountid" link-type="inner" alias="aa">
<filter type="and">
<condition attribute="totalnumberofproductregistrations" operator="not-null" />
<condition attribute="fiscalyear" operator="not-null" />
</filter>
</link-entity>
</entity>
</fetch>

 

I am trying to map this entity "totalnumberofproductregistrations" thru Account entity that I have thru Pipeline Batches but no good. Any recommendation or suggestion?