CollectorRecipients
Shows information regarding recipients of all or specific messages sent from a collector.
Table Specific Information
Select
You must specify the collector Id to query from this view. The driver will execute other filters client-side in memory. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following queries are processed server side:
SELECT * FROM CollectorRecipients WHERE CollectorId = '175305200' SELECT * FROM CollectorRecipients WHERE CollectorId = '175305200' AND MessageId = '57071816' SELECT * FROM CollectorRecipients WHERE CollectorId = '175305200' AND Id = '4496877899'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the recipient. |
| CollectorId | String | The Id of the collector this recipient belongs to. |
| MessageId | String | The Id of the message this recipient belongs to. Null if it doesn't belong to a specific message. |
| String | Email of recipient added to collector. | |
| SurveyResponseStatus | String | If the recipient has completed the survey: 'not_responded', 'partially_responded', 'completely_responded'. |
| MailStatus | String | If an invite message to the recipient has been: 'sent', 'not_sent', or is 'processing'. |
| SurveyLink | String | Link to the survey in the invite. |
| RemoveLink | String | Unsubscribe link. |