Support Questions
Find answers, ask questions, and share your expertise

How to convert JSON to CEF in nifi please help

Highlighted

How to convert JSON to CEF in nifi please help

Explorer

Please help

I have bunch of logs that need to be converted but I have them in json format and I need to covert them to CEF format . What processor or data flow should I use

2 REPLIES 2
Highlighted

Re: How to convert JSON to CEF in nifi please help

Super Collaborator

you find a good explanation here https://community.hortonworks.com/questions/63995/convert-json-to-csv-using-nifi.html on how to convert json to csv. If you use spaces instead of the the commas it should do the trick.

Of course you need to know how to identify the different values for the CEF format in your json files.

Re: How to convert JSON to CEF in nifi please help

Explorer

Hey Harald,

Thanks for your response, I'm spespically looking for CEF format. I have tried the indexation like this "$.header_version | $.header_deviceVendor | etc" but there are a bunch of logs with different headers, Some headers are Identical but some are different. I just don't want null values.