Hi Matt, Its working as expected, are there any settings/configs that can help me to move even the first non-dup one to the duplicate flow when it finds a duplicate record..Meaning expectation of my requirement is to move all the 3 identical records to duplicate flow. Is it possible?   Thanks, Sam ... View more

Hi, Have a scenario : any JSON array, has key in double quotes and value in double quotes, i.e. { "jsonElementKey1" : "jsonElementValue1",...} convertJSONToSQL processor expects the JSON key and value to be in double quotes, else it can't convert to SQL. For the MS SQL inserts, the string column values expects single quote, so if the above JSON example is converted to {"jsonElementKey1" : 'jsonElementValue1" } using replaceText processor prior to convertJSONtoSQL, the convertJSONtoSQL fails stating single quote as invalid character. Can you help to get out of this deadlock scenario?   Thanks, Sam ... View more