unable to parse below json log to signoz using the...
# generaln
Nikhil Jain
02/08/2024, 8:26 AMunable to parse below json log to signoz using the below configuration file
{"channel":"crm_process_booking_log","log_type":"DEBUG","index_name":"crm_process_booking_log","index_type":"crm_process_booking_log","error_type":0,"message":{"data":{"STEP":"slot_details","slotDetail":{"stm_id":"684178718","time":"143000","end_time":"153000","locality_id":0,"booking_id":0,"freeze_count":0,"date":"2024-02-07","user_id":0,"collection_center_id":0,"b2b_zone_id":0,"zone_id":53,"sample_type_id":1,"isavailable":1,"isactive":1,"set_name":"set5","is_peak_hours":0,"source":"crm","order_group_id":0,"old_zone_id":0,"samplecollector_id":0,"old_set_name":"","phlebo_name":"","assign_time":"0000-00-00 000000","freeze":0,"freeze_date":"0000-00-00 000000","payment":0,"locusStatus":0,"lat":"","lng":"","dropTaskStatus":0,"autoAssignStatus":0,"pickup_type":"home","service_id":0,"consultation_id":0,"channel_type":0,"channel_user":0,"vendor_user_id":"","created_at":"2024-02-05 125610","updated_at":"2024-02-05 125610","reference_stm_id":0,"phlebo_id":0},"amzn_trace_id":"Root=1-65c33f1c-29fe535658001b076140677c"},"calling_trace":{"file":"\/var\/www\/newcrm-t25\/application\/controllers\/crmuser\/crmorder.php","line":2112,"function":"addProcessBookingLog","class":"Enterprise_logger"}},"amzn_trace_id":"Root=1-65c33f1c-29fe535658001b076140677c","nginx_request_id":"c93176430784c9dd4e32e35541e6e31a","timestamp":"2024-02-07 135812"}
Configuration file : -
receivers:
filelog:
include: [ "/var/log/newcrm/el-t25crm.healthians.co.in-2024-02-*.log" ]
start_at: end
include_file_path: true
include_file_name: false
poll_interval: 200ms
operators:
- type: regex_parser
regex: '^.(?P<body>{.})'
output: parsedata
- type: json_parser
id: parsedata
parse_from: attributes.body
- type: move
from: attributes["body"]
to: body
- type: time_parser
parse_from: attributes.time
layout: '2006-01-02T150405Z07:00'
layout_type: gotime
processors:
batch:
send_batch_size: 10000
send_batch_max_size: 11000
timeout: 10s
exporters:
otlp/log:
endpoint: http://slog001.echl.in:4317
tls:
insecure: true
service:
pipelines:
logs:
receivers: [filelog]
processors: [batch]
exporters: [otlp/log]
~
8 Views