katydorjee

%%[
VAR @ProductName
SET @ProductName = "Mobile phone"
]%%

<script runat=server>
    Platform.Load("Core","1");
	
	  //Get the Variable from AMPscript

katydorjee

%%[
SET @status = DeleteData("DataExtension Name", "SubscriberKey","XXXXXXXXXX") 
]%%

Status: %%=v(@status)=%%

katydorjee

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

<script runat=server>
    try{
</script>

%%[
SET @SKey = RequestParameter("skey")

katydorjee

SELECT * FROM [Payment]
WHERE DueDate BETWEEN DATEADD(DAY, -30, DATEADD(HOUR,5, GETDATE())) AND DATEADD(HOUR,5, GETDATE())

katydorjee

<script runat="server">
    Platform.Load("core", "1");
        var url = 'https://auth.exacttargetapis.com/v1/requestToken';
        var contentType = 'application/json';
        var payload = Stringify({
		"clientId": "XXXXXXXXXXXXXXXXXXXXXXXXXX",
		"clientSecret": "XXXXXXXXXXXXXXXXXXXXXXXXXX"
        });
        var headerNames = ["Encoding"];
        var headerValues = ["utf-8"];

katydorjee

   SET @email = "[email protected]"
   SET @SKey = "123456"
   SET @First_Name = "Katy"
   SET @Last_Name = "Dorjee"
   SET @Phone = "987654321"
   
   SET @ts = CreateObject("TriggeredSend")
   SET @tsDef = CreateObject("TriggeredSendDefinition")
   SetObjectProperty(@tsDef, "CustomerKey", "XXXX")
   SetObjectProperty(@ts, "TriggeredSendDefinition", @tsDef)

katydorjee

%%[
	VAR @SubscriberKey, @firstName, @lastName, @returnValue
	SET @SubscriberKey = "123"
	SET @firstName = "Karma"
	SET @lastName = "Dorjee"
	SET @returnValue = UpsertData("My_Test_DataExtension",1,"SubscriberKey",@SubscriberKey,"FirstName",@firstName,"LastName",@lastName)
]%%

No of affected rows : %%=v(@returnValue)=%%

katydorjee

%%[

var @debug
var @jid
var @listid
var @batchid
var @email
var @skey
var @reason
var @unsubscribeAll

katydorjee

select
x.emailaddress
, x.subscriberkey
from (
  select
  w.emailaddress
  , w.subscriberkey
  , w.insertDate
  , row_number() over (partition by w.subscriberkey order by w.insertDate asc) ranking
  from Welcome_Trigger w

katydorjee

<script  runat="server">
    Platform.Load("core","1.1.1");
     
    var prox = new Script.Util.WSProxy();

/*
 //Child BU's MID
    var MID = 10000000000;
    
    //Switch context to different BU. Change the MID to suit.