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.
The collector ID, message ID, and ID can be processed server side. At most, only two of these filters may be used simultaneously.
Specifying all three filters in the same query may result in an incorrect result set.
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. |