User defined data message format

[ramyakan7]

Hi,

I am extracting CDC data from replicate in Json format and sending it to Kafka. Is it  possible to send a message in user defined/Debezium format?

My new JSON format be like:

{
  "before": {
    "id": 111,
    "name": "scooter",
    "description": "Big 2-wheel scooter",
    "weight": 5.18
  },
  "after": {
    "id": 111,
    "name": "scooter",
    "description": "Big 2-wheel scooter",
    "weight": 5.15
  },
  "source": {...},
  "op": "u",
  "ts_ms": 1589362330904,
  "transaction": null
}

 can we achieve this is Replicate?

Thanks,

Ramya

[john_wang]

Hello @ramyakan7 ,

Welcome to Qlik Community forum and thanks for reaching out here!

Looks to me it should be fine in Qlik Replicate, there are rich header columns can be customized in JSON format messages, for example:

Hope this helps.

John.

[ramyakan7]

Hello @john_wang 

Thanks for your reply. I understood we can choose the header columns from the various options.

By any chance, can we rename it?

For ex: 'operation' to 'op'

Many thanks,

Ramya

[john_wang]

Hello Ramya, @ramyakan7 

No, there is no option to change the predefined header columns name.

Regards,

John.

[Dana_Baldwin]

Hi @ramyakan7 

If renaming the header column is a feature you would like to see, we encourage you to post this feature request directly to our Product Management team here: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana