Member since
04-30-2022
20
Posts
2
Kudos Received
0
Solutions
11-09-2022
08:41 AM
No, it is not the problem, the problem is due to the EXT symbol, \n\r\t\" am filtering them in other processors, Am filtering more than 10000 JSON files the error happens only with 4 files that contain ETX.
... View more
11-09-2022
06:05 AM
Hello, I could not split a JSON due to a special ETX character existing in a JSON value, SplitJson processor returns an error that it is not a Valid JSON. The JSON looks like that: [ {"key_data":"val_data"}, {"key_data":"val_ETXdata"}, {"key_data":"val_data"}, {"key_data":"val_data"},... ] I used The next regex expression to replace it but it doesn't work: \x03(?=[^"]*") also [\x03](?=[^"]*") can someone show me a trick to remove it please, I would appreciate it.
... View more
Labels:
- Labels:
-
Apache NiFi
06-20-2022
06:28 AM
The solution you suggested there wasn't helpful.
... View more
06-20-2022
06:15 AM
To store each json flowfile as a single row in Postgres.
... View more
06-19-2022
02:19 PM
The following flowfile is the response of an "InvokeHttp": [ {"data1":"[{....},{...},{....}]","info":"data-from_site"}, {"data2":"[{....},{...},{....}]","info":"data-from_site"}, {"data3":"[{....},{...},{....}]","info":"data-from_site"} ] I did a "SplitJson", i got each json record as a single flowfile flowfile 1: {"data1":"[{....},{...},{....}]","info":"data-from_site"} flowfile 2: {"data2":"[{....},{...},{....}]","info":"data-from_site"} flowfile 3: {"data3":"[{....},{...},{....}]","info":"data-from_site"} I want to store each json record in each flowfile in a variable like that: variable1 = "{"data1":"[{....},{...},{....}]","info":"data-from_site"}" variable2 = "{"data2":"[{....},{...},{....}]","info":"data-from_site"}" variable3 = "{"data3":"[{....},{...},{....}]","info":"data-from_site"}" can someone show me how to store the json record in a variable !
... View more
Labels:
- Labels:
-
Apache NiFi
06-16-2022
07:18 AM
i did that , PutSQL accepts as you see the flowfile but it gives no output, also no data inserted to the DB
... View more
06-16-2022
06:40 AM
Can you please explain in more detail how to do this. i tried this solution but i think i missed something in the configuration Extract text is it correct how i loaded the text to the variable data then PUTSQL
... View more
06-16-2022
02:55 AM
I have a list of json records : [{}, {},{},{}] I splitted them to get : {},{},{},{} i need to load them to postgres as json datatype the result in postgres should be like that | data | |---------------------------------------| | { "name":"alex", "surname":"rolfi"}| | { "name":"rolf", "surname":"syon"}| | { "name":"med", "surname":"akil"}| i did that with the following processors : but Putdatabaserecord did not solve the problem
... View more
Labels:
- Labels:
-
Apache NiFi
04-30-2022
05:44 PM
I revoked an HTTP request the response is a list of JSON records [{},{},{}] within those records we have some keys with an "_" at the end. [ { "name":"json", "surname":"file", "which_extention_":"json", "size_of_file_":"266" }, {}, {} ] It needs to look like that: [ { "name":"json", "surname":"file", "which_extention":"json", "size_of_file":"266" }, {}, {} ] I tried to use replacetext with the regex : [_$]$ and with this _$ but doesn't work.
... View more
Labels:
- Labels:
-
Apache NiFi
- « Previous
-
- 1
- 2
- Next »