Dynamic Content Documentation

UpdateRow

UpdateRow method updates a single row in a custom data table with new data. This is an equivalent of SQL UPDATE query.

It is possible to update a single column or multiple columns with one query. Updating multiple rows is disabled, to avoid damaging large amounts of data by mistake.

This method may be useful if you need to mark in your custom data that an email was sent to particular subscriber. You may want to save sending date, or generate emails with single-use offers (such as unique coupons), using both GetRows and UpdateRow methods.

1. Method signature

UpdateRow(table, updates, filters, filterOperator)

Parameter definition:

Update object parameter definition

Filter object parameter definition

Note: Filters work the same way as in GetRows method. See GetRows documentation for more details and examples.

2. Usage and examples

You can call UpdateRow method using curly braces syntax. You may put in anywhere in the email template code since its output is empty string.

Example 1 - the most simple call

${UpdateRow('MyTable', new [] {new Update('MyColumn', 456)})}

Equivalent SQL query:

UPDATE TOP(1) MyTable SET MyColumn = 456

This however has limited use, since in most cases, you will want to update a specific row (and not first found). Following examples show how to use filters to achieve this.

Example 2 - updating single column in a row matching specified criteria

${UpdateRow('MyTable', new [] {new Update('MyColumn', 456)}, new [] {new Filter('CustomerId', EQ, 123)})}

Equivalent SQL query:

UPDATE TOP(1) MyTable SET MyColumn = 456 WHERE CustomerId = 123

Example 3 - updating multiple columns

${UpdateRow('MyTable', new [] {new Update('MyColumn', 456), new Update('ProductName', 'Snowboard')}, new [] {new Filter('CustomerId', EQ, 123)})}

Equivalent SQL query:

UPDATE TOP(1) MyTable SET MyColumn = 456, ProductName = 'Snowboard' WHERE CustomerId = 123

It is of course possible to specify multiple filters - the equivalent of AND logical operator (or a different operator specified using filterOperator parameter). It is also possible (and in most cases necessary) to match updated rows with subscriber properties, email etc.

See GetRows method examples for more information.

Example 4 - incrementing column value

${UpdateRow('MyTable', new [] {new Update('MyCounterColumn', 5, UpdateType.Increment)}, new [] {new Filter('CustomerId', EQ, 123)})}

Equivalent SQL query:

UPDATE TOP(1) MyTable SET MyCounterColumn = MyCounterColumn + 5 WHERE CustomerId = 123

It is possible to perform multiple increments in a single call or mix regular updates and increments.

Example 5 - real-life scenario, sending emails with single-use coupons

<p>Hello! Here's your coupon: ${rows[0]['CouponCode']}</p>

${UpdateRow('Coupons', new [] {new Update('IsUsed', true), new Update('UsedOn', System.DateTime.UtcNow)}, new [] {new Filter('CouponId', EQ, rows[0]['CouponId'])})}

Report abuse