Access TFS API using PowerShell

list-tfs-work-items.ps1

@(
    'Microsoft.TeamFoundation.Build.Client',
    'Microsoft.TeamFoundation.Build.Common',
    'Microsoft.TeamFoundation.Client',
    'Microsoft.TeamFoundation.WorkItemTracking.Client'
) | % {
    [Reflection.Assembly]::LoadWithPartialName($_) | Out-Null
}

$uri = [URI]"https://my-tfs-online.visualstudio.com/DefaultCollection/"
$projectCollection = [Microsoft.TeamFoundation.Client.TfsTeamProjectCollectionFactory]::GetTeamProjectCollection($uri)

$wis = $projectCollection.GetService([Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore])
$col = $wis.Query(@"
Select [State], [Title] 
From WorkItems
Where [System.TeamProject] = 'My Project'
Order By [State] Asc, [Changed Date] Desc
"@)

$col | Format-Table -Property Id, State, Title -AutoSize