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?
Odata results displaying user id values under certain columns instead of usernames when data imported into excel from devops?
537 Views Asked by Cyril Cereaic Joseph At
1
There are 1 best solutions below
Related Questions in AZURE-DEVOPS
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Error: VS800075 when downloading artifact from another project
- Azure Scale Sets and Parallel Jobs
- Get current Timestamp in CET format and concatenate with string in yml file
- Post-Job Checkout Hanging in Azure DevOps Pipelines
- Referencing yml file from submodule in main pipeline
- Where to find a User Story draft?
- Self Hosted Agent service startup getting failed on VM restart
- Azure pipeline unable to deploy via a bicep file and set values for its parameters
- Dacpac deployment to Azure via SSMS failed: Cannot alter the role db_owner
- NodeJS [Errno 13] Permission denied - Azure DevOps pipleline AWS Lambda deployment
- Share variables across stages in azure pipelines with templates
- Can I move an Azure Data Factory Pipeline to Azure DevOps?
- How to migrate a single workitem in Devops
- Deploy Docker Image into AKS cluster using Azure Release Pipelines with the parameters like clustername, acr, resourcegroup
Related Questions in ODATA
- How to serialize the entire Microsoft.AspNetCore.OData.Results.PageResult<T> object with Newtonsoft.Json in .NET 6?
- possible to index singleValueExtendedProperties in MsGraph?
- D365 F&O - Cannot post addresses with OData
- How to get access token correctly from SAP Successfactors api?
- Odata filter DateTime casting string to DateTime and Filtering
- Response payload is not odata payload
- how to remove namespace from query string to filter an enum field with OData V4 in .NET
- Odata Put endpoint doesn't work as expected on ASP.NET Core MVC web service
- Odata filter query Unrecognized 'Edm.String' literal 'datetime'
- OData unit testing in .NET Core 6.0
- OData rest API with MS Project Online (SharePoint) "User not found in active directory or Project db
- How to upload data in power apps table using python
- ASP.NET Core OData creating generic pass through controller for underlying APIs
- MS Graph /drives/{drive-id}/items/{item-id}/children filter not folders
- Connecting to URL with Token within SSIS
Related Questions in DEVOPS
- Elasticbeanstalk FastAPI application is intermittently not responding to https requests
- Get current Timestamp in CET format and concatenate with string in yml file
- AWS EKS Fargate pod scheduling issue with Prometheus deployment
- Jenkins Docker Agent Configuration Issue: Connection Refused on Local Ubuntu Install
- Unable to use env variable from prd environment context
- Search to know the best way to do a " Database on demand " for a personal project
- Can I know the namespace of my k8s Pod only by looking at its IP?
- Struggling with Route53 public hosted zones in a multi-account environment
- "Backend call failure" error in Nextjs App deployed on Azure static web app
- Terraform: Error: Provider configuration not present. Module gets created, but when I remove or comment it throws an error
- Azure Dev Ops - Project - Mentions - Restrictions on Users and Groups
- How to Generate a Migration Script in the Azure DevOps
- Disable Azure DevOps Pull Request being completed when Using Copado
- How to add bulk users ( using a csv file ) to an AzureDevops Group using Powershell
- How to add .env file while deploying app using Jenkins Pipeline script from SCM?
Related Questions in AZURE-DEVOPS-REST-API
- Powershell script started failing to add new release variable via the API "Error: An empty body in the POST request is not allowed"
- VssUnauthorizedException: VS30063: You are not authorized to access https://xxxx.visualstudio.com
- How does Azure DevOps handle HTML structure changes in Description fields?
- How to hide a process's field from layout?
- Azure devops rest api is giving me only few releases information.?
- does azure devops support dynamic retrieval of value from 3rd party rest API
- Azure DevOps REST api to add continuous deployment trigger
- Disable Continuous Integration on Pipeline using the Azure DevOps REST API
- Add Variables to Pipelines using the Azure DevOps REST API
- Error Deleting Remote Git Branch via Azure DevOps API: Unsupported HTTP Method 'POST'
- Referencing variables in yaml that are passed from ADO REST Api
- How to extract a list of builds from devops using rest api that includes message info for manually triggered builds as well as auto builds
- Get info about approvals and checks for azure devops environments
- Is there an azure cli command that gets the threads and comments on a PR?
- How to get the result of the latest/last pipeline build in Azure DevOps
Related Questions in DEVOPS-SERVICES
- Change the format of timestamp that return my script - azure devops service
- How can we copy a bulk of workitems from one project to another in Azure Devops?
- Odata results displaying user id values under certain columns instead of usernames when data imported into excel from devops?
- How do I use Gitlab code/project in Azure DevOps
- Regarding non-availability of Project Management Chart
- How to start previous successful release automatically in Devops/VSTS
- it is possible by means of a pipeline of Microsoft devops to restore a backup .bak in a resource of SQL Server in Microsoft Azure?
- How to add new custom categories for work item states in azure devops?
- How to list the changed file names in the latest build comparing with old in GIT?
- Where did Jenkins find `groovy-html.template`?
- How can we implement security for agent pools in Azure Devops
- 'Automated' option not shown in 'Automation Status' dropdown in Testcase work Item in Azure Devops
- Extract Alerts logs from Azure without Azure security Centre
- How to apply the different firewall rules on multiple agents from Puppet master?
- Why we use environments under pipelines in Azure Devops? and is there any Monthly/Yearly limitation in creating builds / releases?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you want to see usernames in the Odate query instead of user id, you need add the columns
AssignedTo.UserName,CreatedBy.UserNameandChangedBy.UserName. Then you can see the user name.Result: