ConvertJSONToSQL Processor INSERT Issue

[#1]

How to use dynamic sql inside sql in ConvertJSONToSQL Processor

INSERT INTO TEST (ID,NAME, PARENT_ID) VALUES (2345, ABC, SELECT ID FROM TEST WHERE NAME='XYZ')

[#2]

Hi,

If you really want use the ConvertJsonToSQL processor, you need to have a field in your json object with the SQL inner query.

You can also use the EvaluateJSonPath -> replaceText -> putSQL flow to achieve that.