Skip to content

Instantly share code, notes, and snippets.

@vishneuski
vishneuski / sendEmail.js
Created February 28, 2024 09:20 — forked from eliotharper/sendEmail.js
WSProxy example for SSJS and SFMC to send triggered send email
<script runat=server>
var city = Platform.Request.GetFormField('city');
var email = Platform.Request.GetFormField('email');
// Detect form submission
if ( (city) && (email) ) {
var weather = getWeather(city);
@vishneuski
vishneuski / DE Field Search
Created February 21, 2024 12:41 — forked from camrobert/DE Field Search
SSJS script to locate every Field in every Data Extension with a given name
@vishneuski
vishneuski / SSJS: Baseplate
Created February 21, 2024 12:36 — forked from camrobert/SSJS: Baseplate
Code Snippet
<script runat="server">
Platform.Load("Core","1");
try {
//Do Functions Here
}
catch(error) {
Write('Message: '+ Stringify(error));
}
SELECT DISTINCT
a.SubscriberKey
, a.EmailAddress
, j.JobID
, j.EmailName
, s.EventDate
, j.SendClassificationType
, j.SendType
, a.DateUnsubscribed
FROM _Subscribers a
%%[
SET @fname = RequestParameter('fname')
SET @lname = RequestParameter('lname')
SET @email = RequestParameter('email')
IF NOT EMPTY(RequestParameter('pref1')) THEN
SET @Cats = "true"
ELSE
SET @Cats = "false"
ENDIF
%%[
SET @json = '{"menu": {
"id": "file",
"value": "File",
"popup": {
"menuitem": [
{"value": "New", "onclick": "CreateDoc(a)"},
{"value": "Open", "onclick": "OpenDoc(b)"},
{"value": "Save", "onclick": "SaveDoc(c)"}
]
@camrobert
camrobert / BuildRowsetFromJson Documentation Sample
Created June 14, 2023 13:43
Recreate the BuildRowsetFromJson Documentation Usage Example
%%[
SET @json = '{"Flights": [{"Origin": "IND","Dest": "NYC","Price": 100.0},{"Origin": "IND","Dest": "LAX","Price": 200.0},{"Origin": "IND","Dest": "SEA","Price": 500.0,"PerBagSurcharge": 25}]}'
SET @rows = BuildRowsetFromJson(@json, '$.Flights[*]', 1)
]%%
<table border=1>
<tr><th>Origin</th><th>Dest</th><th>Price</th><th>PerBag Surcharge</th></tr>
%%[FOR @i = 1 TO Rowcount(@rows) DO]%%
<tr>
%%[FOR @c = 1 TO 4 DO]%%
<td>%%=Field(Row(@rows,@i),@c)=%%</td>
%%[
/*
Ref: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/httppost2.html
Ref: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/access-token-s2s.html
Ref: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/validateEmail.html
*/
/*=== (Unsafe) Plain Text API Credentials ===*/
SET @client_id = "xxxxxxxxxxxxxxxxxx"
SET @client_secret = "xxxxxxxxxxxxxxxxxx"
%%[
SET @rows = LookupRows("DENAME", "Key", "Value")
FOR @i = 1 to RowCount(@rows) DO
]%%
EmailAddress: %%=Field(Row(@rows,i), 'EmailAddress')=%%<br>
%%[
NEXT @i
]%%
@camrobert
camrobert / SSJS: Baseplate
Created January 6, 2023 09:12
Code Snippet
<script runat="server">
Platform.Load("Core","1");
try {
//Do Functions Here
}
catch(error) {
Write('Message: '+ Stringify(error));
}