DeleteRow

DeleteRow method can be used to delete a single row from custom data table. This is an equivalent od SQL DELETE query.

It is best to be very careful with this method to avoid losing your data by accident. Deleting multiple rows is disabled, to avoid deleting whole tables by mistake.

This method can be useful if it is necessary to delete records from your custom data when an email is sent. E.g. this may be a list of customers who did not received any offer or a list of unique offers that cannot be sent twice, etc.

1. Method signature

DeleteRow(table, filters, filterOperator)

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 DeleteRow 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

${DeleteRow('MyTable')}

Equivalent SQL query:

DELETE TOP(1) FROM MyTable

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

Example 2 - deleting a row matching specified criteria

${DeleteRow('MyTable', new [] {new Filter('CustomerId', EQ, 123)})}

Equivalent SQL query:

DELETE TOP(1) FROM MyTable WHERE CustomerId = 123

Example 3 - using multiple filters

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

Equivalent SQL query:

DELETE TOP(1) FROM MyTable WHERE CustomerId = 123 AND MyColumn = 456

It is also possible (and in most cases necessary) to match deleted rows with subscriber properties, email etc.

See GetRows method examples for more information.

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

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

${DeleteRow('Coupons', new [] {new Filter('CouponId', EQ, rows[0]['CouponId'])})}