SSIS Components for SendGrid

Build 20.0.7656


Create, delete, and query Custom Fields in SendGrid.

Table Specific Information

Custom fields are filters for a Recipient that are defined by the user.


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

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

Use quotations to filter on Custom Fields regardless of type.


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

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


This table does not support updating.


You can only delete from CustomFields by specifying an Id:

DELETE FROM CustomFields WHERE Id = '1'


Name Type ReadOnly Description
Id [KEY] String False

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656