azureazure-devopsodata

Accessing azure custom field using OData query


I have created a Custom field in one of our azure DevOps projects. Field Reference Name: Custom.TestingType. enter image description here Now I want to access this field with an Odata query,

https://analytics.dev.azure.com/companyName-ProjectName/myProjectName/_odata/v4.0-preview/WorkItemSnapshot?  
$apply=filter(WorkItemType eq 'Test Case')
/groupby(
    (WorkItemId, Title, WorkItemType, State, Reason, Custom_Module, Iteration/IterationPath, ChangedDate, Custom_TestingType) 
)

Using above code I get an error. enter image description here

Also custom field is not available in the metadata. We accessing azure data schema metadata link e.g. https://analytics.dev.azure.com/companyName/myProjectName/_odata/v4.0-preview/$metadata


Solution

  • This issue resolved automatically. Newly created Custom filed on azure may takes time at least 1-2 days to reflect in metadata schema. New field appear immediately on azure filter query but access through oData query using power BI takes time.