topic Re: JSON format - Duplicate value in field in All Apps and Add-ons

JSON format - Duplicate value in field

olivier_ma — Mon, 15 Jan 2018 17:15:54 GMT

Hello,

I'm currently working on a TA for browsing an Exchange mailbox and index some data extracted from emails.
I used the Add-on builder for this, and a python script as input method.

I've an issue with indexed data: every value of every field is duplicated.

I printed the JSON before writing the event into Splunk and it shows only 1 value.

{
    ...
    "content_type": "multipart/alternative;         boundary=\"b1_0b28091de0af32b14ad60d31c616a518\"",
    ...
    "date": "Tue, 7 Nov 2017 10:03:20 +0000", 
    ...
}

Here is a short part of the input script

for item in reporter_mailbox.inbox.all().iterator():
        # Analyze the item and get the JSON format
        json_data = self.__analyze_item(item)
        if json_data is None:
            self.helper.log_debug("No data written")
            continue
        self.helper.log_debug("JSON Data:\r\n %s" % json_data)
        # Create the Splunk event object related to this item
        event = self.helper.new_event(source=self.helper.get_input_type(), index=self.helper.get_output_index(),
                                      sourcetype=self.helper.get_sourcetype(), data=json_data)
        # Write the event into Splunk
        splunk_writer.write_event(event)

Also the props.conf

[my_ta]
#INDEXED_EXTRACTIONS = JSON
#KV_MODE = json
TIMESTAMP_FIELDS = date
TRUNCATE = 0
category = Splunk App Add-on Builder
pulldown_type = 1

# Fields Aliases
...

Anyone has an idea about where those duplicate values come from ?

Thanks for your help

Re: JSON format - Duplicate value in field

asieira — Tue, 29 Sep 2020 17:43:20 GMT

Take a look at https://answers.splunk.com/answers/223095/why-is-my-sourcetype-configuration-for-json-events.html and hopefully the solution for that also applies here.

Also, I see you have a commented-out INDEXED_EXTRACTIONS configuration. If you had that enabled when the events were indexed, that would have created one value for each field and saved that to disk persistently at index time. When you later disabled INDEXED_EXTRACTIONS and used the AUTO_KV_MODE to extract fields at search time, both field values would be combined for existing events. That could be the root cause of the duplication on existing events, no?

Re: JSON format - Duplicate value in field

mayurr98 — Mon, 15 Jan 2018 18:43:10 GMT

hey

add this in props.conf

KV_MODE = none
AUTO_KV_JSON = false
INDEXED_EXTRACTIONS = JSON

let me know if this helps !

Re: JSON format - Duplicate value in field

olivier_ma — Tue, 16 Jan 2018 12:09:43 GMT

Exactly what I'm looking for. Thanks 🙂

Re: JSON format - Duplicate value in field

olivier_ma — Tue, 16 Jan 2018 12:10:24 GMT

Thanks, that was the good solution.

Re: JSON format - Duplicate value in field

senmak — Mon, 11 Mar 2024 15:36:02 GMT

This is not working for my case , still i can see the duplication values in Verbrose mode and in configured all 2 settings in props.conf newly

Re: JSON format - Duplicate value in field

tozaltin — Thu, 27 Feb 2025 14:23:09 GMT

I don't have admin rights in Splunk. Is there an easy way to enforces this in the search query?