escape sequence in azure data factory


  • I am reading data from MS Dynamics CRM via Adf . I am trying to make a dynamic fetch expression(where clause will change at run time) to read data from DCRM .My issue is that ADF is  ignoring all text after '</' and i am not getting output as expected . I have explained what parameter i have set , expected output , actual output . Can someone please help me .<o:p></o:p>

    Pipeline parameter , Fetch_expression ,- a param abc>

    Expression written - @replace(pipeline().parameters.Fetch_expression,'param' ,'</')

    <o:p>expected output - a </ abc></o:p>

    <o:p>Actual output - a </o:p>

    Tuesday, February 12, 2019 1:18 PM

All replies

  • I have written below expression in copy activity . I have a parameter in pipeline name "Fetch_expression" . I am trying to evaluate the value of this parameter dynamically in copy activity . I have written expected output and actual output . Does some one has any idea why its happening ? Also does anyone has any idea how do i get expected output 

    Expression = @replace(pipeline().parameters.Fetch_expression,'xml_tag ', '<') 

    Fetch_expression = "xml_tag/ filter"

    Expected output ="</ filter"

    Actual output = " " i.e. blank string 

    Note - I tried to find escape sequence in adf but i couldnt get it . i had a thought that i might be able to resolve this with escape sequence but i wasnt able to do it .

    Wednesday, February 13, 2019 5:47 AM
  • Looks like this is a bug in ADF.  Thank you for bringing this to our notice.  I am working internally with the team to get this fixed.  I will update you when I have more information.
    Wednesday, February 13, 2019 8:03 PM