【第478回】 すべての購読者リストに保留ステータスの購読者を登録する方法

<script runat="server">
Platform.Load("core", "1");

var dataExtensionExternalKey = "CD3226AE-FA46-4278-AF4C-5B3B1D275803";   // DEの外部キー
var de = DataExtension.Init(dataExtensionExternalKey);
var rows = de.Rows.Retrieve();

var prox = new Script.Util.WSProxy();

for (var i = 0; i < rows.length; i++) {
    var subscriberKey = rows[i]["SubscriberKey"];   // DEの項目名
    var emailAddress  = rows[i]["EmailAddress"];    // DEの項目名

    if (!subscriberKey || !emailAddress) {
        continue;
    }

    var subscriberObj = {
        SubscriberKey: subscriberKey,
        EmailAddress: emailAddress,
        Status: "Held"
    };

    var options = {
        SaveOptions: [
            {
                PropertyName: "*",
                SaveAction: "UpdateAdd"
            }
        ]
    };

    try {
        var result = prox.updateItem("Subscriber", subscriberObj, options);
        Write("<br>OK: " + Stringify(result));
    } catch (e) {
        Write("<br>ERROR: " + Stringify(e));
    }
}
</script>