Silver ⭐️

Solved

NiFi SchemaParseException: Illegal initial character

2 replies
6160 views
Translate All

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

Apache NiFi

Titanium ⭐️⭐️⭐️

@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

Titanium ⭐️⭐️⭐️

@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

Translate

dk123Author

Silver ⭐️

Hi Matt, thanks - works fine for me!

Translate