net3000.mailingList 1.0.0

mailingListCore

Overview

The mailingListCore library provides comprehensive mailing list management for the Net3000 platform. It handles subscriber management, campaign creation and delivery, multi-platform email marketing integrations (SendGrid, MailChimp, Constant Contact), delivery tracking, and unsubscribe management. Campaigns can be sent immediately or queued for background processing.

Features

• Subscriber Management: Subscribe, unsubscribe, search, and import subscribers with custom metadata fields
• Campaign Delivery: Create, schedule, and send email campaigns with immediate or background execution
• Multi-Platform Integration: SendGrid, MailChimp, Constant Contact, and Amadeus platform support with list/contact synchronization
• Delivery Tracking: Email open tracking via pixels, click tracking, bounce detection, and per-subscriber status logging
• Unsubscribe Management: Token-based unsubscribe links with cross-platform unsubscribe handling
• SendGrid Webhooks: Process delivery events (bounces, opens, clicks, unsubscribes) from SendGrid webhook callbacks
• Dynamic Message Groups: Query-based recipient lists from external data sources

Database Tables

ml_maillists

Mailing lists with account scoping:

• title, listCode, uuid (GUID), account
• responseTitle, responseMessage (subscription confirmation)
• notifyemail, details

ml_subscribers

Subscriber records:

• email, firstName, lastName, account
• metaData (JSON custom fields), bounced, exclude

ml_listsubscribers

Subscription relationships linking subscribers to lists:

• listID, subscriberID, unsubscribed, Token (GUID for unsubscribe links)

ml_messages

Email message templates:

• messageCode, title, subject, message (HTML body)
• fromName, fromMail, replyEmail, useTemplate

ml_dlog

Campaign delivery logs:

• messageID, listID, account, statusID, Token (GUID)
• Delivery stats: sentNumber, delivered_count, bounces, opens, clicks, unsubscribes

ml_subscriberlog

Individual subscriber delivery tracking:

• logID, subscriberID, opened, unsubscribed, token

ml_listConnections

External platform connections per list:

• listID, apiPlatformID, metaData (JSON)

ml_subscriberConnections

External platform subscriber links:

• subscriberId, platformId, externalId

ml_netareaLog

Campaign logs with filter criteria for targeted sends:

• messageID, sentTo, clientStatus, accountStatus, appCodes

Public API

<details> <summary>net3000.mailingList.lib - Subscription Management</summary>

</details>

<details> <summary>net3000.mailingList.lib - Campaign Sending</summary>

</details>

<details> <summary>net3000.mailingList.lib - Tracking & Unsubscribe</summary>

</details>

<details> <summary>net3000.mailingList.lib - Platform Sync</summary>

</details>

<details> <summary>net3000.mailingList.lib - Utility</summary>

</details>

<details> <summary>Constants & Enums</summary>

</details>

Usage

using net3000.mailingList;

// Initialize
var ml = new lib();
ml.mailingListDb = mailingListDbContext;
ml.account = currentAccountId;

// Subscribe a user
var subscriber = new subscriber
{
    email = "user@example.com",
    name = "Jane Doe",
    account = currentAccountId,
    listCode = "newsletter"
};
ml.subscribe(subscriber);

// Send a campaign
var result = await ml.SendCampaignAsync(campaignId, runInBackground: true, serviceProvider);

// Track unsubscribe
var info = await ml.GetUnsubscribeByTokenInfoAsync(campaignToken, subscriberToken);

Connection String

The library expects a connection string named "mailinglist":

{
  "ConnectionStrings": {
    "mailinglist": "Server=your-server;Database=mailinglist;..."
  }
}

Dependencies

• SendGrid 9.29.3 - Email delivery
• Microsoft.EntityFrameworkCore.SqlServer 10.0.1 - Data access
• Newtonsoft.Json 13.0.4 - JSON serialization
• Serilog 4.3.0 - Structured logging
• net3000.common 10.0.7 - Common utilities
• apiConnectorCore - API connection management
• ConstantContact.Services / mailChimp.Services / SendGrid.Services - Platform integrations

License

This library is proprietary to Net3000. Redistribution or use outside Net3000.ca solutions is not permitted.