tFileInputJSON only returns one row

[Anonymous]

Hi I am very new to this component and having problems trying to parse some simple JSON.

My JSON file has sever thousand rows like this.

{"timestamp":"2018-04-12 06:05:07,242","level":"INFO","message":"Application syncronisation"}

I have tried many combinations and the only settings that work are to use:

Read by JsonPath

Loop Json query "$"

and the json query in the mappings set to:

".timestamp"

".level"

".message"

This correctly retrieves the data but only the first row in the file?

Other changes cause an unable to parse error.

What am I doing wrong?

Many thanks in advance.

[vboppudi]

Hi,

Is it possible to provide more sample records and expected output?

Regards,

[Anonymous]

Hi Veeranjaneyulu 

below is more rows from the log file, each row is a logging entry.

{"timestamp":"2018-04-12 06:05:07,197","level":"INFO","message":"Application syncronisation "}
{"timestamp":"2018-04-12 06:05:07,197","level":"INFO","message":"Updating  sync information for ."}
{"timestamp":"2018-04-12 06:05:07,212","level":"INFO","message":"Team: 4810"}
{"timestamp":"2018-04-12 06:05:07,663","level":"ERROR","message":"There is no information"}
{"timestamp":"2018-04-12 06:05:07,666","level":"INFO","message":"Done"}
{"timestamp":"2018-04-12 06:05:07,666","level":"INFO","message":"Application syncronisation "}
{"timestamp":"2018-04-12 06:05:07,666","level":"INFO","message":"Updating sync information "}
{"timestamp":"2018-04-12 06:05:07,670","level":"INFO","message":"Team: 4810"}
{"timestamp":"2018-04-12 06:05:08,512","level":"INFO","message":"Posting  item to store"}
{"timestamp":"2018-04-12 06:05:09,930","level":"INFO","message":"Done"}
{"timestamp":"2018-04-12 06:05:09,930","level":"INFO","message":"Application syncronisation "}
{"timestamp":"2018-04-12 06:05:09,930","level":"INFO","message":"Updating sync information for ."}
{"timestamp":"2018-04-12 06:05:09,934","level":"INFO","message":"Team: 4810"}
{"timestamp":"2018-04-12 06:05:10,021","level":"INFO","message":"Done"}

I want to extract the start and end timestamps of a pair of log entries so I can assess the processing time of a job at different times of the day.

The files had in excess of 10,000 rows but only the first row is processed. The last image is where I dumped the output to a tLogRow.

I would expect to see around 5,000 rows of data in the file with the start and end times and the log message.

Many thanks

Dave

[vboppudi · Accepted solution]

Please try below

Regards,

[Anonymous]

Brilliant, Than you