Created on 07-27-2023 05:45 PM - edited 07-27-2023 06:38 PM
I have a flow file whose content is Json,
I have table with schema
Name Null Type
-------- -------- ------------
SEQ_NUM NOT NULL NUMBER(22)
REQ_PYLD NOT NULL CLOB
CRTE_DT NOT NULL TIMESTAMP(6)
UPDT_DT NOT NULL TIMESTAMP(6)
I want Entire Json to be inserted into REQ_PYLD column
I am trying to use PutDatabaseRecord with TreeReader but it is not working
Can Someone suggest the correct processor or flow to achieve this in NIfi
Created 07-27-2023 10:32 PM
@Anderosn, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi experts @cotopaul @SAMSAL @MattWho @steven-matison who may be able to assist you further.
Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.
Regards,
Vidya Sargur,Created 07-28-2023 05:28 AM
Hi @Anderosn,
Similar question was asked before, see if the following posts can help:
If Any of the links work for your case please accept solution.
Thanks