Monday, October 24, 2011

Very simple example how to put Tweeter feed on the web-site using .NET and LINQ.

Twitter has a very rich API, but there are situations when you need to do a very simple thing: show last N twitter records authored by a certain Twitter user. How would we do that as simply as we can using .NET and LINQ?

// First create the request string. Put actual twitter account name instead of 'username'. You can also specify how
// many of the last records to retrieve 
string TwitterRequest = "http://twitter.com/statuses/user_timeline.xml?screen_name=username&count=5"; 
// Download the data in string
WebClient wc = new WebClient(); 
string TwitterResponse = wc.DownloadString(TwitterRequest); 
// Parse the string and put the data into XDocument
XDocument doc = new XDocument(); 
doc = XDocument.Parse(TwitterResponse); 
// Make a LINQ query - here we just need to get the first record
var q = from tw in doc.Descendants("status") 
        select tw;
/// Get the text of the tweet
if (q.Count() > 0)
{
    XElement xe = q.First();
    string twitter_text = xe.Element("text").Value;
    string twitter_date = xe.Element("created_at").Value
}

It's also worth mentioning that Twitter provides the 'date created' field in a format, that is not appropriate for direct conversion to DateTime data type. The date and time in a format like this 'Mon Oct 24 22:52:51 +0000 2011' will require certain string manipulation and splitting parts of the date/time before plugging into DateTime.


RECENT BLOG ENTRIES
30 November 2013
Bigcommerce template editing
How to change content in BigCommerce.com templates: guide for a complete newbie.
Read full story
09 October 2013
What if Fancybox does not work at all
If Fancybox library does not work, this might be due to the conflicts with other JS libraries and not the syntax error.
Read full story
14 October 2012
Fancybox with ASP.NET form on Umbraco
Using ASP.NET form on Fancybox popup to make login window
Read full story

Blog archive

The author of this web-site supports WWF . Please do your part in saving our planet!

Alex’s expertise in developing and maintaining web applications has been invaluable to the College – J. Wittersheim, Director of Information Management and Funding, Bury College