JDBC Driver for SurveyMonkey

Build 22.0.8462

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.
Email 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462