question Re: NiFi SchemaParseException: Illegal initial character in Support Questions

NiFi SchemaParseException: Illegal initial character

dk123 — Tue, 10 Dec 2019 16:16:03 GMT

Hi All,

when using the MergeContent processor I'm getting an avro.SchemaParseException due to $ characters in a nested attribute name ($.Snapshot.Events.['$values'][0].SportsUrn) in a json file. I have tried to fix it with the UpdateAttribute processor, but it won't work. What would be the best way to handle this exception?

Your support is highly appreciated!

Thanks

Re: NiFi SchemaParseException: Illegal initial character

MattWho — Mon, 09 Dec 2019 22:00:45 GMT

@dk123

You may want to use the replaceText processor to update your FlowFile's json content.

My suggestion would be to replace all occurrences of $ with either \$ or \\$

Hope this helps,

Matt

Re: NiFi SchemaParseException: Illegal initial character

dk123 — Tue, 10 Dec 2019 15:28:04 GMT

Hi Matt, thanks - works fine for me!