They said, “just read the official documentation”…
Category: Salesforce Marketing Cloud
Tips for the technical side of Salesforce Marketing Cloud.
Updating Salesforce Objects with Server-Side JavaScript
If the custom preference center in your integrated Marketing Cloud account needs to update Salesforce object attributes, you’re probably acquainted with the UpdateSingleSalesforceObject, RetrieveSalesforceObjects and CreateSalesforceObject AMPscript functions.
Well, if you’re like me and you’d rather build your custom preference center with Server-Side JavaScript (SSJS), then you’ll need a way to use these AMPscript-only functions. Here’s my general approach for wrapping the AMPscript function in SSJS:
Triggering Multiple Emails with REST
If you need to trigger one Marketing Cloud email to multiple recipients in a single REST API call, here’s how you do it:
Request a token (OAuth 2.0)
Trigger one email to multiple recipients:
Reference:
Clearing a Data Extension with a SQL Query
If you ever need an automated way to clear a data extension, you can simply use a SQL query that does an overwrite. The query doesn’t need a from clause if you specify any required columns in the target.
For example, if EmailAddress is required in the target data extension, simply set the value to null and add an alias:
Picking rows with partitions
I’m constantly faced with situations with data in Salesforce Marketing Cloud where I need to select or identify rows based on some ordered criteria. The row_number() over (partition by x order by y) as ranking is my go-to method.
This particular query finds a random row for each bounce category in the _bounce data view:
Recently, found this shorter method using top 1 with ties:
Credit @TheGameiswar