I get data from a CRM system and match it with the records in user accounts table in a postgres database. Wherever, I don’t find a match, I am inserting a record in the user accounts table which creates their login information. Thereafter, the application that is using the database sends an activation email to the user to setup their login password and obtain access to the application.
For the matching user account records, I want to update their records with any changes in their contact information (name, address, phone number, etc.) in the user accounts table in the database.
I am unable to find an action to update database table records using EasyMorph. Can someone help me find the right action if there exists one?
I have read in forum posts that updating is currently not supported in EasyMorph. The suggested solution is to save records in temporary storage, delete the matching records and insert the records in the database table from the CRM. This would not work for my use case since these are user account records that have permissions, login information and other dependent data associated with each user.
How can I solve the issue of updating database data for matching records?