$Database.EnsureData

Overview

Inserts or updates a row in table by specified column and value as single criteria. Only included columns get updated.

DataRow $Database.EnsureData(schema: string, table: string, column: string, value: any, input: object, initInput: object)

string schema

Name of target schema

string table

Name of target table

string column

Name of column to use as criteria

any value

Value of column to use as criteria

object input

Object or function for column values for updating.

object initInput

Object or function for initialize for new rows. Optional.

$Database.EnsureData("MySchema", "MyTable", "Id", id, {
    Id : id,
    Name : $Xml.Evaluate('Name')
}, {
    CreateDate : DateTimeOffset.now
});