Charlie Fay – Medium

Charlie Fay

AMPscript LookUp and Output JSON

Learn how to use SFMC AMPscript and output a JSON array with the row data retrieved.

3 min readMar 22, 2024

--

AMPscript LookUp and Output JSON

--

Charlie Fay

A Discussion On Marketing Cloud Triggered Sends

A triggered email is a message automatically sent to a contact in response to a specific user action or event, delivered to the inbox…

9 min readDec 11, 2023

--

A Discussion On Marketing Cloud Triggered Sends

--

Charlie Fay

Salesforce Marketing Cloud: Passing a null AMPscript variable to a Server-Side Javascript variable

Tackle ‘Object cannot be cast from DBNull to other types’ error in Salesforce Marketing Cloud, unveiling insights for seamless data…

3 min readNov 22, 2023

--

Salesforce Marketing Cloud: Passing a null AMPscript variable to a Server-Side Javascript variable

--

Charlie Fay

Translate Mobile Connect Keyword GUID To Its Clear Text Name

A quick hack to find the GUID and Clear Text Name for your Mobile Connect keywords. Useful for SQL on MobileConnect DataViews.

2 min readMay 22, 2023

--

Translate Mobile Connect Keyword GUID To Its Clear Text Name

--

Charlie Fay

Search all automations for a notification email address

Find out how to access the Automation Notification Email settings via API in Salesforce Marketing Cloud.

1 min readApr 29, 2023

--

1

--

1

Charlie Fay

SFMC SSJS Function to Convert a Date Object to ISO Format

Salesforce Marketing Cloud’s version of Server Side JavaScript (SSJS) doesn’t support toISOString. I share the alternatives to overcome…

3 min readDec 22, 2022

--

SFMC SSJS Function to Convert a Date Object to ISO Format

--

Charlie Fay

SQL: BASE64 ENCODE/DECODE

Transact-SQL does not include any built in function to convert binary type into base64 string and vice versa. However, we can use XML…

2 min readOct 17, 2022

--

--

Charlie Fay

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…

4 min readOct 8, 2022

--

2

How does Ampscript RaiseError function work?

--

2

Charlie Fay

AmpScript Now and GetSendTime Functions

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.

2 min readAug 31, 2022

--

AmpScript Now and GetSendTime Functions

--

Charlie Fay

SFMC SSJS: How to use URL form encoded with Script.Util.HttpRequest

Understand how urlencoded API payloads need to be created with the Script.Util.HttpRequest() function in Salesforce Marketing Cloud SSJS.

2 min readJul 12, 2022

--

1

--

1

Charlie Fay

Charlie Fay

I write about Salesforce Marketing Cloud, Marketing Automation, Development and Programmatic Languages. I enjoy solving complex problems with simplicity.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams