MuleSoft Connector for SendGrid

Build 20.0.7654

SendMail

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:

Insert into Personalizations#TEMP(ToEmail#3,FromEmail,FromName,Subject,ToEmail#1,ToName#1,ToEmail#2,ToName#2 ) values('b2z@cdata.com','a2y@cdata.com','hello@cdata.com','Test Subject2','a@cdata.com','b@cdata.com','sachi@cdata.com','hello@cdata.com');

Insert into Personalizations#TEMP(FromEmail,ToBCCEmailName,SendAt,FromName,Subject,Content,ToEmail#1,ToName#1)values('hello@cdata.com','demo@cdata.com','2017-10-30T10:57:00+01:00','hi','Test Subject2','hello','sac@cdata.com','shubham@cdata.com');

Exec SendMail Personalizations = 'Personalizations#TEMP', FromEmail='shubham@cdata.com', Subject='hello', Content#1='Test content with multiple from ids',IsHTML#1='true',attachmentpath#1='D:\Conversations.json',attachmentpath#2='D:\ConversationMessages.json';

Input

Name Type Required Description
Subject String True The subject of the mail to be sent.
Content# String True The content of the mail to be sent.
IsHTML# String False Boolean indicating if the content type is HTML or plain text.
SendAt String False The date and time when you want your email to be delivered. Scheduling more than 72 hours in advance is forbidden.
FromEmail String True The email address of the sender.
FromName String False The name of the sender.
ToEmail String False Email address to send the mail to. Send to multiple using ToEmail#1, ToEmail#2, ...
ToName String False Email's respective names to send the mail to.
ToCCEmail String False Email address to send a copy of the mail to.
ToCCName String False Email's respective names to send a copy of the mail to.
ToBCCEmail String False Email address to send the mail to as a blind carbon copy.
ToBCCName String False Email's respective names to send the mail to as a blind carbon copy.
ReplyToEmail String False The email address of the person to whom you are replying to.
ReplyToName String False The name of the person to whom you are replying to.
AttachmentPath# String False Path of the file to attach to the mail to be sent
TemplateId String False The Id of the template that you may want to send
DynamicTemplateData String False The data of the dynamic template.
Personalizations String True An array of messages and their metadata. Each object within personalizations can be thought of as an envelope - it defines who should receive an individual message and how that message should be handled.

Result Set Columns

Name Type Description
Success String Whether or not the mail was sent successfully.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654