JDBC Driver for SurveyMonkey

Build 22.0.8462

CollectorMessages

Shows information regarding 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 CollectorMessages WHERE CollectorId = '175305200'

SELECT * FROM CollectorMessages WHERE CollectorId = '175305200' AND Id = '57071816'

Columns

Name Type Description
Id [KEY] String The Id of the message.
CollectorId String The Id of the collector this message belongs to.
Status String The status of this message.
Type String Message type: 'invite', 'reminder', or 'thank_you'.
Subject String The subject of this message. Only available if resource is being queried by Id.
Body String The html body of this message. Only available if resource is being queried by Id.
DateCreated Datetime Date message was created. Only available if resource is being queried by Id.
ScheduledDate Datetime Date message is scheduled to be sent. If Null, message has not been scheduled to send. Only available if resource is being queried by Id.
EmbedFirstQuestion Boolean Whether to embed the first question to the message. Only available if resource is being queried by Id.
EditMessageLink String The link to the resource to edit this message. Only available if resource is being queried by Id.
IsBrandingEnabled Boolean Whether branding is enabled for this message. Only available if resource is being queried by Id.
IsScheduled Boolean Whether this message is scheduled. Only available if resource is being queried by Id.
RecipientStatus String Recipient filter: 'reminder' or 'thank_you'. Only available if resource is being queried by Id.

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