Hi, thanks for the information , I came across situation before and I'm not sure if there is better way but you can use the following processors after you split to data into individual records : ExtractText -> PUTSQL For the ExtractText: 1- Add dynamic Property to capture all the Json Content from incoming flowfile as follows: Note: You have to be careful with if each record data can be large (> 1024 Chars). In this case you need to look into modifying "Maximum Buffer Size" and "Maximum Capture Group Length" accordingly otherwise the data will be truncated. For the PutSQL: Once you configure the JDBC Connection Pool , you can set the SQL Statement Property with something like this: insert into myTable (jsonCol) values ('${JsonRecord}')   If that helps please accept solution ... View more

Hi, I think this can be achieved using the following flow: (Data Source) -> SplitJson ->JoltTransformationJSON ->ConcertJSONToSQL->PutSQL   The Configuration for each processor is as follows:   1- SplitJson (To get Each of the Rows Element as flowfile) JsonPath Expression = $.Rows 2-JoltTransformationJSON (Convert Each Row Values Element to proper format): Example Input: { "Values": [ "A4", "Test Data A4"] } Output: { "VALUE" : "A4", "DESCRIPTION" : "Test Data A4" } Jolt Spec: [ { "operation": "shift", "spec": { "Values": { "0": "VALUE", "1": "DESCRIPTION" } } } ] Note: The Output Json Keys has to match the column name in the SQL table   3- ConverJSONToSQL ( This is to convert the jolt output json to sql statement that will feed into the PutSql Note: you need to Populate the JDBC Connection Pool   4- PutSql (used to execute the insert sql statement generated from above into the DB Table. Note: You need to create the JDBC Connection Pool. SQL Statement Property remains empty to use the SQL statement from the flowfile generated in step 3.   If that helps please accept solution. Thanks ... View more