May 2

Lazy mans WSProxy retrieve all

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…

Salesforce

2 min read

Feb 28

Review and Clean Up HTML Email Template CSS

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…

4 min read

Review and Clean Up HTML Email Template CSS

Feb 22

NTILE() Alternative for Buckets with a Fixed Number of Records

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…

Sql

2 min read

Feb 15

Convert XML to JSON using XSL in Salesforce Marketing Cloud

Using XSLT to transform XML to JSON with the help of AMPscript TransformXML(). Code snippet #1: XSL File An XSL file is a stylesheet that can be used to transform XML documents into other document types and to format the output. The AMPscript function TransformXML(1,2) utilises an XSL file as an input to apply an…

Sfmc

3 min read

Convert XML to JSON using XSL in Salesforce Marketing Cloud

Dec 16, 2021

Locate SFMC SendLog Data Extension

If you’re onboarding on to a new client or SFMC account or business unit, it can be a little tricky to locate the Send Log data extension. Usually it can be found using the SOAP APIP or WSproxy with conditional filters such as the below: { Property: "Name"…

Salesforce

1 min read

Nov 8, 2021

Import a DE Import Error Results file to a Data Extension

If a record/row is not processed due to an error during an Import Definition it is logged as a validation error. When validation errors are logged, a Results.txt file is generated and attached to the Import notification that is received. The results file is generated from validation errors. If rows…

Saleforce Marketing Cloud

3 min read

Import a DE Import Error Results file to a Data Extension

Nov 5, 2021

Cleanup Mobile Phone Numbers using SQL and Automation Studio

Salesforce Marketing Cloud’s Mobile Connect application requires the standardisation of mobile phone numbers in order for it to successfully deploy SMS or MMS sends to contacts. The application expects that mobile numbers are normalized which ensures that the number is in the correct format. Depending how you collect subscriber contact…

Sql

1 min read

Jun 23, 2021

SFMC Automation Studio API Objects

My intention for this post was to provide another avenue to access important information on some quirks of the Automation Studio API objects and their relations to each other. There are some fundamental knowledge nuggets buried deep in the official documentation, plus, some documentation is simply flat wrong. I like…

Salesforce

3 min read

Jun 15, 2021

SFMC Account User Audit: Check Roles and Permissions via API

Analysing your users’ role and permission settings can be troublesome to capture all these settings from within the Admin Setup interface. There is a way to export all roles and permissions from marketing cloud and you can retrieve this information by using the SOAP API on the AccountUser object. Below I outline a solution you can use to capture this information in Marketing Cloud and save to Data Extensions for easy use. We will be using WSProxy and SSJS in a script activity. Before we begin, the setup needs to be built in the Enterprise / Parent / Top level business unit.

Marketing

2 min read

SFMC Account User Audit: Check Roles and Permissions via API

Analysing your users’ role and permission settings can be troublesome to capture all these settings from within the Admin Setup interface.

There is a way to export all roles and permissions from marketing cloud and you can retrieve this information by using the SOAP API on the AccountUser object.

Below I outline a solution you can use to capture this information in Marketing Cloud and save to Data Extensions for easy use. We will be using WSProxy and SSJS in a script activity. Before we begin, the setup needs to be built in the Enterprise / Parent / Top level business unit.

Data Extension Setup

Jun 9, 2021

Get the Fields Available for Retrieval with “Describe”

By getting the fields available for retrieval, you can identify what kind of information is returned on a Retrieve call. Use the Describe method to get information about the metadata associated with an object. The Describe method supports a request for object metadata in the form of an ObjectDefinitionRequest and…

Sfmc

1 min read

Get the Fields Available for Retrieval with “Describe”

Lazy mans WSProxy retrieve all

Review and Clean Up HTML Email Template CSS

NTILE() Alternative for Buckets with a Fixed Number of Records

Convert XML to JSON using XSL in Salesforce Marketing Cloud

Locate SFMC SendLog Data Extension

Import a DE Import Error Results file to a Data Extension

Cleanup Mobile Phone Numbers using SQL and Automation Studio

SFMC Automation Studio API Objects

SFMC Account User Audit: Check Roles and Permissions via API

SFMC Account User Audit: Check Roles and Permissions via API

Data Extension Setup

Get the Fields Available for Retrieval with “Describe”

Charlie Fay