EnsureData¶

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

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

Parameters¶

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
});