JSON data and reporting

[SachinC]

Hi,
I want to report on some key value pair JSON data, example below...

"ReportDetail": "{{\"Checks.RoadTest.SubChecks.1.Hidden\":\"True\",\"Checks.RoadTest.SubChecks.2.Hidden\":\"True\",\"Checks.RoadTest.SubChecks.3.Hidden\":\"True\",\"Checks.RoadTest.SubChecks.13.Hidden\":\"True\",\"Checks.RoadTest.SubChecks.5.Hidden\":\"True\",\"Checks.RoadTest.SubChecks.14.Hidden\":\"True\",\"CurrentPage\":\"VehicleInspection/Complete\",\"CurrentTitle\":\"Complete\",\"AllFailQuestions\":\"Checks.Electrical.SubChecks.21.,Checks.RoadTest.SubChecks.9.\",\"VehicleCompleteTime\":\"2021-09-01 08:02:21\",\"Checks.BodyExteriorFittings.SubChecks.5.Answer\":\"N/A\",\"Checks.BodyExteriorFittings.SubChecks.7.Answer\":\"N/A\",\"Checks.InteriorFittings.SubChecks.4.Answer\":\"N/A\",\"Checks.EngineCompartment.SubChecks.5.Answer\":\"N/A\",\"Checks.EngineCompartment.SubChecks.16.Answer\":\"N/A\",\"Checks.EngineCompartment.SubChecks.17.Answer\":\"N/A\",\"Checks.Electrical.SubChecks.2.Answer\":\"N/A\",\"Checks.Electrical.SubChecks.10.Answer\":\"N/A\",\"Checks.Transmission.SubChecks.9.Answer\":\"N/A\",\"Checks.Transmission.SubChecks.10.Answer\":\"N/A\",\"Checks.Transmission.SubChecks.11.Answer\":\"N/A\",\"Checks.Transmission.SubChecks.12.Answer\":\"N/A\",\"Checks.Exhaust.SubChecks.2.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.1.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.2.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.3.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.5.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.13.Answer\":\"N/A\",\"Checks.RoadTest.SubChecks.14.Answer\":\"N/A\",\"EmailFailItems\":\"Window Operation\\nGeneral Steering/Handling\",\"EmailFailItemsHtml\":\"Window Operation<br />General Steering/Handling\",\"System.UserId\":\"692ddb87-12f1-4401-9a6e-e55a5d8db13e\",\"EndInspection\":\"2021-09-01 08:02:22\",\"Message.Version\":\"AAIMS.41\",\"Message.IsLocalOnly\":\"False\",\"Message.MessageSource\":\"Draft\",\"Message.Opened\":\"True\",\"Message.DataPending\":\"False\",\"VehicleLookup\":\"Wm14cwa\",\"AdHocLookup.Success\":\"true\",\"AdHocLookup.Error\":\"\",\"HPI.Lookup.Registration\":\"Wm14cwa\",\"HPI.Status\":\"Vehicle found\".....

All other fields are fine, i.e. "VehicleMOT": "Expires: 29 June 2022", but I want to report on the above string which is huge. How can I do this please? There are sub-key value pairs in there, i.e. Checks.RoadTest.SubChecks.2.Answer = N/A etc...

Thanks!