SFMC File Transfer Activity Encryption Keys
SF Documentation: https://help.salesforce.com/articleView?id=sf.mc_overview_use_a_created_key_with_file_transfer_activities.htm&type=5
<script runat="server" language="JavaScript"> | |
Platform.Load("Core","1"); | |
/* adapted from https://sfmarketing.cloud/2020/02/29/create-a-cloudpages-form-with-an-image-file-upload-option/ */ | |
var results = {}; | |
results.result = {}; | |
results.debug = {}; | |
results.error = {}; |
<script runat="server" language="ampscript"> | |
set @processingPageURL = "https://YOURTENANTHERE.pub.sfmc-content.com/YOURPATHHERE" | |
</script><!DOCTYPE html> | |
<html> | |
<head> | |
<meta charset="UTF-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> | |
<meta name="viewport" content="width=device-width,initial-scale=1"> |
%%[ | |
set @dateToCheck = "2023-10-25" | |
set @month = datepart(@dateToCheck, "M") | |
set @day = datepart(@dateToCheck, "D") | |
set @daysOfWeek = "SunMonTueWedThuFriSat" | |
set @dayOfWeekToFind = format(@dateToCheck,"ddd") | |
set @dayOfWeekNum = divide(add(indexof(@daysOfWeek,@dayOfWeekToFind),2),3) |
select | |
s.id JobID | |
, s.SentDate AT TIME ZONE 'Pacific Standard Time' as SentDate | |
, s.status JobStatus | |
, s.EmailName | |
, s.NumberTargeted Targeted | |
, s.NumberDelivered Delivered | |
, case | |
when isnull(s.NumberTargeted,0) = 0 then 0 | |
else cast((s.NumberDelivered) as decimal(18,4)) / cast(s.NumberTargeted as decimal(18,4)) |
select | |
j.jobid | |
, j.emailName | |
, jn.journeyName | |
, max(jn.versionNumber) versionNumber | |
from _Job j | |
inner join ( | |
select | |
convert(varchar(36), ja0.VersionID) VersionID /* UniqueIdentifier datatype doesnt play nicely with JO-INs */ |
select | |
left(convert(varchar(36), jn.VersionID),36) VersionID | |
, left(jn.JourneyName,100) JourneyName | |
, left(ja.ActivityName,100) ActivityName | |
, left(ja.JourneyActivityObjectID,36) JourneyActivityObjectID | |
from _Journey jn | |
inner join ( | |
select | |
convert(varchar(36), ja0.VersionID) VersionID /* UniqueIdentifier datatype doesnt play nicely with JO-INs */ |
SF Documentation: https://help.salesforce.com/articleView?id=sf.mc_overview_use_a_created_key_with_file_transfer_activities.htm&type=5
<script runat="server" language="JavaScript"> | |
Platform.Load("core","1"); | |
var debug = false; | |
try { | |
var prox = new Script.Util.WSProxy(); | |
var startTime = Now(); | |
var timeoutMilliseconds = 1500000; // 25 minutes |
FieldName | DataType | Length | Precision | Scale | PrimaryKey | Required | DefaultValue | |
---|---|---|---|---|---|---|---|---|
ClientID | Number | TRUE | TRUE | |||||
SendID | Number | TRUE | TRUE | |||||
SubscriberKey | Text | 254 | TRUE | TRUE | ||||
EmailAddress | EmailAddress | FALSE | FALSE | |||||
SubscriberID | Number | TRUE | TRUE | |||||
ListID | Number | TRUE | TRUE | |||||
EventDate | Date | TRUE | TRUE | |||||
EventType | Text | 10 | FALSE | FALSE | ||||
BatchID | Number | TRUE | TRUE |
{ | |
"info": { | |
"_postman_id": "7526dd49-78b6-4589-a640-fe7b879ef751", | |
"name": "Short.io", | |
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json", | |
"_exporter_id": "407776" | |
}, | |
"item": [ | |
{ | |
"name": "Shorten URL", |