Skip to content

Instantly share code, notes, and snippets.

View wvpv's full-sized avatar

Adam Spriggs wvpv

123 followers · 49 following
View GitHub Profile
@wvpv
wvpv / sfmc-ampscript-baby-shark-double-loop-string-parse.amp
Last active October 26, 2020 22:06
%%[
set @s = "Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end|"
for @v=1 to 9 do
set @f = substring(@s,1,add(indexOf(@s,"|"),-1))
set @s = replace(@s,concat(@f,"|"))
for @l=1 to 4 do
@wvpv
wvpv / sfmc-ampscript-baby-shark-single-loop-mod-math.amp
Created October 26, 2020 22:04
%%[
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 36 do
set @l=substring(add(divide(add(@v,-1),4),1),1,1)
set @r = row(@s,@l)
set @f = field(@r,1)
@wvpv
wvpv / sfmc-ampscript-baby-shark-single-loop-mod.amp.amp
Created October 26, 2020 22:03
%%[
set @l = 0
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 36 do
set @m=mod(@v,4)
set @l=add(@l,iif(@m==1,1,0))
@wvpv
wvpv / sfmc-ampscript-baby-shark-260-uncompressed.amp
Created October 26, 2020 22:01
%%[
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 9 do
for @l=1 to 4 do
set @r = row(@s,@v)
set @f = field(@r,1)
@wvpv
wvpv / sfmc-ampscript-baby-shark-260.amp
Created October 26, 2020 21:59
%%[for @v=1 to 9 do for @l=1 to 4 do outputline(field(row(buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|"),@v),1),iif(@l<4,", doo doo doo doo doo doo","!"))next next]%%
@wvpv
wvpv / sfmc-ssjs-triggeredSendSummary.js
Created October 19, 2020 18:38
TriggeredSendSummary to Data Extension Row
<script runat="server">
Platform.Load("core","1");
var debug = true;
try {
var prox = new Script.Util.WSProxy();
// https://salesforce.stackexchange.com/questions/178299/setup-an-email-notification-to-admin-when-triggered-sends-exceed-a-level-of-500/230406#230406
@wvpv
wvpv / sfmc-ssjs-retrieve-automation-with-wsproxy-results.json
Created September 4, 2020 15:48
SFMC SSJS Retrieve Automation with WSProxy - Results
{
"Status": "OK",
"RequestID": "40ff6f0d-5f64-4201-b441-671d70a49279",
"Results": [
{
"Schedule": null,
"AutomationTasks": [
null,
null,
null,
@wvpv
wvpv / sfmc-ssjs-retrieve-automation-with-wsproxy.js
Created September 4, 2020 15:35
SFMC SSJS Retrieve Automation with WSProxy
<script runat="server">
Platform.Load("Core","1");
var prox = new Script.Util.WSProxy();
try {
var cols = ['*'];
var filter = {
Property: "Name",
@wvpv
wvpv / sfmc-send-soap-object-de-schema.csv
Created June 27, 2020 13:06
SFMC Send SOAP Object Data Extension Schema
Name Data Type Length Precision Scale Primary Key Required Default Value
ID Number 1 1
SendDate Date 0 0
EmailName Text 100 0 0
Subject Text 200 0 0
Status Text 15 0 0
Additional Text 50 0 0
BCCEmail EmailAddress 0 0
Client_ID Number 0 0
Client_PartnerClientKey Text 64 0 0
@wvpv
wvpv / sfmc-send-soap-object-retrieve-to-de.js
Last active September 1, 2023 19:23
Retrieve Send SOAP Object data and write to a Data Extension
<script runat="server">
Platform.Load("core","1");
var debug = false;
// Mirrors Send SOAP Object data into a data extension
// - creates its own data extension
// - without any date filters includes all sends from account inception
try {