Arguments

Name	Description	Default
resourceName

SQL Call

SELECT * FROM twitter.GetFields WHERE resourceName='timeline'

Http Call

/bsc/twitter/getfields

Output Columns

String Name
String MappedType

Arguments

Name	Description	Default
count	The number of items to retrieve (up to 100)	10

SQL Call

SELECT * FROM twitter.mentions WHERE count = 25
EXEC twitter.mentions 25

Http Call

/bsc/twitter/mentions

Output Columns

String contributors
String created_at
DateTime created_at_datetime
Int32 favorite_count
Boolean favorited
Int64 id
String id_str
String in_reply_to_screen_name
Int64 in_reply_to_status_id
String in_reply_to_status_id_str
Int64 in_reply_to_user_id
String in_reply_to_user_id_str
String lang
Int32 retweet_count
Boolean retweeted
String source
String text
Boolean truncated

Arguments

Name	Description	Default
status R	The tweet message to send
reply_to_id	In response to a user handle id
lat	Latitude of the tweet
long	Longtitude of the tweet
place_id	PlaceId of the tweet (see Twitter API for details)

SQL Call

EXEC twitter.PostStatus 'this is a tweet'

Http Call

/bsc/twitter/poststatus

Output Columns

String created_at
DateTime created_at_datetime
Int64 id
String id_str
String text
String source
Boolean truncated
Int64 in_reply_to_status_id
String in_reply_to_status_id_str
Int64 in_reply_to_user_id
String in_reply_to_user_id_str
String in_reply_to_screen_name
String contributors
Int32 retweet_count
Int32 favorite_count
Boolean favorited
Boolean retweeted
String lang

Arguments

SQL Call

SELECT Name FROM twitter.Resources

Http Call

/bsc/twitter/resources

Output Columns

String Name

Arguments

Name	Description	Default
contains R	A filter to use for tweets
count	The number of tweets to retrieve (up to 100)	10
locale	The locale to search for (us-us)
untildate	A maximum date for the search
sinceid	The tweet id to search from
maxid	The maximum tweet id to search from
lat	The latitude of the tweet, or the user's declared latitude
long	The longitude of the tweet, or the user's declared longitude
radius	The radius of the search
radiustype	The type of radius (mi or km)

SQL Call

exec twitter.search 'nasdaq', 10

Http Call

/bsc/twitter/search

Output Columns

String created_at	created_at
DateTime created_at_datetime	created_at_datetime
Int64 id	id
String id_str	id_str
String text	text
String source	source
String truncated	truncated
Int64 in_reply_to_status_id	in_reply_to_status_id
Int64 in_reply_to_user_id	in_reply_to_user_id
Int32 retweet_count	retweet_count
Int32 favorite_count	favorite_count
String favorited	favorited
String retweeted	retweeted
String lang	lang
String user_is_translator	is_translator
Int64 user_id	id
String user_id_str	id_str
String user_name	name
String user_screen_name	screen_name
String user_description	description
String user_url	url
Int32 user_followers_count	followers_count
Int32 user_friends_count	friends_count
Int32 user_listed_count	listed_count
String user_created_at	created_at
Int32 user_favourites_count	favorites_count
Int32 user_utc_offset	uct_offset
String user_time_zone	time_zone
String user_geo_enabled	geo_enabled
String user_verified	verified
Int32 user_statuses_count	statuses_count
String user_lang	lang
String user_contributors_enabled	contributors_enabled
String user_profile_background_color	profile_background_color
String user_profile_background_image_url	profile_background_image_url
String user_profile_background_image_url_https	profile_background_image_url_https
String user_profile_background_tile	profile_background_tile
String user_profile_image_url	profile_image_url
String user_profile_image_url_https	profile_image_url_https
String user_profile_link_color	profile_link_color
String user_profile_sidebar_border_color	profile_sidebar_border_color
String user_profile_sidebar_fill_color	profile_sidebar_fill_color
String user_profile_text_color	profile_text_color
String user_profile_use_background_image	profile_use_background_image
String user_default_profile	default_profile
String user_default_profile_image	default_profile_image
String user_following	following
String user_follow_request_sent	follow_request_sent
String user_notifications	notifications
String hashtags_text	hashtags_text
String urls_url	urls_url
String urls_expanded_url	expanded_url
String urls_display_url	display_url
String mention_screen_name	mention_screen_name
String mention_name	mention_name
String mention_id	mention_id
String mention_id_str	mention_id_str
String coordinates_latitude	coordinates_latitude
String coordinates_longitude	coordinates_longitude
String place_id	place_id
String place_url	place_url
String place_place_type	place_place_type
String place_name	place_name
String place_full_name	place_full_name
String place_country_code	place_country_code
String max_id	max_id
String since_id	since_id
String refresh_url	refresh_url
String next_result	next_result
String count	count
String completed_in	completed_in
String since_id_str	since_id_str
String query	query
String max_id_str	max_id_str

