The Upsert Node takes a connection object and tells it how to communicate with the database. You can configure Project level connections in the Project Editor.
The Upsert Node takes an array or single object from the
Data conduit and creates/modifies records in the database. It maps each object(s) properties to the columns in the configured
Table Name. Your
Table Name may contain a schema as well. Properties not found as columns are ignored.
Update Records tells the Upsert Node to update existing objects. Checking this requires you to specify one or more Primary Key(s) separated by semi-colons.
Create Records tells the Upsert Node to create all objects in the
Create Records and
Update Records tells the Upsert Node to update a record if it exists by key and creating it otherwise.
When the Upsert Node finishes, it outputs the number of records created/modified.