Qlik MS Dynamics Connector returns more columns for certain attributes

sudeepkm_analog — Fri, 02 Apr 2021 09:10:33 GMT

Hi All,

We are using Qlik Web connector for MS Dynamics and I observed that for certain attributes/columns the connector returns more than one columns. Example: I added "createdby" as an attribute under entity "account" then in the result I got four fields.
createdby_Formatted
createdby_Id
createdby_LogicalName
createdby_Name

Now we are working on getting data from MSD to AzureSQL and then from Azure to onprem DB. Surprisingly I found that for the same attribute "createdby" I'm now getting four columns but different names.
createdby
createdby_entitytype
createdbyname
createdbyyominame

and one of the fields (createdbyname) does not have field values. Has anyone ever come across such issue. Please let me know. Thanks.

topic Qlik MS Dynamics Connector returns more columns for certain attributes in Connectivity & Data Prep

Qlik MS Dynamics Connector returns more columns for certain attributes