Twitter API program enables businesses to create and manage ad campaigns programmatically on Twitter. Official Twitter Ads API documentation is available here.
How to Connect
There are two ways to connect to Twitter: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.
1. Go to the Sources tab and click + New Source:
2. Find the Twitter button in the list of connectors or type ‘twitter’ in the search field:
3. Click the button to open the chat and set up the connection with the help of our support team.
Usage
The Twitter API connector introduces a new virtual schema twitter that contains the following stored procedures:
In addition to these public API procedures, there are a couple of views in another virtual schema twitter_examples that shows an exemplary usage of the public API:
If not needed, you can delete all the example views directly by dropping twitter_examples.