MuleSoft Connector for SendGrid

Build 20.0.7654


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

Table-Specific Information

NMC prefix stands for New Marketing Campaign.


You can retrieve all the segments or filter them by Id.

SELECT * FROM NMCSegments WHERE Id = '1'


A Segment divides NMCContacts by certain criteria. To specify these criteria use the QueryDSL filter.

INSERT INTO NMCSegments(Name, QueryDSL) VALUES ("New Segment", "Segment Cdata", "first_name LIKE '%test%'"))

The statement above creates NMCSegments containing NMCContacts with FirstName containing the value "test".


You can update the name or the conditions. Since the whole set will be overwritten, specify a full set.

UPDATE NMCSegments Set Name="Name Updated", QueryDSL = "first_name LIKE '%test update%'" WHERE Id = '123'


You can only delete NMCSegments by Id:

DELETE FROM NMCSegments WHERE Id = '123'


Name Type ReadOnly Description
Id [KEY] String True

The Id of the segment.

Name String False

The name of the segment.

ParentListId String False

The Id of the list associated with the segment.

ContactsCount Integer True

The recipient count of the segment.

CreatedAt Datetime True

Field name for the first condition.

SampleUpdatedAt Datetime False

Field name for the first condition.

UpdatedAt Datetime True

Field name for the first condition.

QueryDSL String False

Field name for the first condition.

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