Error while loading data using Azure Data Factory (Query Mode)

(0) Share

Report

Posted on by Adnane-K

Hello,

I am trying to incrementally load data from Dynamics 365 CRM to my Azure Database using Data Factory. In the source field I selected query and typed the below code (as a test) , only to be given the following error :

"Dynamics operation failed with error code: -2147217149, error message: 'zt_inscription' entity doesn't contain attribute with Name = 'zt_prixcatalogueht ' and NameMapping = 'Logical'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=366355068,"

When I removed this field it just returned the same error for the column below it and yes I am sure that field exists.

Thanks in advance.

7317.Screenshot.PNG

All responses (1)

Answers (0)

Suggested answer

Adnane-K 5 on at

Like (0)

Report

RE: Error while loading data using Azure Data Factory (Query Mode)

Hello,

I have been playing around with that code and apparently if you remove all attributes it does something similar to SELECT * in SQL

<fetch>

<entity name="zt_inscription">

<filter type="or">

<condition attribute="createdon" operator="on" value="2021-04-06" />

<condition attribute="modifiedon" operator="on" value="2021-04-06" />

</filter>

</entity>

</fetch>