Forum Discussion
Azure Devops Table Expansion Issues
Hi, Has anyone used Azure Devops to join different tables? I'm trying to expand the already existing records in WorkItems/Areas/Team tables using odata but I get the below error I'm...
Hi Anonymous,
I was struggling with the same issue.
Here's my solution:
Add to your OData.Feed the following 'ingredients', starting with an ?
$Select=WorkItemId,WorkItemType => these are the fields you want to extraxt
$expand=Teams => this is the joined field you want to use (in this case Teams)
Source = OData.Feed("https://analytics.dev.azure.com/*yourCompany*/_odata/WorkItems?$Select=WorkItemId,WorkItemType,Title,State&&$expand=Teams")