Icon

01_​Collecting_​data_​from_​Twitter

Twitter Data Collection
Twitter Data CollectionThis workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow,tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are writtento that same table.For longitudinal data collection, the workflow may be periodically executed manually, run via command line using the batch executoror optimally scheduled for regular execution via the KNIME Server (https://www.knime.org/knime-server). The Twitter API Connector requires API keys andaccess tokens to execute successfully. Togenerate these you will need to go to your twitteraccount at dev.twitter.com and register yourapplication under "My Applications". The API keyshould be immediately available and accesstokens may be generated and revoked as needed.Both should be available from the API Keys tab ofthe page for your application. Enter API Key here(see node descriptionfor details)Enter searchterms hereFavoriate/RetweetsRemove UpdatedExtra ColumnsWrite new tweetsConnect to DB Twitter APIConnector Twitter Search Database Update Row Filter Column Filter Database Writer SQLite Connector Twitter Data CollectionThis workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow,tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are writtento that same table.For longitudinal data collection, the workflow may be periodically executed manually, run via command line using the batch executoror optimally scheduled for regular execution via the KNIME Server (https://www.knime.org/knime-server). The Twitter API Connector requires API keys andaccess tokens to execute successfully. Togenerate these you will need to go to your twitteraccount at dev.twitter.com and register yourapplication under "My Applications". The API keyshould be immediately available and accesstokens may be generated and revoked as needed.Both should be available from the API Keys tab ofthe page for your application. Enter API Key here(see node descriptionfor details)Enter searchterms hereFavoriate/RetweetsRemove UpdatedExtra ColumnsWrite new tweetsConnect to DB Twitter APIConnector Twitter Search Database Update Row Filter Column Filter Database Writer SQLite Connector

Nodes

Extensions

Links