About kaluman

kaluman · ‎01-13-2021

@FaerballertThanks again. It turned out that I just should ignore the question marks in the SQL statement. Everything works for now.

kaluman · ‎01-13-2021

@Faerballert Thank you very much. This is what I am asking for 😄 But I am having still the problem that the output queue of my ConvertJSONtoSQL, is fillled with the question mark "?". Am I still missing something? I thought it would automatically map the json field to the postgresql column and fill the VALUE statement with the values from the json.

kaluman · ‎01-12-2021

I am new to NiFi, and I am trying to put some data into a postgresql database. I am trying to do it with the ConvertJSONtoSQL processor, unfortunately the JSON keyname and the columename of the table having not the same names (for example keyname = ServiceGroup and columnname = service_group). How can I map the key- and the columnname, so I can store the data in the tablename.

Online	Offline
Last Visited	‎02-10-2021 11:53 AM

Date Registered	‎01-12-2021 03:50 PM
Last Visited	‎02-10-2021 11:53 AM
Total Messages Posted	3

Re: Unmatched JSON keyname and table columnname

Re: Unmatched JSON keyname and table columnname

Unmatched JSON keyname and table columnname