AMPscript LookUp and Output JSONLearn how to use SFMC AMPscript and output a JSON array with the row data retrieved.Mar 22Mar 22
A Discussion On Marketing Cloud Triggered SendsA triggered email is a message automatically sent to a contact in response to a specific user action or event, delivered to the inbox…Dec 11, 2023Dec 11, 2023
Salesforce Marketing Cloud: Passing a null AMPscript variable to a Server-Side Javascript variableTackle ‘Object cannot be cast from DBNull to other types’ error in Salesforce Marketing Cloud, unveiling insights for seamless data…Nov 22, 2023Nov 22, 2023
Translate Mobile Connect Keyword GUID To Its Clear Text NameA quick hack to find the GUID and Clear Text Name for your Mobile Connect keywords. Useful for SQL on MobileConnect DataViews.May 22, 20231May 22, 20231
Search all automations for a notification email addressFind out how to access the Automation Notification Email settings via API in Salesforce Marketing Cloud.Apr 29, 20231Apr 29, 20231
SFMC SSJS Function to Convert a Date Object to ISO FormatSalesforce Marketing Cloud’s version of Server Side JavaScript (SSJS) doesn’t support toISOString. I share the alternatives to overcome…Dec 22, 2022Dec 22, 2022
SQL: BASE64 ENCODE/DECODETransact-SQL does not include any built in function to convert binary type into base64 string and vice versa. However, we can use XML…Oct 17, 2022Oct 17, 2022
How does Ampscript RaiseError function work?The RaiseError function aborts the send (email and sms) and allows the generation of a custom error message. It is useful for exception…Oct 8, 20222Oct 8, 20222
AmpScript Now and GetSendTime FunctionsThe 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.Aug 31, 2022Aug 31, 2022
SFMC SSJS: How to use URL form encoded with Script.Util.HttpRequestUnderstand how urlencoded API payloads need to be created with the Script.Util.HttpRequest() function in Salesforce Marketing Cloud SSJS.Jul 12, 20221Jul 12, 20221