Support Questions
Find answers, ask questions, and share your expertise

ConvertJSONToSQL Processor INSERT Issue

New Contributor

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')

1 REPLY 1

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.