BizTalk Adapter for SendGrid

Build 20.0.7587

NMCSenders

Create, update, delete, and query New Marketing Campaign Senders in SendGrid.

Table-Specific Information

NMC stands for New Marketing Campaign.

Select

This table only supports filtering by Id. The following are the only possible SELECT queries:

SELECT * FROM NMCSenders
SELECT * FROM NMCSenders WHERE Id = '148825'

Insert

The following columns are required in an insert: Nickname, FromEmail, FromName,ReplytoEmail, Address, City, Country.

INSERT INTO NMCSenders (Nickname, FromEmail, FromName,ReplytoEmail, Address, City, Country) VALUES ('Nickname','FromEmail','FromName','ReplytoEmail','Address','City','Country')

Update

You can update NMCSenders by specifying an Id.

Update NMCSenders SET Nickname='Nickname', FromEmail='FromEmail', FromName='FromName', ReplytoEmail='ReplytoEmail', Address='Address', City='City', Country='Country'  WHERE Id=1310789

Delete

You can only delete from Alerts by specifying an Id.

Delete FROM NMCSenders WHERE Id=1310789

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

The unique identifier of the sender identity.

Nickname String False

A nickname for the sender identity. Not used for sending..

FromEmail String False

This is where the email will appear to originate from for your recipient.

FromName String False

This is the name appended to the from email field. IE - Your name or company name.

ReplytoEmail String False

This is the email that your recipient will reply to.

ReplytoName String False

This is the name appended to the reply to email field. IE - Your name or company name.

Address String False

The physical address of the sender identity.

Address2 String False

Additional sender identity address information.

City String False

The city of the sender identity.

State String False

The state of the sender identity.

Zip String False

The zipcode of the sender identity.

Locked String False

Indicator if the sender is locked.

VerifiedStatus String False

Verified status of the sender.

VerifiedReason String False

Verified reason of the sender.

Country String False

The country of the sender identity.

CreatedAt Datetime True

The end of the time range when the bounce was created.

UpdatedAt Datetime True

The end of the time range when the bounce was created.

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