CollectorRecipientDetails

Displays detailed information regarding recipients of all or specific messages sent from a collector.

Table Specific Information

Select

You must specify SurveyId and CollectorId to query from this view. The 本製品 will execute other filters client-side in memory.

Survey ID, collector ID, message ID, and ID can be processed server side. The valid combinations are:

SurveyId and CollectorId
SurveyId, CollectorId, and Id
CollectorId and MessageId

Other combinations may produce incorrect results. For example, the following queries are processed server side:

SELECT * FROM CollectorRecipientDetails WHERE SurveyId = '159264810' AND CollectorId = '218025675'

SELECT * FROM CollectorRecipientDetails WHERE SurveyId = '159264810' AND CollectorId = '218025675' AND Id = '4178228027'

SELECT * FROM CollectorRecipientDetails WHERE CollectorId = '218025675' AND MessageId = '3456'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id of the recipient.
SurveyId [KEY]	String	False	The Id of the survey.
CollectorId [KEY]	String	False	The Id of the collector this recipient belongs to.
MessageId	String	False	The Id of the message this recipient belongs to.
FirstName	String	False	The first name of the recipient.
LastName	String	False	The last name of the recipient.
Email	String	False	The email of the recipient.
SurveyResponseStatus	String	False	Indicates whether the recipient has completed the survey. Possible values are 'not_responded', 'partially_responded', or 'completely_responded'.
MailStatus	String	False	If an invite message to the recipient has been: 'sent', 'not_sent', or is 'processing'.
SurveyLink	String	False	The link to the survey in the invite.
RemoveLink	String	False	The unsubscribe link.
ExtraFields	String	False	Any extra fields.
CustomFields	String	False	The contact details for the recipient.
PhoneNumber	String	False	The phone number of the recipient. Required if SMS collector. Should otherwise be excluded.
Duplicates	String	False	The intended behavior while adding a duplicate recipient. Values include 'add' (default), 'add_if_not_in_message', or 'add_if_not_in_collector'.
ContactId	String	False	The Id of the contact.

CData Python Connector for SurveyMonkey

CollectorRecipientDetails

Table Specific Information

Select

Columns