JDBC Driver for Twitter

Build 22.0.8462

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.

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