question Turn Text into Attributes in Support Questions

Turn Text into Attributes

CommanderLaus — Tue, 12 Sep 2023 14:18:13 GMT

Hi everyone,

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 Proxy-Agent: Fortinet-Proxy/1.0 Content-Type: image/jpeg Connection: keep-alive Date: Tue, 12 Sep 2023 14:05:43 GMT Server: Apache Strict-Transport-Security: max-age=31536000 URL: https://test.com

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:

HTTP/1.1
Proxy-Agent
Content-Type
Connection
Date
...

Best regards

Maik

Re: Turn Text into Attributes

SAMSAL — Tue, 12 Sep 2023 15:55:03 GMT

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.

Thanks

Re: Turn Text into Attributes

CommanderLaus — Wed, 13 Sep 2023 09:50:08 GMT

Hi @SAMSAL ,

that's pretty simple, but works fine for me. Thanks for the advice.

Regards
Maik