OData query with missing column

[FlowViz]

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,ProjectSK,CycleTimeDays,ChangedDate,ChangedDateSK,TagNames,CompletedDateSK,CompletedDate

The problem is, some projects contain the blocked column in the data table, some do not. I want to have one query I can use regardless of project, albeit I want to just bring in the necessary columns rather than them all.

Anyone have any advice?

[Anonymous · Accepted solution]

@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

[Anonymous · Accepted solution]

@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 · Accepted solution]

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]

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

[FlowViz]

Previously I've used 

https://analytics.dev.azure.com/{Organization}/{Project}/_odata/v3.0-preview/WorkItemRevisions?

And brought in all columns then used MissingField.UseNull to filter...

[edhans]

Can you bring in the query name vs having the columns listed in the URL like that?