insert splitted records in database using apache n...

sahil0915 · ‎06-30-2022

I want to insert splitted records from splitjson processor in database table using nifi. For eg: Below is splitjson processor output. I want to push all the flow files in database table having same fragment.identifier. table columns are mentioned below: identity_id|json|person_ref where identity_id should be auto sequence number json would flow-file content person_ref is the foreign key having int data type so table will have 13 entries and identity_id column will be unique numbers in sequence, json column will have different flow file contents and person_ref column should be same for all 13 entries lets say 111.

sahil0915 · ‎04-15-2022

field to add "quality" input json : { "json_data": { "id": "1234", "items": [ { "id": "000000", "metadata": { "newId": "82896888047600" } } ] } } output json : { "json_data": { "id": "1234", "items": [ { "id": "000000", "metadata": { "newId": "82896888047600", "quality" :"good" } } ] } }

Online	Offline
Last Visited	‎08-12-2022 05:37 AM

Date Registered	‎04-14-2022 01:24 AM
Last Visited	‎08-12-2022 05:37 AM
Total Messages Posted	5

insert splitted records in database using apache n...

add node in json array using Apache nifi