Recipients
Record for a recipient for some communication, such as email.
Select
The connector will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports the '=,IN,>=,<=,>,<' operators.
SELECT * FROM Recipients WHERE Id = 1 SELECT * FROM Recipients WHERE Id IN (1, 2) SELECT * FROM Recipients WHERE Id >= 1 SELECT * FROM Recipients WHERE Id <= 1 SELECT * FROM Recipients WHERE Id > 1 SELECT * FROM Recipients WHERE Id < 2
Columns
Name | Type | Description |
Id [KEY] | Integer | Id of Recipient. |
CreatedAt | Datetime | The date and time the team was created. |
EmailHash | String | Hash of email for recipient. |
RecipientType | String | The type of action for the communcation to the recipient. |
UpdatedAt | Datetime | The date and time the team was last updated. |
Value | String | The recipient contact information. |
LinksSelf | String | Link self. |
Type | String | Type. |