Using Azure Data factory to move data out of Dynamics CRM i am using the Dataverse connector in a copy activity
I specify my fetchXML as such
<fetch>
<entity name="account">
<attribute name="accountid"/>
<attribute name="name"/>
<attribute name="createdby"/>
<attribute name="modifiedby"/>
<attribute name="createdon"/>
<attribute name="modifiedon"/>
<attribute name="ownerid"/>
<attribute name="transactioncurrencyid"/>
<attribute name="owningbusinessunit"/>
<attribute name="emailaddress1"/>
<attribute name="address1_line1"/>
<attribute name="address1_postalcode"/>
<attribute name="address1_city"/>
<attribute name="address1_country"/>
<attribute name="msdyn_serviceterritory"/>
<attribute name="msdyn_workorderinstructions"/>
<attribute name="exchangerate"/>
<link-entity name="stringmap" from="attributevalue" to="statecode" link-type="outer" alias="state">
<attribute name="value" alias="state" />
<filter type="and">
<condition attribute="attributename" operator="eq" value="statecode" />
<condition attribute="langid" operator="eq" value="1033" />
<condition attribute="objecttypecode" operator="eq" value="1" />
</filter>
</link-entity>
<link-entity name="stringmap" from="attributevalue" to="statuscode" link-type="outer" alias="status">
<attribute name="value" alias="status" />
<filter type="and">
<condition attribute="attributename" operator="eq" value="statuscode" />
<condition attribute="langid" operator="eq" value="1033" />
<condition attribute="objecttypecode" operator="eq" value="1" />
</filter>
</link-entity>
<link-entity name="stringmap" from="attributevalue" to="businesstypecode" link-type="outer" alias="businessType">
<attribute name="value" alias="businessType" />
<filter type="and">
<condition attribute="attributename" operator="eq" value="businesstypecode" />
<condition attribute="langid" operator="eq" value="1033" />
<condition attribute="objecttypecode" operator="eq" value="1" />
</filter>
</link-entity>
<link-entity name="stringmap" from="attributevalue" to="address1_addresstypecode" link-type="outer" alias="addressType">
<attribute name="value" alias="addressType" />
<filter type="and">
<condition attribute="attributename" operator="eq" value="address1_addresstypecode" />
<condition attribute="langid" operator="eq" value="1033" />
<condition attribute="objecttypecode" operator="eq" value="1" />
</filter>
</link-entity>
</entity>
This draws data out of the service as expected except I get columns not specified in the fetchXML query
The same query within FetchXML builder in XrmToolBox does not return this extra column
Anyone here know how I can avoid getting this extra column in my result? (It messes up my dynamic mapping in the copy activity)