Skip to content

Instantly share code, notes, and snippets.

View naveenvm93's full-sized avatar

naveenvm93

8 followers · 0 following
View GitHub Profile
@naveenvm93
naveenvm93 / Convert-Data-Extension-Rows-To-Email-In-Tabular-Format.HTML
Last active September 8, 2019 09:57
Hi Admin,<br/>
<b> Below is the status of Automation:</b><br/>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left">
<table border="1px" cellpadding="0" cellspacing="0">
@naveenvm93
naveenvm93 / Triggered-Email-Via-Ampscript.HTML
Created September 15, 2019 07:26
%%[
if RequestParameter("submitted") == "submitted" then
Set @EmailAddr = RequestParameter("Email")
Set @FirstName = RequestParameter("FirstName")
Set @LastName = RequestParameter("LastName")
/* Trigger Send Object Creation */
SET @ts = CreateObject("TriggeredSend")
SET @tsDef = CreateObject("TriggeredSendDefinition")
SET @ts_subkey = @EmailAddr
@naveenvm93
naveenvm93 / SFMC-Journey-Email-Tracking
Created October 11, 2019 09:23
This is used to track Journey Emails from Google Sheets
<script runat="server">
Platform.Load("Core", "1.1.1");
try {
var paramtskey = Request.GetQueryStringParameter("tskey");
var parammetric = Request.GetQueryStringParameter("metric");
if (parammetric === "all") {
var tsd = TriggeredSend.Init(paramtskey);
var triggerSendTracking = tsd.Tracking.Retrieve();
var tsTracking = Stringify(triggerSendTracking);
@naveenvm93
naveenvm93 / Integrate-Wix-With-Salesforce-Marketing-Cloud.HTML
Created November 2, 2019 09:52
Integrate-Wix-With-Salesforce-Marketing-Cloud
%%[ var @contactform,@Email, @formEmpty
set @contactform = "false"
set @formEmpty = "false"
if RequestParameter("submitted") == "submitted"
then
set @contactform = "True"
Set @Email = RequestParameter("emailaddress")
IF NOT EMPTY(RequestParameter("emailaddress"))
THEN Set @UpsertData = UpsertDE('Contact_form','1','emailaddress',@Email,'submitteddate',NOW()) Else Set @formEmpty = "True" ENDIF
ENDIF]%%
@naveenvm93
naveenvm93 / LookUp-Data-Extension-For-Dynamic-Email
Created April 5, 2020 08:57
%%[
set @Country_ISO = AttributeValue("Country_ISO")
set @Subject = Lookup("Test Dynamic Email Translation","Subject","Country_ISO",@Country_ISO)
set @preheader = Lookup("Test Dynamic Email Translation","Preheader","Country_ISO",@Country_ISO)
set @Header_Image = Lookup("Test Dynamic Email Translation","Header Image","Country_ISO",@Country_ISO)
set @Header_Text = Lookup("Test Dynamic Email Translation","Header Text","Country_ISO",@Country_ISO)
set @CTA_Text = Lookup("Test Dynamic Email Translation","CTA Text","Country_ISO",@Country_ISO)
set @CTA_Link = Lookup("Test Dynamic Email Translation","CTA Link","Country_ISO",@Country_ISO)
]%%
@naveenvm93
naveenvm93 / Merge-Time-Zone-with-Local-Time
Last active April 7, 2020 05:59
Select T.[First Name], T.[Last Name], T.Email, dateadd(second,Tz.Time_Difference_in_Seconds_for_SFMC, DATEADD(YEAR,-(DATEDIFF(YEAR, getdate(), DateofBirth)), T.DateofBirth)) as [Local Time], T.DateofBirth, T.Country_code
from [Test Time Record] as T
JOIN [Time Zone] as Tz
on T.Country_code = Tz.Country_code
@naveenvm93
naveenvm93 / Email Validation using SFMC API.HTML
Created May 22, 2020 10:54
<!DOCTYPE html>
<html>
<body>
%%[
IF RequestParameter("submitted") == "submitted" Then
VAR @httppost,@apiid,@apistatusCode,@apiresponse,@apitoken
SET @apiid = '{"client_id": "client_id","client_secret": "client_secret", "grant_type": "client_credentials","account_id": "MID"}' /* Forming up the string for getting the access token */
SET @httppost = HTTPPost2("https://xyz.auth.marketingcloudapis.com/v2/token","application/json",@apiid,true,@apiresponse,@responseRows) /* Making a POST call to get access token */
IF(@httppost == "200") Then /* If status is Sucess */
set @rows = BuildRowsetFromString(@apiresponse,'"') /* Split the rows based on '"' string */
@naveenvm93
naveenvm93 / Authenticate-SFMC-With-Response
Created July 10, 2020 05:06
POST URL - https://xxxxxx.auth.marketingcloudapis.com/v2/token
Header :
Key - Content-Type
Value - application/json
Body:
{
"grant_type": "client_credentials",
"client_id": "Your Client Id",
@naveenvm93
naveenvm93 / Static-Gmail-Highlights-Car-Reservation.HTML
Created July 21, 2020 16:33
<div itemscope="" itemtype="http://schema.org/RentalCarReservation">
<meta itemprop="reservationNumber" content="53894589">
<link itemprop="reservationStatus" href="http://schema.org/Confirmed">
<div itemprop="underName" itemscope="" itemtype="http://schema.org/Person">
<meta itemprop="name" content="Naveen Vm">
</div>
<div itemprop="reservationFor" itemscope="" itemtype="http://schema.org/RentalCar">
<meta itemprop="name" content="CCAR">
<meta itemprop="model" content="Civic">
<div itemprop="brand" itemscope="" itemtype="http://schema.org/Brand">
@naveenvm93
naveenvm93 / Dynamic-Gmail-Highlights-Car-Reservation.HTML
Created July 22, 2020 06:26
%%[
SET @reservation_number = AttributeValue("reservation_number")
SET @handover_date = Format(AttributeValue("handover_date"),"yyyy-MM-ddTHH:mm:ss")
SET @return_date = Format(AttributeValue("return_date"),"yyyy-MM-ddTHH:mm:ss")
SET @vehicle_group = AttributeValue("vehicle_group")
SET @first_name = ProperCase(AttributeValue("first_name"))
SET @last_name = ProperCase(AttributeValue("last_name"))
Set @full_name = concat(@first_name,' ',@last_name)
Set @PickupAddressName = AttributeValue("PickupAddressName")
Set @PickupAddressName2 = AttributeValue("PickupAddressName2")