Arguments

Name	Description	Default
filter R	A filter to use for tweets
locale	The locale to search for (us-us)
untildate	A maximum date for the search
sinceid	The tweet id to search from
maxid	The maximum tweet id to search from
lat	The latitude of the tweet, or the user's declared latitude
long	The longitude of the tweet, or the user's declared longitude
radius	The radius of the search
radiustype	The type of radius (mi or km)

SQL Call

SELECT TOP 10 FROM twitter.timeline WHERE filter = 'nasdaq'

Http Call

/bsc/twitter/timeline

Output Columns

String created_at	created_at
DateTime created_at_datetime	created_at_datetime
Int64 id	id
String id_str	id_str
String text	text
String source	source
String truncated	truncated
Int64 in_reply_to_status_id	in_reply_to_status_id
Int64 in_reply_to_user_id	in_reply_to_user_id
Int32 retweet_count	retweet_count
Int32 favorite_count	favorite_count
String favorited	favorited
String retweeted	retweeted
String lang	lang
String user_is_translator	is_translator
Int64 user_id	id
String user_id_str	id_str
String user_name	name
String user_screen_name	screen_name
String user_description	description
String user_url	url
Int32 user_followers_count	followers_count
Int32 user_friends_count	friends_count
Int32 user_listed_count	listed_count
String user_created_at	created_at
Int32 user_favourites_count	favorites_count
Int32 user_utc_offset	uct_offset
String user_time_zone	time_zone
String user_geo_enabled	geo_enabled
String user_verified	verified
Int32 user_statuses_count	statuses_count
String user_lang	lang
String user_contributors_enabled	contributors_enabled
String user_profile_background_color	profile_background_color
String user_profile_background_image_url	profile_background_image_url
String user_profile_background_image_url_https	profile_background_image_url_https
String user_profile_background_tile	profile_background_tile
String user_profile_image_url	profile_image_url
String user_profile_image_url_https	profile_image_url_https
String user_profile_link_color	profile_link_color
String user_profile_sidebar_border_color	profile_sidebar_border_color
String user_profile_sidebar_fill_color	profile_sidebar_fill_color
String user_profile_text_color	profile_text_color
String user_profile_use_background_image	profile_use_background_image
String user_default_profile	default_profile
String user_default_profile_image	default_profile_image
String user_following	following
String user_follow_request_sent	follow_request_sent
String user_notifications	notifications
String hashtags_text	hashtags_text
String urls_url	urls_url
String urls_expanded_url	expanded_url
String urls_display_url	display_url
String mention_screen_name	mention_screen_name
String mention_name	mention_name
String mention_id	mention_id
String mention_id_str	mention_id_str
String coordinates_latitude	coordinates_latitude
String coordinates_longitude	coordinates_longitude
String place_id	place_id
String place_url	place_url
String place_place_type	place_place_type
String place_name	place_name
String place_full_name	place_full_name
String place_country_code	place_country_code
String max_id	max_id
String since_id	since_id
String refresh_url	refresh_url
String next_result	next_result
String count	count
String completed_in	completed_in
String since_id_str	since_id_str
String query	query
String max_id_str	max_id_str