How can empty arrays be removed from the JSON payload of the Debezium Outbox Pattern property, transforms.outbox.table.expand.json.payload?

edit

One way to remove empty arrays from the JSON payload of the Debezium Outbox Pattern property, transforms.outbox.table.expand.json.payload, is to use a custom transformer in the Kafka Connect worker configuration.

The transformer logic would need to identify empty arrays in the JSON payload and remove them before forwarding the message to downstream systems. This can be achieved using a combination of JSON parsing and filtering logic.

Alternatively, you could modify the application code that generates the JSON payload to exclude empty arrays in the first place.