Support Questions

Find answers, ask questions, and share your expertise

NiFi SchemaParseException: Illegal initial character

avatar
New Contributor

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

image.png

1 ACCEPTED SOLUTION

avatar
Master Mentor

@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

View solution in original post

2 REPLIES 2

avatar
Master Mentor

@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

avatar
New Contributor

Hi Matt, thanks - works fine for me!