Excel Add-In for Azure DevOps

Build 24.0.9060

Users

List Users

Table Specific Information

Select

The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the add-in.

  • UserSK supports the '=,in' operators.
For example:
	
	SELECT * FROM Users WHERE UserSK = '4dbc0cec-c473-652b-972f-f42587b4494d'
	SELECT * FROM Users WHERE UserSK IN ('4dbc0cec-c473-652b-972f-f42587b4494d', '6ddc3cee-c232-634b-342f-f84325b4494d')

Columns

Name Type References Description
ParentReference String
UserSK [KEY] String
UserEmail String
UserId String
UserName String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060