Although the Notifications info is technically not a retrievable field within the Automation SOAP object, it is worth noting that this object allows the use of a wildcard character “*” to retrieve all fields. …

What is ISO-8601 DateTime Format? ISO 8601 is an international standard covering the worldwide exchange and communication of date and time related data. Whats the reason for this post? Newer versions of JavaScript have a toISOString method. Meanwhile Salesforce Marketing Cloud’s version of Server Side JavaScript is based on ECMA 3 which is an older version lacking many new advancements. …

Transact-SQL does not include any built in function to convert binary type into base64 string and vice versa. However, we can use XML built-in options in order to convert VARBINARY into Base64. FOR XML and binary data When you use the FOR XML clause in a SELECT statement, regardless of the mode used, any BINARY…

Salesforce Developers|Ampscript Raises the error given in string and stops processing of job. If optional B1 is included with a value of true, this…developer.salesforce.com The RaiseError function aborts the send (email and sms) and allows the generation of a custom error message. It is useful for exception handling in your code, if an unexpected result occurs. When used in conjunction with a conditional statement, it helps to ensure that your email does not get…

The below post is a dump of some notes I have stored on my computer and refer to every now and then. Sharing in case it’s useful to others. Now Function Now() is in Central Standard Time (CST) without daylight saving time. The default value is false : Now() → Now(0) Now(0) List…

Content Type The application/x-www-form-urlencoded content type describes POST data that is sent in a single block in the HTTP message body. But how is the body formatted? It is basically a long URL encoded string with key-value tuples separated by an ampersand '&', with a '=' between the key and the value…

The WSProxy() object offers several retrieve options, depending on the level of complexity you need. The simplest option takes the type of object as the first parameter, and an array of object property names to retrieve. var prox = new Script.Util.WSProxy(); var cols = ["Name", "CustomerKey", "CategoryID", "IsSendable"]; var data…

Over the years I have worked with many clients to deploy countless email campaigns. Over this period I have seen time and time again amendments made to email templates that seek to fix once off style bugs or cater to seasonal creative designs. Oftentimes, these changes are implemented in haste…

NTILE(x) is a window function that distributes rows into a specified number of approximately equal buckets. Each row is assigned a bucket number representing the group to which the row belongs. The input into the function is a positive integer which represents the number of buckets into which the rows…