在Dynamics Fetchxml中过滤dateformat问题 [英] Filter dateformat issue in Dynamics Fetchxml

问题描述

Dynamics fetchxml失败的数据格式问题，该问题来自过滤器.关于此的任何建议

Dynamics fetchxml failing dataformat issue which is source from filter. Any advise on this 

  <属性名称="bu_abandoned"； />

{"errorCode":"2200"，"message":失败发生在源"端. ErrorCode = UserErrorDynamicsOperationFailed，'类型= Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，消息=动态 操作失败，错误代码:-2147220935，错误消息:日期时间格式 @formatDateTime(activity('Filter1').output.value，'YYYY-MM-DD')无效，或该值超出了支持范围..，Source = Microsoft.DataTransfer.ClientLibrary. DynamicsPlugin，"，"failureType":"UserError"，"target": 复制约会" }

{ "errorCode": "2200", "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 @formatDateTime(activity('Filter1').output.value,'YYYY-MM-DD') is invalid, or value is outside the supported range..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'", "failureType": "UserError", "target": "Copy Appointments" }

filter1输出

{"ActivityRunId":"8168d478-89d7-4c4e-b2cc-837334867e55" ，状态":成功"，错误":{消息":"，错误代码": " }，输出":{"ItemsCount":2，"FilteredItemsCount":1，"Value":[{"account_md":"2018-09-05T13:18:01Z"，"tname" ;:"bb" }]}}

{ "ActivityRunId": "8168d478-89d7-4c4e-b2cc-837334867e55", "Status": "Succeeded", "Error": { "Message": "", "ErrorCode": "" }, "Output": { "ItemsCount": 2, "FilteredItemsCount": 1, "Value": [ { "account_md": "2018-09-05T13:18:01Z", "tname": "bb" } ] } }

推荐答案

该错误表示"

The error indicates "@formatDateTime(activity('Filter1').output.value,'YYYY-MM-DD')" wasn't been translated to real datetime value before sending request to Dynamics service. Instead, this Verbatim string got send to Dynamics service which results in date-time format error.

能否请您再次检查管道参数是否按预期工作?您在马德里尝试过吗?

Could you please double check whether your pipeline parameter works as expected? Did you try it in Madrid?

这篇关于在Dynamics Fetchxml中过滤dateformat问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！