List teams (specific columns)

Returns teams with only the columns you select (e.g. Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl). Use this to keep result sets small or to build pickers and reports that need a subset of team fields.

SELECT Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl FROM Teams