-
Ever wanted to have your script ‘take a break’ for a minute before continuing? Check out this function for a quick solution.
-
Retrieving delimited values from String in SQL utilizing XML and the Value() function.
-
So many people have wanted to check the status or gather relevant Journey information from those they push in. This endpoint may not be the most efficient way, but currently it is one of the easiest ways to get the context and status of each subscriber entered into a Journey. An undocumented endpoint in the […]
-
So, in the past, the only way you could refresh a filtered Data Extension was utilizing the Filter Activity (in Automation Studio) or via the UI, performing a manual refresh. Now admittedly this is not too bad of a hurdle, but it does not help if you already built out the filter inside the UI […]
-
I have seen many people interested in keeping tabs on their Automations all in a single place. This usually involves at least the Automation Name and current status. There are also quite a few other items that can be grabbed as well inside the ‘Automation’ Object and pulled in to your Dashboard. First thing you […]
-
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, […]
-
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 […]
-
This is a bit of a niche use case, but honestly, those are usually the ones that are the most powerful to know. Keep in mind this is for use in SFMC SQL Query Activities and is not optimized for use outside of this platform. Ok. So you have a specific naming convention for your […]
-
**EDIT 10/04/2019** – Thank you to CAR from SFSE for pointing out my original code had a few weak points and needed to be updated. I have now updated my code to a much more elegant solution (and one that actually will work in all situations). I would ask that you go on and make […]
-
Ampscript is a server side scripting language used by Salesforce Marketing Cloud and can pick up where basic personalization strings leave off. For instance if your database contains first names that are empty or are only a first initial, it can make for awkward personalization. Dear J, is not going to win many people over… […]