Help with creating a regex that splits API data into better format than 1 big event?

vishalduttauk — Fri, 24 Mar 2023 19:37:14 GMT

Hi all,

I am getting data in via an API (using the add on builder) but having creating a regex which splits it into a better format rather than 1 big event. Here is an example of the event:

"@odata.context": "https://example-app-env.aa01.aaa.aaaa-ad/odata/$metadata#Jobs", "@odata.count": 111, "value": [ { "Key": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "StartTime": "2023-01-20T14:08:34.607Z", "EndTime": "2023-01-20T14:08:49.517Z", "State": "Successful", "JobPriority": "Normal", "Source": "Agent", "SourceType": "Agent", "BatchExecutionKey": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "Info": "Job completed", "CreationTime": "2023-01-20T14:08:34.607Z", "StartingScheduleId": null, "ReleaseName": "RobotProdLogin_DEV", "Type": "Attended", "InputArguments": "", "OutputArguments": "{}", "HostMachineName": "AAAAAAAA11111", "HasMediaRecorded": false, "PersistenceId": null, "ResumeVersion": null, "StopStrategy": null, "RuntimeType": "Development", "RequiresUserInteraction": true, "ReleaseVersionId": 1111, "EntryPointPath": null, "OrganizationUnitId": 1, "OrganizationUnitFullyQualifiedName": "Default", "Reference": "", "ProcessType": "Process", "ProfilingOptions": null, "ResumeOnSameContext": false, "LocalSystemAccount": "AAAAAA01\\AAA11AA", "OrchestratorUserIdentity": null, "Id": 00000 }, { "Key": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "StartTime": "2023-01-20T14:08:34.607Z", "EndTime": "2023-01-20T14:08:49.517Z", "State": "Successful", "JobPriority": "Normal", "Source": "Agent", "SourceType": "Agent", "BatchExecutionKey": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "Info": "Job completed", "CreationTime": "2023-01-20T14:08:34.607Z", "StartingScheduleId": null, "ReleaseName": "RobotProdLogin_DEV", "Type": "Attended", "InputArguments": "", "OutputArguments": "{}", "HostMachineName": "AAAAAAAA11111", "HasMediaRecorded": false, "PersistenceId": null, "ResumeVersion": null, "StopStrategy": null, "RuntimeType": "Development", "RequiresUserInteraction": true, "ReleaseVersionId": 1111, "EntryPointPath": null, "OrganizationUnitId": 1, "OrganizationUnitFullyQualifiedName": "Default", "Reference": "", "ProcessType": "Process", "ProfilingOptions": null, "ResumeOnSameContext": false, "LocalSystemAccount": "AAAAAA01\\AAA11AA", "OrchestratorUserIdentity": null, "Id": 00000 },

How i want it to look.
Event 1

"@odata.context": "https://example-app-env.aa01.aaa.aaaa-ad/odata/$metadata#Jobs", "@odata.count": 111, "value": [ {

Event 2

{ "Key": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "StartTime": "2023-01-20T14:08:34.607Z", "EndTime": "2023-01-20T14:08:49.517Z", "State": "Successful", "JobPriority": "Normal", "Source": "Agent", "SourceType": "Agent", "BatchExecutionKey": "aaa1a111-aa11-11aa-a11a-11a1aa11a111", "Info": "Job completed", "CreationTime": "2023-01-20T14:08:34.607Z", "StartingScheduleId": null, "ReleaseName": "RobotProdLogin_DEV", "Type": "Attended", "InputArguments": "", "OutputArguments": "{}", "HostMachineName": "AAAAAAAA11111", "HasMediaRecorded": false, "PersistenceId": null, "ResumeVersion": null, "StopStrategy": null, "RuntimeType": "Development", "RequiresUserInteraction": true, "ReleaseVersionId": 1111, "EntryPointPath": null, "OrganizationUnitId": 1, "OrganizationUnitFullyQualifiedName": "Default", "Reference": "", "ProcessType": "Process", "ProfilingOptions": null, "ResumeOnSameContext": false, "LocalSystemAccount": "AAAAAA01\\AAA11AA", "OrchestratorUserIdentity": null, "Id": 00000 },

Can you help?

Re: Linebreak help

gcusello — Fri, 24 Mar 2023 10:43:26 GMT

Hi @vishalduttauk,

please try this

(^\"|\{)

that you can test at https://regex101.com/r/VAaTET/1

Ciao.

Giuseppe

Re: Linebreak help

vishalduttauk — Mon, 27 Mar 2023 13:59:18 GMT

Thanks Giuseppe

topic Help with creating a regex that splits API data into better format than 1 big event? in Getting Data In

Help with creating a regex that splits API data into better format than 1 big event?

Re: Linebreak help

Re: Linebreak help