{"id":3884,"date":"2023-09-21T14:07:53","date_gmt":"2023-09-21T13:07:53","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3884"},"modified":"2024-03-19T13:25:10","modified_gmt":"2024-03-19T12:25:10","slug":"insertrow","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/dynamic-content\/data-tables\/insertrow\/","title":{"rendered":"InsertRow"},"content":{"rendered":"\n

InsertRow<\/code> method allows inserting a single row in a custom data table. This is an equivalent of SQL INSERT<\/code> query.<\/p>\n\n\n\n

This method is useful if you need to save some particular data related to each sent email, e.g. date or GUID.<\/p>\n\n\n\n

1. Method signature<\/strong><\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
InsertRow<\/span>(table<\/span>,<\/span> columns<\/span>,<\/span> values)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Parameter definition:<\/p>\n\n\n\n
Name<\/th>Type<\/th>Description<\/th><\/tr><\/thead>
table<\/td>string<\/td>Required. Table name.<\/td><\/tr>
columns<\/td>array of string<\/td>Required. Array of column names in table we insert a record to. Submitting the list is required to handle cases where some columns are omitted (e.g. those with default values) or supplied in different order than in the table.<\/td><\/tr>
values<\/td>array of object<\/td>Required. Array of column values. Values are passed as object, so multiple types can be passed (numeric, text etc). See examples.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
2. Usage and examples<\/strong><\/p>\n\n\n\n
You can call InsertRow<\/code> method using curly braces syntax. You may put in anywhere in the email template code since its output is empty string.<\/p>\n\n\n\n
Example 1 – the most simple call<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
$<\/span>{<\/span>InsertRow<\/span>(<\/span>'<\/span>MyTable<\/span>'<\/span>,<\/span> <\/span>new<\/span> <\/span>string<\/span>[] <\/span>{<\/span>'<\/span>MyColumn<\/span>'<\/span>},<\/span> <\/span>new<\/span> <\/span>object<\/span>[] <\/span>{<\/span>'<\/span>foobar<\/span>'<\/span>}<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Equivalent SQL query:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
INSERT INTO <\/span>MyTable<\/span> (MyColumn) <\/span>VALUES<\/span> (<\/span>'<\/span>foobar<\/span>'<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This assumes we have a simple table with one column.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Example 2 – inserting a record to table with multiple columns of different types<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
$<\/span>{<\/span>InsertRow<\/span>(<\/span>'<\/span>MyTable<\/span>'<\/span>,<\/span> <\/span>new<\/span> <\/span>string<\/span>[] <\/span>{<\/span>'<\/span>MyIntColumn<\/span>'<\/span>,<\/span> <\/span>'<\/span>MyTextColumn<\/span>'<\/span>,<\/span> <\/span>'<\/span>MyDateColumn<\/span>'<\/span>},<\/span> <\/span>new<\/span> <\/span>object<\/span>[] <\/span>{<\/span>123<\/span>,<\/span> <\/span>'<\/span>foobar<\/span>'<\/span>,<\/span> new System.DateTime(<\/span>2015<\/span>,<\/span> <\/span>1<\/span>,<\/span> <\/span>26<\/span>,<\/span> <\/span>14<\/span>,<\/span> <\/span>0<\/span>,<\/span> <\/span>0<\/span>)<\/span>}<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Equivalent SQL query:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
INSERT INTO <\/span>MyTable<\/span> (MyIntColumn<\/span>,<\/span> MyTextColumn<\/span>,<\/span> MyDateColumn) <\/span>VALUES<\/span> (<\/span>123<\/span>,<\/span> <\/span>'<\/span>foobar<\/span>'<\/span>,<\/span> <\/span>'<\/span>2015-01-26 14:00:00<\/span>'<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Of course, it is possible to use any of available predefined variables<\/a>, snippets<\/a> or subscriber properties as inserted values.<\/p>\n","protected":false},"author":6,"featured_media":0,"parent":3874,"menu_order":215,"template":"","format":"standard","emp-category":[],"class_list":["post-3884","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/6"}],"version-history":[{"count":2,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3884\/revisions"}],"predecessor-version":[{"id":8868,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3884\/revisions\/8868"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3874"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3884"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}