Getting Data In

Json array data to spilted in new events during indexing

DataOrg
Builder

I am running python script and collecting array of Json data into single events. multiple events are clubbed into single events. i want to spilt each json data into new events.

i added below props.conf but its not spiltting the events.

@kamlesh_vaghela 

{"ErrorCode": 0, "ErrorMessage": null, "Name": "test", "Description": null, "EngineeringUnits": null, "Comment": null, "CollectorName": "BRnjbnTC-Mkjk8_Calculation", "CollectionType": 2}

{"ErrorCode": 0, "ErrorMessage": null, "Name": "BR-MSL68.Lmkmnjk26_MIP.P1.ond", "Description": "Lmnnkj26_MlknlkIP..knnlkC01.Second", "EngineeringUnits": null, "Comment": null, "CollectorName": "BRknk-MSLAnk8_OPC_Intelnkjklution_Intkjkellutionkjkjkver", "CollectionType": 2}

{"ErrorCode": 0, "ErrorMessage": null, "Name": "BC-MSLA;k;okpoB0168.L26_MnlkjIP.PLC0jnlk1.UDE_SlkjlkIM_TRIlklj;lkGGER", "Description": "L26_Mjklj", "EngineeringUnits": null, "Comment": null, "CollectorName": "BRjkjTC-kljkljlkjik", "CollectionType": 2}

 

 

[PsG_SddT_Tags]
DATETIME_CONFIG=CURRENT
SHOULD_LINEMERGE=true
NO_BINARY_CHECK=true
LINE_BREAKER=}(\,){
SEDCMD-break=s/({"ErrorCode": \[)//g
SEDCMD-b=s/]}$//g
TRUNCATE = 0

 

 

Labels (3)
Tags (2)
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@DataOrg 

Can you please share sample clubbed event?

0 Karma

DataOrg
Builder

@kamlesh_vaghela 

this is the event, the below output is 3 different events but indexed in splunk into single event.

{"ErrorCode": 0, "ErrorMessage": null, "Name": "test", "Description": null, "EngineeringUnits": null, "Comment": null, "CollectorName": "BRnjbnTC-Mkjk8_Calculation", "CollectionType": 2}
{"ErrorCode": 0, "ErrorMessage": null, "Name": "BR-MSL68.Lmkmnjk26_MIP.P1.ond", "Description": "Lmnnkj26_MlknlkIP..knnlkC01.Second", "EngineeringUnits": null, "Comment": null, "CollectorName": "BRknk-MSLAnk8_OPC_Intelnkjklution_Intkjkellutionkjkjkver", "CollectionType": 2}
{"ErrorCode": 0, "ErrorMessage": null, "Name": "BC-MSLA;k;okpoB0168.L26_MnlkjIP.PLC0jnlk1.UDE_SlkjlkIM_TRIlklj;lkGGER", "Description": "L26_Mjklj", "EngineeringUnits": null, "Comment": null, "CollectorName": "BRjkjTC-kljkljlkjik", "CollectionType": 2}

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@DataOrg 

if all 3 events are in New line then below conf should work.

SHOULD_LINEMERGE=false

 

KV

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Introducing the 2026 - 2027 SplunkTrust cohort!

The goal of the SplunkTrust™ membership has historically been to acknowledge and recognize those who go above ...

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...