Skip to main content
CommanderLaus
CommanderLaus
Silver ⭐️⭐️
September 12, 2023
Solved

Turn Text into Attributes

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

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
September 12, 2023

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:

SAMSAL_0-1694534042115.png

I did only the first three fields but you can do the others the same way.

If that helps please accept solution.

Thanks

View in thread

2 replies

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
September 12, 2023

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:

SAMSAL_0-1694534042115.png

I did only the first three fields but you can do the others the same way.

If that helps please accept solution.

Thanks

Translate
    CommanderLaus
    CommanderLausAuthor
    Silver ⭐️⭐️
    September 13, 2023

    Hi @SAMSAL ,

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

    Regards
    Maik

    Translate
    Terms & ConditionsAccessibility statement