NiFi SchemaParseException: Illegal initial character

[#1]

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

[#2 · Accepted solution]

@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

[#3]

Hi Matt, thanks - works fine for me!