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?
534 Views Asked by Cyril Cereaic Joseph At
1
There are 1 best solutions below
Related Questions in AZURE-DEVOPS
- Pushing to git repository hosted by Visual studio online without entering user name and password
- Generate folder structure of a changeset after checkin in VSO
- OpsHub Visual Studio Online Migration Utility Hangs on Creating Configuration
- Could not write destination file: Access to path 'd:\a\src\...\Web.config' is denied
- hosted build visual studio online
- VSTS Rest API Get WorkItems By Field Value
- xunit.runner.dnx on visual studio online no tests found
- OpsHub User Mapping Error
- Kick off mocha tests in Visual Studio Team Services Build
- Visual Studio Online - Build - There are agents that are capable of running the build, but they are not online
- on-premise TFS to VSO issues using OpsHub 1.2.0.000
- Git tag at the end of build on Visual Studio Online (Build vNext, hosted pool)
- Get Latest Version using command-line from VSO?
- Visual Studio Team Services workspace error
- How to cache credentials for VS online in posh-git?
Related Questions in ODATA
- kendo - datasource - parameterMap does not bind parameters
- Creating Odata Web API application without Entity Framework
- ASP.NET Odata Web API Composable function issue
- What the format should look like for a Function Import Response which returning a simple type?
- Web API: Odata route always returning a 404 response
- Odata post always returns "HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed,"
- solution architecture for an OData / Web API based .Net project
- WCF Data Services, WindowsAzure.Storage and Microsoft.Data.OData version nightmare
- How to wisely combine shingles and edgeNgram to provide flexible full text search?
- Connect to SharePoint Lists with OData
- Freeze a linq IQueryable (as a ToList().AsQueryable() would do)
- Can I create a file to subdirectory on OneDrive for Business with REST API?
- Simple.OData.Client - Unable to invoke Action that accepts entity collection parameter
- oData deserialization issue in application
- Accessing JSON object in SAPUI5 via xsodata
Related Questions in DEVOPS
- Error when adding a new build stage on Bluemix DevOps Services
- Capistrano current/ directory doesn't get created
- Using puppet to create a lvm with dynamic size
- Jenkins - (private subnet) WebHook with Github does not trigger automatic build
- How to automate the creation of a vCAP user-defined variable in a Bluemix deployment?
- Jenkins - Webhooks OR PollSCM
- Iterating over EncryptedDataBagItem in Chef Recipe
- add newly created AWS EC2 IP to Ansible inventory at runtime
- JazzHub and Bitbucket
- Continuous Deployment with Bitbucket and Jazzhub
- Jenkins - Access to build logs, artifacts, git-commit change logs of upstream builds
- Chef - difference between knife.rb and solo.rb
- What tools are there to visualise the merge structure of dozens of git branches?
- Using attributes in Chef
- Ansible error message
Related Questions in AZURE-DEVOPS-REST-API
- VSTS Rest API Get WorkItems By Field Value
- How to create a custom widget using TFS data?
- Insert variables or API output into table
- TFS API Create Release with powershell
- Can ExtensionDataService be used from a PowerShell-based VSTS build task?
- Get TFS work item and its links using REST API
- Include code coverage report in VSTS, Is Test Adapter mandatory for VSTS?
- Azure Arm template deployment of a web app zip package programmatically using build artifact
- Get teams I am member of
- How to limit build task only to VSTS not TFS
- VSTS work item creation throttling issue with vsts-node-api
- How to use Release Definition REST API for VSTS?
- Why does vsts-node-api always return Invalid Resource - 401?
- VSTS Hub events
- Can I set "Default branch for manual and scheduled builds" for a pipeline in Azure DevOps using an API?
Related Questions in DEVOPS-SERVICES
- AWS disksize degradation
- Regarding non-availability of Project Management Chart
- How do I use Gitlab code/project in Azure DevOps
- Odata results displaying user id values under certain columns instead of usernames when data imported into excel from devops?
- How to create Authkey for concoure server that can be used in API Calls to the concourse sever?
- How to call spring api from frontend in kubernetes
- IBM Cloud DevOps continuous delivery pipeline Node version too low
- 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 start previous successful release automatically in Devops/VSTS
- is there any specific permssion in Azure devops for code review?
- Why we use environments under pipelines in Azure Devops? and is there any Monthly/Yearly limitation in creating builds / releases?
- How to apply the different firewall rules on multiple agents from Puppet master?
- Extract Alerts logs from Azure without Azure security Centre
- 'Automated' option not shown in 'Automation Status' dropdown in Testcase work Item in Azure Devops
- How can we implement security for agent pools in Azure Devops
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 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: