TDV Adapter for SurveyMonkey

Build 21.0.8137

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 adapter 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.
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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137