locked
ADF Lookup Activity data pass into fetch xml RRS feed

  • Question

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

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

    <fetch>

    <entity name="account">
    <attribute name="accountnumber" />
    <attribute name="modifiedon" />
    <filter type="and">
    <condition attribute ="modifiedon" operator="on-or-before" value="2019-08-11T12:26:57Z"/>
     <condition attribute ="modifiedon" operator="on-or-after" value="@activity('Lookup1').output"/>
    </filter>
    </entity>
    </fetch>

    Error:

    {

    "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 "@activity('Lookup1').output' is invalid, or value is outside the supported range..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'", "failureType": "UserError", "target": "Copy_rw1" }

    Lookup output data

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

    Tuesday, August 7, 2018 2:28 PM

All replies

  • Hi,

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

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

    Wednesday, August 8, 2018 1:54 AM