Hello everyone, need your support to parse below sample json, i want is 1. Only the fields from "activity_type" till "user_email" 2. Remove first lines before "activity_type"and last lines after "user_email" 3. Line should break at "activity_type" 4. TIME_PREFIX=event_time i added below but doesn't work removing the lines and TIME_PREFIX [ sample_json ] BREAK_ONLY_BEFORE=\"activity_type":\s.+, CHARSET=UTF-8 SHOULD_LINEMERGE=true disabled=false LINE_BREAKER=([\r\n]+) TIME_PREFIX=event_time SEDCMD-remove=s/^\{/g Sample data: { "status": 0, "message": "Request completed successfully", "data": [ { "activity_type": "login", "associated_items": null, "changed_values": null, "event_time": 1733907370512, "id": "XcDutJMBNXQ_Xwfn2wgV", "ip_address": "x.x.x.x", "is_impersonated_user": false, "item": { "user_email": "xyz@example.com" }, "message": "User xyz@example.com logged in", "object_id": 0, "object_name": "", "object_type": "session", "source": "", "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15", "user_email": "xyz@example.com" }, { "activity_type": "export", "associated_items": null, "changed_values": null, "event_time": 1732634960475, "id": "bd0XaZMBH5U9RA7biWrq", "ip_address": "", "is_impersonated_user": false, "item": null, "message": "Incident Detail Report generated successfully", "object_id": 0, "object_name": "", "object_type": "breach incident", "source": "", "user_agent": "", "user_email": "" }, { "activity_type": "logout", "associated_items": null, "changed_values": null, "event_time": 1732625563087, "id": "jaGHaJMB-qVJqBPy_3IG", "ip_address": "87.200.106.98", "is_impersonated_user": false, "item": { "user_email": "xyz@example.com" }, "message": "User xyz@example.com logged out", "object_id": 0, "object_name": "", "object_type": "session", "source": "", "user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36", "user_email": "xyz@example.com" } ], "count": 33830, "meta_info": { "total_rows": 33830, "row_count": 200, "pagination": { "pagination_id": "" } } }
... View more