-
READ MORE
BuildRowsetFromJSON() is a new function that was added to AMPscript in the Summer 2023 release for Salesforce Marketing Cloud. It provides the ability for AMPscript to interact and iterate through a JSON Object or Array in a more native fashion. This is compared to previously when you would have to utilize a different platform language or utilize regex and substring, etc. (which was far from accurate, elegant or efficient).
-
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 […]