I'm new in Nifi and have a problem by inserting JSON values into a SQL Table.
My JSON contains information about TyreDatas. There it is possible that some field are not set. So I need to import a NULL value into SQL Table. But if I use the ReplaceText pattern all NULL values are inserted as a nvarchar "null" value, which can make problems.
F.e. if the LoadIndex isn't set, I get the value 'null' inside the SQL Table.
Do you have an idea how to prevent this?
Thanks for help
Can you attach sample input data and the nifi-flow (export it as XML) ? It would be helpful to understand what you are doing and decide where things could be changed.