Forum Discussion

FlowViz's avatar
FlowViz
Helper III
4 years ago
Solved

OData query with missing column

Hey guys,   I have a query I use for Azure DevOps:   https://analytics.dev.azure.com/{Organization}/{Project}/_odata/v3.0-preview/WorkItemRevisions?$select=WorkItemId,Title,AreaSK,Blocked,Projec...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    FlowViz 

    Try add a query step to your code, for example:

    #"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"})
in
#"Column"

     

     

    Best regards
    Paul

  • FlowViz's avatar
    FlowViz
    4 years ago

    Thanks - this is what I think I'm using atm:

    #"Removed Columns" = Table.SelectColumns(Source,{"WorkItemId", "AreaSK", "Blocked", "InProgressDate", "InProgressDateSK", "State", "TagNames","Title", "WorkItemType", "ChangedDate", "ProjectSK","StateCategory"}, MissingField.UseNull),
mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

If you get an error when you make a call with the Blocked column in the $select but it doesn't exist for that project, you could use try ... otherwise ... and check first with the Blocked version otherwise use the one w/o it.  Multiple web calls in some cases, but it should work.

 

Pat