Fetch start_time and end_time_new from Log content

Gopi-10 — Mon, 01 Sep 2025 12:17:04 GMT

LOG Content:
25/08/13 11:23:51 INFO log_msg for Job status in nprod: Appended latest task for job_id 1234: {'job_id': '1234', 'run_id': '321', 'task_key': 'GRR', 'start_time_new': 'Aug 13, 2025, 10:00 AM', 'end_time_new': 'Aug 13, 2025, 10:00 AM', 'result_state': 'FAILED', 'execution_duration': '0m 3s'}

Used below query by got NULL result:

Re: Need to parse into JSON. I need to fetch start time and end time new from Log content.

Akhil-Jayendran — Thu, 14 Aug 2025 13:19:44 GMT

Hello @Gopi-10 ,

Can you try this?

| parse content, """LD 'start_time_new\': \'' LD:start_time_new '\','"""

topic Fetch start_time and end_time_new from Log content in DQL

Fetch start_time and end_time_new from Log content

Re: Need to parse into JSON. I need to fetch start time and end time new from Log content.