In my flow I am pulling data from a Json, splitting the Json and then inserting that into a postgres table using the putdatabaserecord processor. I have been using the insert statement option and it has been working fine but now I am trying to figure out how to do a INSERT INTO table ON CONFLICT UPDATE statement. I have the statement.type attribute set to SQL and am trying to do the query:
INSERT INTO table (column1 ,column2, column3, column4) VALUES() ON CONFLICT (rfidnumber) DO UPDATE; I am getting the error 'Record schema does not contain filed containing SQL'. So two th Any help would be appreciated. Thanks, Austin
