CollectorMessages
Displays information regarding messages sent from a collector.
Table Specific Information
Select
You must specify the collector Id to query from this view. The connector 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 [KEY] | String | The Id of the collector the message belongs to. |
| Status | String | The status of the message. |
| Type | String | The message type. Values include 'invite', 'reminder', or 'thank_you'. |
| Subject | String | The subject of the message. Only available if resource is being queried by Id. |
| Body | String | The HTML body of the message. Only available if resource is being queried by Id. |
| DateCreated | Datetime | The date the message was created. Only available if resource is being queried by Id. |
| ScheduledDate | Datetime | The date the message is scheduled to be sent. If Null, the message has not been scheduled to send. Only available if the resource is being queried by Id. |
| EmbedFirstQuestion | Boolean | Indicates 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 the message. Only available if resource is being queried by Id. |
| IsBrandingEnabled | Boolean | Indicates whether branding is enabled for the message. Only available if resource is being queried by Id. |
| IsScheduled | Boolean | Indicates whether the message is scheduled. Only available if resource is being queried by Id. |
| RecipientStatus | String | The recipient filter. Values include 'reminder' or 'thank_you'. Only available if resource is being queried by Id. |