Member since
05-22-2017
7
Posts
0
Kudos Received
0
Solutions
02-03-2025
02:39 AM
Thanks mburgess! This was helpful.
... View more
01-12-2023
01:03 PM
In my case I have to fetch a particular key value from a json array. I was trying to do $.[key] but it just splits the array into separate json files. Is there any solution for this ? I wanted the split array as {"test1", "test2"} Jsonarray example: [{"key":"test1", "name":"testName"}, {"key":"test2", "name":"testName2"}]
... View more
05-23-2017
04:06 PM
1 Kudo
Hi @brian adi You can use the SplitJson processor to get the array into individual flowfile records, then use EvaluateJsonPath to pull out the values of interest, and ReplaceText to get the content back into a CSV format. Here is a good example with screenshots showing how to do this using NiFi https://community.hortonworks.com/articles/64069/converting-a-large-json-file-into-csv.html As always, if you find this post useful, don't forget to accept the answer.
... View more