DQL parse issue

ramchandgadde — Thu, 17 Jul 2025 10:41:04 GMT

Below are details that I tried for fetching and building dashboard in Dynatrace. For DQL I am using parse option. The problem with it is , the parse function somehow is not fetching all rows.

Do we have any other options, would you review below query suggest working option?

Data Log:

[INFO][EAP_WORKDAY][DYNATRACE] 2025-07-16 12:45:23.999 Merged_Response [{'Integration_Platform': 'DB_BATCH', 'Integration_Process': 'ATLAS_16076_9885bc5832094b06bfc2572009db68d9', 'Process_Type': None, 'Status': 'ERROR', 'Start_Date_and_Time': None, 'WorkdayID': None, 'End_Date_and_Time': '00:00:00', 'Acc_Center_Batch_ID': '16076'}, {'Integration_Platform': 'DB_BATCH', 'Integration_Process': 'ATLAS_16027_4c323fff6e354e76927f38dd8b9f97b9', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:18:14.937240Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:06', 'Acc_Center_Batch_ID': '16027'}, {'Integration_Platform': 'DB_NOTIFIER', 'Integration_Process': 'ATLAS_16027_4c323fff6e354e76927f38dd8b9f97b9', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:19:30.785763Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:06', 'Acc_Center_Batch_ID': '16027'}, {'Integration_Platform': 'DB_BATCH', 'Integration_Process': 'ATLAS_16101_7b97e61e32804f7f86c81cd926e7d989', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:20:28.723717Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:02', 'Acc_Center_Batch_ID': '16101'}, {'Integration_Platform': 'DB_NOTIFIER', 'Integration_Process': 'ATLAS_16101_7b97e61e32804f7f86c81cd926e7d989', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:21:03.272498Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:01', 'Acc_Center_Batch_ID': '16101'}, {'Integration_Platform': 'DB_BATCH', 'Integration_Process': 'ATLAS_15972_328a4276cca3494b9040054cac506b83', 'Process_Type': None, 'Status': 'COMPLETED', 'Start_Date_and_Time': None, 'WorkdayID': None, 'End_Date_and_Time': '00:00:00', 'Acc_Center_Batch_ID': '15972'}, {'Integration_Platform': 'DB_BATCH', 'Integration_Process': 'ATLAS_15981_d88dea264ae74fa6a4d0fb238d68d113', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:18:23.535363Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:03', 'Acc_Center_Batch_ID': '15981'}, {'Integration_Platform': 'DB_NOTIFIER', 'Integration_Process': 'ATLAS_15981_d88dea264ae74fa6a4d0fb238d68d113', 'Process_Type': 'DB', 'Status': 'COMPLETED', 'Start_Date_and_Time': '2025-07-16T07:19:33.355444Z', 'WorkdayID': None, 'End_Date_and_Time': '00:00:04', 'Acc_Center_Batch_ID': '15981'}]

Dynatrace Query

fetch logs, from:-4h

| filter contains(content, "Merged_Response")

| parse content, """LD 'Status\': \'' WORD:Status LD 'Process_Type\': \'' WORD:Process_Type LD 'Integration_Process\': \'' WORD:Integration_Process LD 'Integration_Platform\': \'' WORD:Integration_Platform LD 'Start_Date_and_Time\': \'' TIMESTAMP("yyyy-MM-dd'T'HH:mm:ss"):Start_Date_and_Time LD 'End_Date_and_Time\': \'' TIMESTAMP("yyyy-MM-dd'T'HH:mm:ss"):End_Date_and_Time"""

| filter isnotnull(Status) and isnotnull(Process_Type) and isnotnull(Integration_Process) and isnotnull(Start_Date_and_Time)

| fields Process_Type, Integration_Process, Integration_Platform, Status,Start_Date_and_Time,End_Date_and_Time

Re: DQL parse issue.

GerardJ — Thu, 17 Jul 2025 07:25:29 GMT

Hi @ramchandgadde
Your data sample made me think of a JSON Array, so I tried this :

| parse content, """LD "Merged_Response " JSON_ARRAY(strict=false):array""" | expand array

With that I get a record for each array member, like this :

depending on your use case, that can be helpful

topic DQL parse issue in DQL

DQL parse issue

Re: DQL parse issue.