OData Query to find Jon Skeet on StackOverflow

August 12, 2010

in OData,PowerShell,StackOverflow

Alex James, a Program Manager working on the Data Services team at Microsoft, tweeted this:

#OData query to find @jonskeet http://tinyurl.com/jonskeet200000

So, how would you find Jon Skeet using the OData PowerShell Module?

First, download OData PowerShell Explorer.

Then paste this code into the console or run it from ISE (Integrated Scripting Environment).

My OData PowerShell Explorer is extracted in C:\CodePlex\psodata\trunk. Change the directory in the Import-Module to where you extracted the zip.

PowerShell Code

import-module C:\CodePlex\psodata\trunk\modules\OData.psm1            
$se = New-ODataService `
  "http://odata.stackexchange.com/stackoverflow/atom"            
$se.Users('$filter=Reputation gt 200000')

Results

# Results            
AboutMe        : <p>
                 Author of <a href=`http://www.manning.com/affiliate/idevaffiliate.php?id=876_230` rel=`nofollow`>C# in Depth</a>.<br>
                 Currently a software engineer at Google, London.<br>
                 Microsoft MVP (C#, 2003 onwards)
                 </p>
                 
                 <p>Sites:</p>
                 
                 <ul>
                 <li><a href=`http://csharpindepth.com` rel=`nofollow`>C# in Depth</a>
                 <li><a href=`http://msmvps.com/jon.skeet` rel=`nofollow`>Coding blog</a>
                 <li><a href=`http://pobox.com/~skeet/csharp` rel=`nofollow`>C# articles</a>
                 <li><a href=`http://twitter.com/jonskeet` rel=`nofollow`>Twitter updates</a>
                 </ul>
                 
                 <p>Email: skeet@pobox.com</p>
                 
Age            : 34
CreationDate   : 2008-09-26T12:05:05.15
DisplayName    : Jon Skeet
DownVotes      : 295
EmailHash      : 6d8ebb117e8d83d74ea95fbdd0f87e13
Id             : 22656
LastAccessDate : 2010-08-01T21:54:18.477
Location       : Reading, UK
Reputation     : 200869
UpVotes        : 6460
Views          : 138078
WebsiteUrl     : http://csharpindepth.com

{ 0 comments… add one now }

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Contrat Creative Commons

© 2007-2013, Doug Finke