Hello,
I have done field extraction for the nested JSON event using props.conf file. Everything is working as expected but facing one issue based on my requitements. Sample JSON event, my props.co...
See more...
Hello,
I have done field extraction for the nested JSON event using props.conf file. Everything is working as expected but facing one issue based on my requitements. Sample JSON event, my props.conf file, and the reequipments/issue are giving below. Any help will be greatly appreciated, thank you so much.
Sample Nested JSON Event:
{"TIME":"20220622154541","USERTYPE":"DSTEST","UID":"TEST01","FCODE":"06578","FTYPE":"01","SRCODE":"0A1","ID":"v23488d96-a1283-4ddf-8db7-8911-DS","IPADDR":"70.215.72.231","SYSTEM":"DS","EID":"ASW-CHECK","ETYPE":"VALID","RCODE":"001","DETAILINFO":{"Number":"03d1194292","DeptName":"DEALLE","PType":"TRI"},"YCODE":"1204342"}
props.conf:
[sourcetypename]
CHARSET=UTF-8
EVENT_BREAKER_ENABLE=TRUE
INDEXED_EXTRACTIONS=json
KV_MODE=json
LINE_BREAKER=([\r\n]+)
MAX_TIMESTAMP_LOOKAHEAD=30
NO_BINARY_CHECK=true
SHOULD_LINEMERGE=true
TIME_FORMAT=%Y%m%d%H%M%S
TIME_PREFIX={"TIME":"
TRUNCATE=2000
category=Custom
disabled=false
pulldown_type=true
Issue/Requirements:
I am getting Key/Value pair for the nested Key/Field DETAILINFO as
DETAILINFO.Number = 03d1194292
DETAILINFO.DeptName = DEALLE
DETAILINFO.PType = TRI
My requirement: "DETAILINFO" Key/Value pair should show up like below after the extraction:
DETAILINFO ="Number":"03d1194292","Dept name":"DEALLE","PType":"TRI"
OR
DETAILINFO= {"Number":"03d1194292","Dept name":"DEALLE","PType":"TRI"}