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 add-in 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. |