-
Many people do not realize that the SQL used in SFMC Query Activities follows Three-Valued Logic, which essentially means there are three possible outcomes for any Boolean value: True False Unknown(NULL) A value that is NULL therefore cannot be true or false. How is this relevant? Well, this causes issues with conditional statements in SQL […]
-
API / Data Extensions / SFMC / SSJS / WSProxy December 6, 2019
I have created a more modernized version of this in a different article. I left this article here as a reference should anyone want to take other aspects of it that may not be in the new version. I would highly recommend using the new version I created instead of this one though. A common […]
-
Have you ever had a script activity that just kept running over 30 minutes, but it wouldn’t break into individual pieces well? Its a struggle to find a solution because it’s not like you can easily break out of your loops after a set amount of time, right? Wrong. There are a couple different tricks […]
-
As many of you may know, I am a big fan of the undocumented REST API endpoints. I do have my first dive into them in my previous post Access Script Activities via API. For this post, I want to highlight the Undocumented API endpoints for Query Activities. I do want to point out that […]
-
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 […]
-
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, […]