DirectMessages
Send direct messages and query messages sent and received by the authenticated user.
Table Specific Information
Direct messages that have been sent and received by the authenticated user will appear in DirectMessages.
Select
The Min_Id and Max_Id pseudo columns may be used to narrow down a range of direct messages to return, or to return only recent direct messages. The Id may be specified to return a specific direct message.
Insert
New direct messages may be sent by performing an insert. Note that only Text and the Recipient_Id may be specified in an insert. In order to attach a media to the message, simply specify the media file paths MediaFilePath or the MediaId for the media file in the INSERT command.It is possible to attach only one media to a message. For example:
INSERT INTO DirectMessages (Recipient_Id, Text, MediaFilePath) VALUES ('0000000000000000000', 'Hello World', 'C:\\myFile.jpg')
INSERT INTO DirectMessages (Recipient_Id, Text, MediaId) VALUES ('1001073178217713668', 'Hello World', '1001072801250529280')
Update
The UPDATE operation is not available on this table.
Delete
Direct messages may be deleted by using the DELETE operation.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The Id of the direct message. |
| Created_At | Datetime | True |
When the direct message was made. |
| Text | String | True |
The text of the direct message. |
| Sender_Id | String | True |
The Id for the sender of the message. |
| Source_App_Id | String | True |
The name for the sender of the message. |
| Recipient_ID | String | True |
The Id for the recipient of the message. |
| User_Mentions | String | True |
Mentions of other users in the tweet, returned as an XML aggregate. |
| URLs | String | True |
URLs in the tweet, returned as an XML aggregate. |
| Hashtags | String | True |
Hashtags in the tweet, returned as an XML aggregate. |
| Attachment_Id | String | True |
Identifier of the media attached to the message. |
| Attachment_Url | String | True |
Url of the media attached to the message. |
| Attachment_Type | String | True |
Type of media attached to the message. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| NextPageToken | String |
An identifier to retrieve the next page of results. Specify only if an error occurs during the original request. Make sure any criteria specified in the original request are still specified when using the NextPageToken. |
| Min_ID | String |
Specifies the lowest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only direct messages that are equal to or newer than the creation date of the specified Id will be returned. The Min_Id column must be a valid number but does not need to be a valid direct message Id. |
| Max_ID | String |
Specifies the highest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only direct messages that are equal to or older than the creation date of the specified Id will be returned. The Max_Id column must be a valid number but does not need to be a valid direct message Id. |
| MediaId | String |
The media Ids to associate with the tweet. |
| MediaFilePath | String |
The media file path to associate with the tweet. |
| Include_Entities | Boolean |
Boolean indicating whether or not to include entities such as URLs, hashtags, and user mentions in the response. The default value is false. |