question Re: Extract whole json flowfilecontent(small) to single attribute in Support Questions

Extract whole json flowfilecontent(small) to single attribute

adhishankarit — Wed, 06 Jan 2021 16:56:17 GMT

Hi All,

I have nifi flow fthat fetches one json file and using the extractText processor, i want to store entire flowfile content(assume small json file) into one flowfile attribute. But (.*) is not extracting whole json and instead extracting only { . Please help with Java regular expression to extract full json afnd also share if any Java regular expression documentation which i can refer for Nifi extracttext processor.

I having json file which contains format like

{

"filename1":"insert into filename1",

"filename2":"insert into filename2",

"filename3":"insert into filename3"

}

I will retrieve the filenames in generic way/dynamic using JsonPath(${filename}) in updateattribute .

Please assist to extract whole json content into one flow file attribute .

Thanks

@Nifi @NifiDev

Re: Extract whole json flowfilecontent(small) to single attribute

Faerballert — Wed, 06 Jan 2021 20:47:35 GMT

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.

Re: Extract whole json flowfilecontent(small) to single attribute

adhishankarit — Thu, 07 Jan 2021 12:23:53 GMT

Faerballert

Thanks for helping . I am able to get entire content into attribute .

I have one doubt that i have attribute name called "JSONValue" so that extracted value should be in this name but the flowfile content saves into the attribute "JSONValue.0 " as supposed to create value in JSONValue attribute . Please see screen-print for the same . I had to enable "Include Capture Group 0" as True otherwise the Regex not accepting and expecting value 0 to40 other than false.