-
READ MORE
For a long, long time – the only way to do this was to first build the Automation in SOAP API, via the Automation Object, and then build out the file trigger in the ‘FileTrigger’ Object and attach it to the original Automation. It was a very confusing and very buggy endeavor. To this day, […]
-
READ MORE
This one took a LOT of digging and trial and error to figure out. Most of the normal SQL ways to accomplish this (like STRING_SPLIT, etc) are not supported in SFMC, making it heavily reliant on duct tape and bubblegum. Due to my recent exposure to the XML aspects of SQL, I thought that perhaps […]
-
READ MORE
Connections is an annual conference hosted by Salesforce focused mostly around Salesforce Marketing Cloud. This conference was adopted from the ‘Exact Target’ days where this was their annual conference. The first thing of note is that the ‘general floor’, where all the sponsor booths were, was labeled as ‘Campground’ and the decorations certainly lived up […]
-
READ MORE
Unfortunately there is no way to edit the primary key inside of an existing data extension. ” After a Data Extension has been created, any established Primary Keys cannot be modified. ” (src). This instead would require you to create a new Data Extension with the required keys/settings. Now this is all well and good […]
-
READ MORE
**EDIT** 2019-09-22: Added new function at bottom of article to allow for Sendable and Retention inside DE. Copying a data extension inside the UI of SFMC is not too difficult and can be done via the Wizard. The issue comes in that this is a purely manual process and cannot be automated or programmatic. There […]
-
READ MORE
Usually you are limited to the functions of HTTP GET or HTTP POST in SSJS or AMPscript to send an API call. This severely limits your API capabilities, both internally for Salesforce Marketing Cloud (SFMC) and to any external resource. Is there any way via AMPScript or SSJS to utilize HTTP methods outside of GET […]