-
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
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
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 […]