Support Questions
Find answers, ask questions, and share your expertise

NiFi: JsonToSql converter > PutSQL null issue

New Contributor

Given a json file:

{........ "a": "ADV", "b": "VI", "c": null, "d": null, "e": null ......}

And using the ConvertJSONtoSQL nifi processor, the attributes are not mapped correctly. It adds a ?,?,? for the nulls but it does not place a value. See picture attached.

The flowfiles converted will include insert statements with extra "?" since they do not have any values associated with the keys.

What is the proper way to ignore json 'null' values so that you can build insert statements without including the extra attributes since there is no value?