Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Turn Text into Attributes

avatar

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

1 ACCEPTED SOLUTION

avatar

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 solution in original post

2 REPLIES 2

avatar

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

avatar

Hi @SAMSAL ,

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

Regards
Maik