Hi Team, I tried the JSON parser but it is still i...
# support
a
Hi Team, I tried the JSON parser but it is still in stringified type
n
please share the pipeline , also can you paste the json body here
a
{ "body": "{ \"@timestamp\": \"2024-08-07T185241+05:30\", \"msec\": 1723036961.404, \"remote_addr\": \"127.0.0.1\", \"x_forwarded_for\": \"127.0.0.1\", \"remote_port\": \"54134\", \"pipelined\": \".\", \"body_bytes_sent\": \"3442\", \"bytes_sent\": 4270, \"request_time\": 0.040, \"upstream_response_time\": \"0.040\", \"upstream_response_length\": \"19526\", \"upstream_status\": \"200\", \"kore_route\": \"/searchassistapi/findly/:searchIndexId/jobs\", \"koreserver\": \"KoreServer/000000\", \"host\": \"localhost\", \"hostname\": \"ki01102\", \"server_name\": \"_\", \"request_completion\": \"OK\", \"status\": 200, \"connection_requests\": 10, \"request_uri\": \"/searchassistapi/findly/sidx-dfb2c85d-e295-51f0-becf-8eb7fcfc160a/jobs\", \"request_method\": \"GET\", \"request_content_type\": \"application/json;charset=UTF-8\", \"request_content_length\": \"-\", \"request_total_length\": 798, \"args\": \"-\",\"is_args\": \"\", \"x-traceid\":\"-\", \"http_user_agent\": \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36\" }", "id": "2kKKI9EAi7UDAzKutRIso8yJ6Kr", "timestamp": 1723036961444, "attributes": { "log.file.name": "api_access.log", "parsedData": "{\"@timestamp\":\"2024-08-07T185241+05:30\",\"args\":\"-\",\"body_bytes_sent\":\"3442\",\"bytes_sent\":4270,\"connection_requests\":10,\"host\":\"localhost\",\"hostname\":\"ki01102\",\"http_user_agent\":\"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36\",\"is_args\":\"\",\"kore_route\":\"/searchassistapi/findly/:searchIndexId/jobs\",\"koreserver\":\"KoreServer/000000\",\"msec\":1723036961.404,\"pipelined\":\".\",\"remote_addr\":\"127.0.0.1\",\"remote_port\":\"54134\",\"request_completion\":\"OK\",\"request_content_length\":\"-\",\"request_content_type\":\"application/json;charset=UTF-8\",\"request_method\":\"GET\",\"request_time\":0.04,\"request_total_length\":798,\"request_uri\":\"/searchassistapi/findly/sidx-dfb2c85d-e295-51f0-becf-8eb7fcfc160a/jobs\",\"server_name\":\"_\",\"status\":200,\"upstream_response_length\":\"19526\",\"upstream_response_time\":\"0.040\",\"upstream_status\":\"200\",\"x-traceid\":\"-\",\"x_forwarded_for\":\"127.0.0.1\"}" }, "resources": {}, "severity_text": "", "trace_id": "", "span_id": "", "trace_flags": 0, "severity_number": 0 }
n
set
parse TO
to just
attributes
all your data will be parsed to attributes. Else if you want just specific keys check out this guide https://signoz.io/docs/logs-pipelines/guides/json/
a
can i have the base body be in json type instead stringified Type
n
check the detail of the log line you should be able to see body again.