Forum Discussion
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,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?
FlowViz
Try add a query step to your code, for example:#"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"}) in #"Column"Best regards
PaulThanks - 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),
5 Replies
Can you bring in the query name vs having the columns listed in the URL like that?
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...
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
Try add a query step to your code, for example:#"Column"=Table.SelectColumns(Users_table,{"ID","Date","Type","Amount"}) in #"Column"Best regards
PaulThanks - 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),
