To change the key names of your JSON you can transform it with JOLT. The Processor name calls JoltTransformJSON   In the property you can "Jolt Specification" you can insert following code, that would be change your key from ServiceGroup to service_group and afterwards you can send the flowfile to the sql processor..   [ { "operation": "shift", "spec": { "ServiceGroup": "service_group", "*": "&" } } ]   ... View more

Hi,  i tried a solution for you: 1) GenerateFlowFile Its your GetFile Processor to get the csv file   2) ConvertRecord Convert with CSVReader to JsonRecordSetWriter   3) SplitJson Split each bbject (csv row) with    $.*   as path   4) EvaluateJsonPath Add dynamicilly property with name   filename   and value   $.ID   to get the ID as filename on flowfile attribute   5) UpdateAttribute Add type of file to filename attribute value   ${filename:append('.csv')}     6) ConvertRecord Now is the question how to work.. You can convert json back to csv or you are working with wait/notify, so that you can overhand your "filename" attribute to your splitted csv flowfile.. ... View more

Hello,   you could use following regex [^^]+ with that you should get the whole content.   Please take a look at the property "Maximum Capture Group Length" at the ExtractText Processor, that its not too short.  ... View more