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),
Anonymous's avatar
Anonymous
Not applicable
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
Helper III
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),