-
API / SFMC / SSJS / WSProxy March 15, 2020
READ MOREMost of the time, the best method is to just export the data extension and then import it again into All Subscribers. For one time bulk imports, this is by far the most efficient method. Alas, as with any solution in Salesforce Marketing Cloud, it comes with a ton of ‘but’ statements. For instance, what […]
-
READ MORE
Now, you may be confused by what the fudge I mean by ‘Dynamically Creating Variables’ as in its essence, a variable is itself, dynamic. Basically what I mean is I am going to show you some AMPscript that will loop through and create multiple variables without needing to write out each one. Pretty neat, right? […]
-
READ MORE
Although the alerts provided by SFMC on Triggered Send issues and errors is very helpful, it can take many hours before they show up, which can sometimes lead to significant backups in your processes. To get around this delay, I have come up with a monitoring automation that will give almost ‘real time’ alerts on […]
-
READ MORE
I will give a quick overview on setting up an API integration package and then utilizing it in POSTman.
-
READ MORE
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
READ MOREI 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 […]
-
READ MORE
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 […]
-
READ MORE
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 […]
-
READ MORE
Ever wanted to have your script ‘take a break’ for a minute before continuing? Check out this function for a quick solution.
-
READ MORE
Retrieving delimited values from String in SQL utilizing XML and the Value() function.