Would it help to go directly from Avro to CSV using ConvertRecord? Rather then making two conversions and splitting.
On Fri, Aug 25, 2017 at 1:53 PM, Austin Duncan <adun...@pyaanalytics.com> wrote: > It's hipaa data but I can probably do a work around. Give me a minute > > On Fri, Aug 25, 2017 at 1:51 PM, Joe Witt <joe.w...@gmail.com> wrote: >> >> Austin, >> >> Can you share the sample data and flow template by chance? >> >> Thanks >> Joe >> >> On Fri, Aug 25, 2017 at 1:50 PM, Austin Duncan <adun...@pyaanalytics.com> >> wrote: >> > Hey all, >> > >> > So I am converting an avro schema to json. Then I am trying to split the >> > json so that each of item can be its own row in a csv. I am unable to >> > split >> > the json. i used a JSONPath Expression tester and it seems like the >> > expression '$.' should work. But when I put it into the SplitJson >> > processor >> > i get the error: "'' is invalind because Failed to run validation due to >> > java.langStringIndexOutOfBondsException: String index out of range:2." >> > It >> > seems like there should be a record "results" in the schema but it isnt >> > present in the json and it wont let me split on it. I have tried using >> > the >> > UpdateRecord processor but couldn't figure out how to nest the schema >> > objects with in a new object called "results". Any ideas? >> > >> > Thanks, >> > Austin > >