Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    Couchbase
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/messaging




Messaging (SMS/SMTP)


This adapter allows you to send SMS and SMTP messages using an existing mail server.

For more robust SMS messaging capabilities consider using the Twilio adapter.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String MailServerType
String FromName
String FromEmail
String Host
Int32 Port
String UserId
String Password
Boolean EnableSsl

Handlers



listTextCarriers Return a list of supported phone carriers for text messaging. details 

Arguments


SQL Call

exec Messaging.listTextCarriers


Http Call

/bsc/messaging/listtextcarriers

Output Columns

String codeCarrier code
String nameName of telephone carrier
sendSmtp Send SMTP email. details 

Arguments

Name Description Default
fromName Name of sender
fromEmail R Email address of sender
recipients R One or more email addresses separated by commas to send message
subject R subject
message R Message to send. If message text begins with '' (case-insensitive), the message is sent as HTML
ccs Optional one or more email addresses separated by commas to carbon copy
bccs Optional one or more email addresses separated by commas to blind carbon copy
attachment1 File to attach 1. If initiating via REST, do not add argument as a header, but instead attach as a file to the POST request specifying an HTTP Content-Type of 'multipart/form-data'.
attachment2 File to attach 2.
attachment3 File to attach 3.
attachment4 File to attach 4.
attachment5 File to attach 5.
attachment6 File to attach 6.
attachment7 File to attach 7.
attachment8 File to attach 8.
attachment9 File to attach 9.
attachment10 File to attach 10.

SQL Call

exec Messaging.sendSmtp 'John Doe', 'jdoe@mail.com', 'recipient@email.com', 'Test', 'Hello, world'
exec messaging.sendSmtp 'John Doe', 'recipient@email.com', 'Test', 'Hello, world. "world" should be bolder and slightly larger than "Hello".', 1
exec messaging.sendSmtp 'John Doe', 'recipient@email.com', 'Test', 'Please find an XML attachment.', null, null, 'Hello, world', 'x', 'cc_somebody@email.com'


Http Call

/bsc/messaging/sendsmtp

Output Columns

Boolean Result0/1 result if message sent successfully
sendText Send text message. details 

Arguments

Name Description Default
carrier R Carrier code. Use 'exec messaging.listTextCarriers' to view a list of supported telephone carriers.
phones R One or more telephone numbers separated by commas to send message
message R Message to send
subject Optional subject
server Server configuration settings to use defined in config default

SQL Call

exec Messaging.sendText 'verizon', '123-456-7890', 'Hello, world'


Http Call

/bsc/messaging/sendtext

Output Columns

Boolean Result0/1 result if message sent successfully