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 provider will execute other filters client-side in memory.
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. |