Sends a mail.

Procedure-Specific Information

The DynamicTemplateData input requires information about dynamic data of the template. Value for the different variables put into templates.

Example: {"fullname":"Test","paymenttotal":"Test","description":"Test"}

NOTE: The TemplateId column is required when using Dynamic Templates.

Process of adding Persanalizations object to SendMail Stored Procedure

SendMail Requires atleast one personalizations object in the request body and it can be added using the aggregate function.

For Example:

Using TEMP Tables.

Insert into To#TEMP(ToEmail,ToName) Values ('a@cdata.com','abc')

Insert into To#TEMP(ToEmail,ToName) Values ('ab@cdata.com','xyz')

Insert into To#TEMP(ToEmail) Values ('abo@cdata.com')

Insert into ToCC#TEMP(ToCCName,ToCCEmail) Values ('xyz@cdata.com','xyz')

Insert into ToBCC#TEMP(ToBCCEmail,ToBCCName) Values ('ab@cdata.com','abc')

Insert into Content#TEMP(ContentValue,ContentType) Values ('abc@cdata.com','text/plain')

Insert into Personalizations#TEMP(FromEmail,SendAt,FromName,Subject,To,ToCC,ToBCC)values('abcd@cdata.com','2017-10-30T10:57:00+01:00','hi','Test Subject2','To#TEMP','ToCC#TEMP','ToBCC#TEMP')

Exec SendMail Personalizations = 'Personalizations#TEMP', FromEmail='pqr@cdata.com', Subject='hello', Content='Content#TEMP' 

Using Aggregate values.

Send Mail to single Mail Address.

Insert into Personalizations#TEMP(FromEmail,SendAt,FromName,Subject,To,ToCC,ToBCC)values('abcd@cdata.com','2017-10-30T10:57:00+01:00','hi','Test Subject2',
         '[
		   {
              "ToEmail": "a@cdata.com",
              "ToName": "abc"
           }
		  ]',
		  '[
            {
              "ToCCName": "xyz",
              "ToCCEmail": "an@cdata.com"
            }
          ]',
		  '[
            {
              "ToBCCEmail": "ab@cdata.com",
              "ToBCCName": "abcd"
            }
          ]')

Exec SendMail Personalizations = 'Personalizations#TEMP', FromEmail='pqr@cdata.com', Subject='hello', Content=
'{
  "ContentValue":"content",
  "ContentType":"text/plain"
}'

Send Mail to Multiple Mail Addresses.

Insert into Personalizations#TEMP(FromEmail,SendAt,FromName,Subject,To,ToCC,ToBCC)values('abcd@cdata.com','2017-10-30T10:57:00+01:00','hi','Test Subject2',
          '[
		    {
              "ToEmail": "a@cdata.com",
              "ToName": "abc"
            },
            {
              "ToEmail": "pqr@cdata.com",
              "ToName": "xyz"
            },
            {
              "ToEmail": "b2z@cdata.com"
            }
          ]',
		  '[
            {
              "ToCCName": "sac",
              "ToCCEmail": "abcd@cdata.com"
            }
          ]',
		  '[
            {
              "ToBCCEmail": "xyz",
              "ToBCCName": "qq@cdata.com"
            }
          ]')
		  
Exec SendMail Personalizations = 'Personalizations#TEMP', FromEmail='hello@cdata.com', Subject='hello', Content=
'{
  "ContentValue":"content",
  "ContentType":"text/html"
}'

Input

Result Set Columns