JDBC Driver for SendGrid

Build 22.0.8462

NMCCustomFields

Create, delete, and query New Marketing Campaign Custom Fields in SendGrid.

Table Specific Information

New Marketing Campaign Custom fields are filters for a Contact that are defined by the user. NMC prefix stands for New Marketing Campaign.

Select

You can retrieve all the NMCCustomFields or filter them by Id:

SELECT * FROM NMCCustomFields
SELECT * FROM NMCCustomFields WHERE Id = '1'

Use quotations to filter on NMC Custom Fields regardless of type.

Insert

To insert on NMCCustomFields specify the Name of the field and its Type. The Type can be text, date, or number.

INSERT INTO NMCCustomFields(name, type) VALUES ('age', 'number') 

Update


UPDATE NMCCustomFields SET name = 'updated name' WHERE Id = '123' 

Delete

You can only delete from NMCCustomFields by specifying an Id:

DELETE FROM NMCCustomFields WHERE Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the custom field.

Name String False

The name of the custom field.

Type String False

The type of the custom field. Allowed values are number, text, or date.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462