Odata results displaying user id values under certain columns instead of usernames when data imported into excel from devops?
I imported certain Workitems data from my Devops project into excel using Odata queries.
In that data under certain columns for eg: AssignedToUserSK its showing the user id values like this 06ea0e70-432d-4315-8ffd-87706966a7b6
Instead of this i need the username to be displayed instead of user id.
How to solve this?
Solution
If you want to see usernames in the Odate query instead of user id, you need add the columns AssignedTo.UserName, CreatedBy.UserName and ChangedBy.UserName. Then you can see the user name.
Result:
- DevOps deploying Azure Web Apps to wwwroot/Content/D_C/a/1/s/ in Linux container
- Azure DevOps: access secret variable programmatically
- How to install PowerShell module pushed to Azure Artifacts in Pipelines?
- Get all work items from a project azure devops REST API
- Which scope takes precedence in an release pipeline variable?
- In Azure DevOps, need to view and prioritize Features, Product Backlog Items and Bugs in one list in relation to each other
- CICD of data factory
- Can't multi-target projects in azure pipeline build
- Preview state of azure pipeline yaml after supplying it with runtime parameters
- How do I identify the triggering pipeline in the download step when downloading pipeline artifacts in Azure DevOps on-prem?
- JIRA Azure DevOps iteration not showing work item in Azure DevOps
- Azure DevOps build Artifact Error because of Failed to fetch ARM parameters: Error: Input required: AzureResourceManagerConnection
- Issue with Azure DevOps API: Newly Created Area Paths Not Recognized Immediately
- How to add tag to a build from classic release after successful deployment to stage
- I don't see the menu entries for releases
- Azure DevOps Rest API : Object "ID" scope
- Getting "BadRequest" when trying to deploy web app networking settings using Bicep trmplate
- Accessing Azure DevOps Board custom field using OData query
- AzureStaticWebApp@0 push from artifacts
- Azure DevOps - deploy Window Service task
- CICD for Azure Databricks
- Trigger Azure DevOps pipeline only for "main" AND changes in a certain path
- Azure Pipelines - Replace a variable in a yaml file
- Azure dev ops cicd yaml variable for appSettings, multi line causing an error
- .Net Azure Function app publish does not generate a bin folder
- Git cleanup/garbage collection on remote Azure DevOps git repository
- Run build only on approval
- Azure DevOps is not gathering all changes when using schduled cron trigger
- yaml pipeline: How to use a build artifact generated in a previous build
- How to resolve eslint errors due to use of the html() method in jquery libraries when running security scans with Github advanced security?