Getting Data In

uploading json data file does not get parsed properly

sawgata12345
Path Finder

Hi I tried to upload file in json format but after uploading whole json is showing as single entry and no event getting gerenated from it. What is the correct JSON format for splunk? Is there any special format of JSON that Splunk understands?

0 Karma
1 Solution

sawgata12345
Path Finder

Hi,
I found the answer to my question.
The json file should be in below format
{
"key":"value",
"key2":"value2"
}
{
"key":"value",
"key2":"value2"
}

Just upload the file it will get indexed and search queries also work nicely

View solution in original post

sawgata12345
Path Finder

Hi,
I found the answer to my question.
The json file should be in below format
{
"key":"value",
"key2":"value2"
}
{
"key":"value",
"key2":"value2"
}

Just upload the file it will get indexed and search queries also work nicely

jbarlow_splunk
Splunk Employee
Splunk Employee

no special format. just json

you may need to do INDEXED_EXTRACTIONS = json in props.conf..
per
http://docs.splunk.com/Documentation/SplunkCloud/latest/Data/Extractfieldsfromfileswithstructureddat...

there is also search time KV_MODE=json

(but do not set both KV_MODE and INDEXED_EXTRACTIONS ...its an either or,,, will get duplicate fields if both set)
https://docs.splunk.com/Documentation/Splunk/latest/Admin/Propsconf

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What are your props.conf settings for that sourcetype?

---
If this reply helps you, Karma would be appreciated.
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!

[Puzzles] Solve, Learn, Repeat: Classic British Rock Bands

This puzzle series (first published here) is based on extracting information from statements about well-known ...

New to the Community? Join Us for an Exclusive Post .conf26 Welcome Session (Plus a ...

Keep the .conf26 Energy Going: Welcome to the Splunk Community! Whether we scanned your badge at the Community ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Register to Attend   Join our Tech Talk ...