Shows information regarding recipients of all or specific messages sent from a collector.
Table Specific Information
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'
|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.|