SSIS Components for SendGrid

Build 20.0.7587

NMCLists

Create, update, delete, and query the available New Marketing Campaign Lists in SendGrid.

Table-Specific Information

NMC prefix stands for New Marketing Campaign.

Select

The NMCLists table can only filtered by its Id.

SELECT * FROM NMCLists WHERE Id = '123'

Insert

Only the Name for the NMCLists is required to insert into this table.

INSERT INTO NMCLists(Name) VALUES ('TestList')

Update

You can only update from NMCLists by specifying an Id.

UPDATE NMCLists Set Name = 'New Name' WHERE Id = '123'

Delete

You can only delete from NMCLists by specifying an Id.

DELETE FROM NMCLists WHERE Id = '123'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the list.

Name String False

The name of the list.

ContactCount Integer True

The recipient count of the list.

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