ADF查找活动数据传递到访存xml [英] ADF Lookup Activity data pass into fetch xml

问题描述

将数据从dynamics365复制到sql. 如何传递ADF查找活动输出(表最大日期行数据)导入Fetchxml.

Copying the data from dynamics365 to sql.  How to pass ADF lookup activity output ( table max date row data) into Fetchxml. 

尝试以下代码，但仍会失败.任何建议如何将查找数据传递到fetchxml

Tried with below code, but keep failing.  Any advise how to pass lookup data into fetchxml

< fetch>

错误:

{

"errorCode":"2200.00"，

"errorCode": "2200",

消息":在源"侧发生故障. ErrorCode = UserErrorDynamicsOperationFailed，'类型= Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，消息=动态 操作失败，错误代码:-2147220935，错误消息:"@ activity('Lookup1').output'的日期​​时间格式无效，或者值超出了支持范围..，Source = Microsoft.DataTransfer.ClientLibrary .DynamicsPlugin，"，"failureType": "UserError"，"target":"Copy_rw1" }

"message": "Failure happened on 'Source' side. ErrorCode=UserErrorDynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220935, error message: The date-time format for "@activity('Lookup1').output' is invalid, or value is outside the supported range..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'", "failureType": "UserError", "target": "Copy_rw1" }

查找输出数据

{"firstRow":{"":"2018-08- 07T11:31:40Z"； }，"effectiveIntegrationRuntime":"DefaultIntegrationRuntime(North Europe)" }

推荐答案

@ activity('Lookup1').output存储整个输出数据对象，在您的情况下是 {"firstRow":{ " 2018-08-07T11:31:40Z" }，"effectiveIntegrationRuntime":"DefaultIntegrationRuntime(North Europe)" }.

@activity('Lookup1').output stores the whole output data object, which in your case is, { "firstRow": { "": "2018-08-07T11:31:40Z" }, "effectiveIntegrationRuntime": "DefaultIntegrationRuntime (North Europe)" }.

请尝试 @ activity('Lookup1').output.firstRow to

Please try @activity('Lookup1').output.firstRow to indicate inside property.

这篇关于ADF查找活动数据传递到访存xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！