I use NiFi to frequently check if a website is up or down. I get the following response as text in a single Flowfile:
HTTP/1.1: 200 Connection established
Date: Tue, 12 Sep 2023 14:05:43 GMT
How can I turn these lines into Key/Value-Pairs or Attributes, to use them with further processors? My goal is to save these Informations in an mySQL Database where the following fields are given:
Hi @CommanderLaus ,
The easiest way I can think of is to use the ExtractText Processor where you define an attribute as dynamic property and assign the Regex as follows:
I did only the first three fields but you can do the others the same way.
If that helps please accept solution.
View solution in original post
Hi @SAMSAL ,
that's pretty simple, but works fine for me. Thanks for the advice.