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.
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.
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 NMCCustomFields SET name = 'updated name' WHERE Id = '123'
You can only delete from NMCCustomFields by specifying an Id:
DELETE FROM NMCCustomFields WHERE Id = '1'
The Id of the custom field.
The name of the custom field.
The type of the custom field. Allowed values are number, text, or date.