<%
var mode = Request.GetQueryStringParameter("mode");
if (mode == "admin") {
var masterDE = DataExtension.Init(WA_MASTER_DE);
var suppressionDE = DataExtension.Init(WA_SUPPRESSION_DE);
var totalRows = masterDE.Rows.Retrieve().length;
var suppressedRows = suppressionDE.Rows.Retrieve().length;
%>
WhatsApp Webhook Dashboard
📊 Database Overview
Total Records: <%= totalRows %>
Suppressed Numbers: <%= suppressedRows %>
🔍 Lookup Number
<%
var phone = Request.GetQueryStringParameter("phone");
if (phone) {
var result = masterDE.Rows.Lookup(["Phone_E164"], [phone]);
if (result.length > 0) {
%>
Status: <%= result[0].WA_Status %>
Suppressed: <%= result[0].Suppressed %>
Last Confirmed: <%= result[0].Last_Confirmed %>
<%
} else {
%>
No record found.
<%
}
}
%>
🛠 Manual Suppression
<%
if (Request.GetFormField("action") == "suppress") {
var manualPhone = Request.GetFormField("manual_phone");
masterDE.Rows.Update(
{ WA_Status: "INVALID", Suppressed: "True", Last_Checked: Now() },
["Phone_E164"],
[manualPhone]
);
%>
Number suppressed successfully.
<%
}
%>
<%
}
%>