About bhandari_surbhi

bhandari_surbhi · ‎08-23-2018

Hi Matt Burgess Thanks for your help. It worked and now I am able to convert csv into nested JSON. Thanks a lot.

bhandari_surbhi · ‎08-21-2018

csv file: "Foo","12","newyork","North avenue","123213" "Foo1","12","newyork","North avenue","123213" "Foo2","12","newyork","North avenue","123213" Output required: { "studentName":"Foo", "Age":"12", "address__city":"newyork", "address":{ "address__address1":"North avenue", "address__zipcode":"123213" } } I am able to convert csv to simple json but not nested json using convertRecord Processor. please check my Avro schema: { "type" : "record", "name" : "MyClass", "namespace" : "com.test.avro", "fields" : [ { "name" : "studentName", "type" : "string" }, { "name" : "Age", "type" : "string" }, { "name" : "address__city", "type" : "string" }, { "name" : "address", "type" : { "type" : "record", "name" : "address", "fields" : [ { "name" : "address__address1", "type" : "string" }, { "name" : "address__zipcode", "type" : "string" } ] } } ] }

bhandari_surbhi · ‎08-14-2018

Hi @Vikas Singh , SplitJson Processor is used to split Json Array and EvaluateJsonPath is used to extract Json fields as attribute or content. In your case: Step 1:Use EvaluateJsonPath Processor to extract info fields of Json. For example: is you want to extarct info fileds: .$info.seed,.$info.page,.$info.version,.$info.results and save it as Flowfile Attribute. Step 2:Use SplitJson Processor :$.results Step 3:USe EvaluateJsonPath Processor to extract Json Array fields.

Online	Offline
Last Visited	‎09-18-2018 12:26 PM

Member Since	‎08-13-2018 07:02 AM
Last Visited	‎09-18-2018 12:26 PM
Posts	6

Cloudera Community

Cloudera Community

Re: want to convert csv to nested json using nifi

want to convert csv to nested json using nifi

Re: How to use Apache NiFi EvaluateJsonPath for JS...