×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
sunallen
Engager
Member since: ‎08-22-2020
‎06-17-2024
Community Statistics
Posts 3
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎08-22-2020
Activity Feed
Topics I've Started
View All

Re: Timestamp Parsing in JSON failed

by in Getting Data In
‎06-09-2021 06:16 PM
‎06-09-2021 06:16 PM
Thank you. ... View more

Re: Timestamp Parsing in JSON failed

by in Getting Data In
‎06-08-2021 06:28 PM
‎06-08-2021 06:28 PM
My props.conf DATETIME_CONFIG = LINE_BREAKER = (.){"ptt NO_BINARY_CHECK = true TRUNCATE = 0 category = Custom disabled = false pulldown_type = 1 MAX_TIMESTAMP_LOOKAHEAD = 61 TIME_FORMAT = %Y-%m-%dT%T TIME_PREFIX = \"time\":"(.*?)" INDEXED_EXTRACTIONS = json ... View more

Timestamp Parsing in JSON failed

by in Getting Data In
‎06-08-2021 08:04 AM
‎06-08-2021 08:04 AM
Can anyone help me with best configurations for timestamp parsing (where "time" is the actual time) for following JSON format :   {"status":0,"description":"OK","data":{"railway_bloodPressure":[{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":67.0,"time":"2021-03-09 15:59:00","endTime":"2021-03-09 15:59:00","sys":124.0,"deviceId":"testing","dia":80.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":71.0,"time":"2021-03-09 16:09:00","endTime":"2021-03-09 16:10:00","sys":-1.0,"deviceId":"testing","dia":-1.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":69.0,"time":"2021-03-09 16:15:00","endTime":"2021-03-09 16:15:00","sys":127.0,"deviceId":"testing","dia":79.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":66.0,"time":"2021-03-09 16:25:00","endTime":"2021-03-09 16:26:00","sys":-1.0,"deviceId":"testing","dia":-1.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":67.0,"time":"2021-03-09 16:35:00","endTime":"2021-03-09 16:35:00","sys":125.0,"deviceId":"testing","dia":81.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":68.0,"time":"2021-03-09 16:45:00","endTime":"2021-03-09 16:46:00","sys":-1.0,"deviceId":"testing","dia":-1.0},{"ptt":-1.0,"sourceType":"PPG","mean":-1.0,"hr":68.0,"time":"2021-03-09 16:51:00","endTime":"2021-03-09 16:51:00","sys":127.0,"deviceId":"testing","dia":79.0}]}}   I have alrady tried in props.conf...but keep failing... ... View more
Labels
Contact Me
Online Status
Offline
Date Last Visited
‎06-17-2024 08:31 AM