TFS API - WIQL - Query only returns id and url

Question

I am trying to execute a WIQL query on TFS server (following this example) and get work items with the tittle and other fields. Even though I define the columns I want on the output, the json returned only with id and url.

Query

 Select [System.Title],
    [System.Description],
    [System.WorkItemType],[System.Id]
    From WorkItems 
    Where [System.WorkItemType] = 'Task' 
       AND [State] <> 'Closed' 
       AND [State] <> 'Removed' 
      AND [System.AssignedTo] = @me 
    order by [Microsoft.VSTS.Common.Priority] asc, [System.CreatedDate] desc

Json returned

{"queryType":"flat","queryResultType":"workItem","asOf":"2016-03-18T22:53:15.777Z","columns":[{"referenceName":"System.Title","name":"Title","url":"http:///tfs/DefaultCollection/_apis/wit/fields/System.Title"},{"referenceName":"System.Description","name":"Description","url":"http:///tfs/DefaultCollection/_apis/wit/fields/System.Description"},{"referenceName":"System.WorkItemType","name":"Work Item Type","url":"http:///tfs/DefaultCollection/_apis/wit/fields/System.WorkItemType"},{"referenceName":"System.Id","name":"ID","url":"http:///tfs/DefaultCollection/_apis/wit/fields/System.Id"}],"sortColumns":[{"field":{"referenceName":"Microsoft.VSTS.Common.Priority","name":"Priority","url":"http:///tfs/DefaultCollection/_apis/wit/fields/Microsoft.VSTS.Common.Priority"},"descending":false},{"field":{"referenceName":"System.CreatedDate","name":"Created Date","url":"http:///tfs/DefaultCollection/_apis/wit/fields/System.CreatedDate"},"descending":true}],"workItems":[{"id":6760,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6760"},{"id":6734,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6734"},{"id":6731,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6731"},{"id":6526,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6526"},{"id":6525,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6525"},{"id":6524,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6524"},{"id":6514,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6514"},{"id":6372,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6372"},{"id":6371,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6371"},{"id":6235,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6235"},{"id":6218,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6218"},{"id":6123,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6123"},{"id":6122,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6122"},{"id":6121,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6121"},{"id":6120,"url":"http:///tfs/DefaultCollection/_apis/wit/workItems/6120"}]}

Is there any flag that I should pass to the query so I can get those fields on the ouput?

TFS API - WIQL - Query only returns id and url

1 Answers