How to load JSON format data to LiveView tables

I was getting the below data in a format of jason consuming from kafka topic. How do i do this , convert this data and load into my live view table ?

If there's more than one approach, I would like to know them...please brief about the approach and steps in detail.

[12544:OperatorThread(Publisher.KafkaFedTableProvider.ReadFromBus.KafkaConsumer)] INFO  com.streambase.sb.adapter.kafka.KafkaConsumer: Deserializing tuple for topic 'zer.kamel.wbs.extract' from string: {"rountenbr":"FX77","routedt":{"dayOfMonth":5,"dayOfWeek":"TUESDAY","dayOfYear":126,"monthValue":5,"nano":0,"hour":0,"second":0,"minute":0,"year":2020,"month":"MAY","chronology":{"id":"ISO","calendarType":"iso8601"}},"pieces":2,"declnval":553.53,"mdetmstp":{"dayOfMonth":30,"dayOfWeek":"THURSDAY","dayOfYear":121,"monthValue":4,"nano":0,"hour":23,"second":29,"minute":26,"year":2020,"month":"APRIL","chronology":{"id":"ISO","calendarType":"iso8601"}},"cifirstmstp":null,"cilastmstp":null,"awbfirstmstp":null}

(1) Answer

Login