<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How can I fix this so that it pulls in the timefield correctly, without any splitting of the JSON object? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/How-can-I-fix-this-so-that-it-pulls-in-the-timefield-correctly/m-p/641077#M109357</link>
    <description>&lt;P&gt;I have events like so:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-CODE lang="javascript"&gt;{"action": {"result": true, "type": "login"}, "actor": {"email": "test.email@domain.tld", "id": "0123456789abcdef0123456789abcdef", "ip": "1.2.3.4", "type": "user"}, "id": "01234567-89ab-cdef-0123-456789abcdef", "newValue": "audit", "oldValue": "review", "owner": {"id": "fedcba9876543210fedcba9876543210"}, "when": "2023-04-21T18:52:32Z", "account_name": "test_account"}&lt;/LI-CODE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The props.conf file is as so:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-CODE lang="markup"&gt;[cloudflare_audit]
NO_BINARY_CHECK=true
INDEXED_EXTRACTIONS=JSON
TIMESTAMP_FIELDS=when
disabled=false
pulldown_type=true&lt;/LI-CODE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;When I do this, I wind up with two records per event, &lt;EM&gt;split&lt;/EM&gt; at that TIME_PREFIX setting, each record with the time found in "when".&lt;/P&gt;
&lt;P&gt;Things I've tried so far, based on the above:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Adding "KV_MODE=none" -- The event is parsed as JSON, but the time is ignored&lt;/LI&gt;
&lt;LI&gt;Adding "TIME_PREFIX=when": "" and LINE_BREAKER=}$ -- The event is split on "when", again&lt;/LI&gt;
&lt;LI&gt;Removing "INDEXED_EXTRACTIONS=true" and adding "AUTO_KV_JSON=true" -- The event is parsed as JSON, but the time is ignored&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Two questions:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;How can I fix this so that it pulls in the timefield correctly, without any splitting of the JSON object?&lt;/LI&gt;
&lt;LI&gt;Why is it so difficult to ingest JSON logs?&lt;/LI&gt;
&lt;/OL&gt;</description>
    <pubDate>Tue, 09 May 2023 06:28:13 GMT</pubDate>
    <dc:creator>CMSchelin</dc:creator>
    <dc:date>2023-05-09T06:28:13Z</dc:date>
    <item>
      <title>How can I fix this so that it pulls in the timefield correctly, without any splitting of the JSON object?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-can-I-fix-this-so-that-it-pulls-in-the-timefield-correctly/m-p/641077#M109357</link>
      <description>&lt;P&gt;I have events like so:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-CODE lang="javascript"&gt;{"action": {"result": true, "type": "login"}, "actor": {"email": "test.email@domain.tld", "id": "0123456789abcdef0123456789abcdef", "ip": "1.2.3.4", "type": "user"}, "id": "01234567-89ab-cdef-0123-456789abcdef", "newValue": "audit", "oldValue": "review", "owner": {"id": "fedcba9876543210fedcba9876543210"}, "when": "2023-04-21T18:52:32Z", "account_name": "test_account"}&lt;/LI-CODE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The props.conf file is as so:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-CODE lang="markup"&gt;[cloudflare_audit]
NO_BINARY_CHECK=true
INDEXED_EXTRACTIONS=JSON
TIMESTAMP_FIELDS=when
disabled=false
pulldown_type=true&lt;/LI-CODE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;When I do this, I wind up with two records per event, &lt;EM&gt;split&lt;/EM&gt; at that TIME_PREFIX setting, each record with the time found in "when".&lt;/P&gt;
&lt;P&gt;Things I've tried so far, based on the above:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Adding "KV_MODE=none" -- The event is parsed as JSON, but the time is ignored&lt;/LI&gt;
&lt;LI&gt;Adding "TIME_PREFIX=when": "" and LINE_BREAKER=}$ -- The event is split on "when", again&lt;/LI&gt;
&lt;LI&gt;Removing "INDEXED_EXTRACTIONS=true" and adding "AUTO_KV_JSON=true" -- The event is parsed as JSON, but the time is ignored&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;Two questions:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;How can I fix this so that it pulls in the timefield correctly, without any splitting of the JSON object?&lt;/LI&gt;
&lt;LI&gt;Why is it so difficult to ingest JSON logs?&lt;/LI&gt;
&lt;/OL&gt;</description>
      <pubDate>Tue, 09 May 2023 06:28:13 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-can-I-fix-this-so-that-it-pulls-in-the-timefield-correctly/m-p/641077#M109357</guid>
      <dc:creator>CMSchelin</dc:creator>
      <dc:date>2023-05-09T06:28:13Z</dc:date>
    </item>
  </channel>
</rss>

