How to get the right value like 0 or 1 format from CaptureChangeMySQL processor flowfile output for BIT(1) data type.

[#1]

Hi All,

I am using NiFi CaptureChangeMySQL processor to read the mysql binarylogs file data.   CaptureChangeMySQL processor flowfile output has "{}" value for BIT(1) data type.

How to get the right value like 0 or 1 format from CaptureChangeMySQL processor flowfile output.

{
"id": 29,
"name": "is_deleted",
"column_type": -7,
"last_value": "{}",
"value": "{}"
},