CustomFields
Create, delete, and query Custom Fields in SendGrid.
Table Specific Information
Custom fields are filters for a Recipient that are defined by the user.
Select
You can retrieve all the CustomFields or filter them by Id:
SELECT * FROM CustomFields WHERE Id = '1'
Use quotations to filter on Custom Fields regardless of type.
Insert
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')
Update
This table does not support updating.
Delete
You can only delete from CustomFields by specifying an Id:
DELETE FROM CustomFields WHERE Id = '1'
Columns
Name | Type | ReadOnly | References | 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. |