topic Json data extraction from a log file in Talend Studio

Json data extraction from a log file

Knowme — Sat, 16 Nov 2024 00:13:13 GMT

Hi,

I have a .log file which is having json script in the middle of some text data. I need to parse the json data from this and load into database. I tried tJsonInput but its not working. Any suggestions?

Thank you

Re: Json data extraction from a log file

Anonymous — Tue, 27 Apr 2021 05:30:20 GMT

Hello,

TalendHelpCenter: tExtractJsonFields component is used to extract data from a Json string.

Let us know if it is what you are looking for.

Best regards

Sabrina

Re: Json data extraction from a log file

Knowme — Tue, 04 May 2021 19:38:18 GMT

I tried that but since the format and text fields are not consistent its not getting the right schema.

Re: Json data extraction from a log file

gjeremy1617088143 — Wed, 05 May 2021 07:53:43 GMT

Hi, you need to extract first the json from the rest of the text then you can use tExtractJsonFields to parse json data.

Could you send us an example of the log file content ?