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 本製品 will execute other filters client-side in memory.
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. |