Get Azure DevOps workitem and links of projects i have an access ?

[Anonymous]

Dear Folks,

I am pulling all the work items and links from Azure DevOps from projects I have access.

I have access only for a few projects in the organization.

I tried to use the below Odata query, however, it throws an error.

Can anyone please resolve, how can we add multiple projects to which I have access and pull works items and links of those projects?

let
    Source = OData.Feed("https://analytics.dev.azure.com/XYZArganzation/_odata/v4.0-preview/WorkItems?"
    &"&$filter=Project/ProjectName eq 'Project1' or Project/ProjectName eq 'Project2'"
    &"&$select=CreatedDate,WorkItemType,WorkItemId,Title,TagNames,State,Priority,Severity,"
    &"&$expand=Iteration($select=IterationPath),Area($select=AreaPath),Project($select=ProjectName),CreatedBy($select=UserName),"
        &"Links("
                &"$select=SourceWorkItemId,TargetWorkItemId,LinkTypeName;"
                &"$expand=TargetWorkItem($select=WorkItemId,Title,State,WorkItemType,Area)"
        &")"
                
                 ,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])


in
    Source

[ferryv]

I wrote an article a while back on LinkedIn on retrieving data from multiple Azure DevOps organisations and projects that might help you. 

https://www.linkedin.com/pulse/retrieve-data-from-multiple-azure-devops-microsoft-van-der-vorst/

[Anonymous]

I want to add 23 projects in Query so that I can have consolidated Data and also can create Consolidated Dashboard.

The query which u have mentioned, we are adding only One project name and not more than One.

[v-kkf-msft]

Hi @Anonymous ,

Please refer to the following format to prepare your query. For more information, please refer to: Create a Power BI report with an OData Query 

let
   Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? "
        &"$apply=filter( "
            &"WorkItemType eq 'Bug' "
            &"and StateCategory ne 'Completed' "
            &"and startswith(Area/AreaPath,'{areapath}') "
            &"and DateValue ge {startdate}  "
            &") "
        &"/groupby( "
            &"(DateValue,State,WorkItemType,Priority,Severity,Area/AreaPath,Iteration/IterationPath,AreaSK), "
            &"aggregate($count as Count) "
            &") "
    ,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]) 
in
    Source

Or please create a custom Analytics view to define the filtered set of data and other criteria to support your Power BI reporting needs. For more information, please refer to: https://docs.microsoft.com/azure/devops/report/powerbi/analytics-views-create?view=azure-devops 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.