Cosmos DB Connector
Documentation
Version: 2
Documentation

EndPoint Get User by Id or Name


Name

get_user

Description

Gets database user information for a specific Id [API reference]

Parameters

Parameter Label Required Options Description
Id User Name (Case-Sensitive) YES
Database Database Name (keep blank to use default) Case-Sensitive NO Leave blank to use default DB set on connection screen

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(255) 255 False The unique name that identifies the collection.
ResourceId DT_WSTR nvarchar(2000) 2000 False System generated property. The resource ID is a unique identifier that is also hierarchical per the resource stack on the resource model. It is used internally for placement and navigation of the permission resource.
LastUpdated DT_I4 int False System generated property. Specifies the last updated timestamp of the resource.
ETag DT_WSTR nvarchar(4000) 4000 False System generated property representing the resource etag required for optimistic concurrency control.
Permissions DT_WSTR nvarchar(4000) 4000 False System generated property that specifies the addressable path of the conflicts resource. During an operation on a resource within a collection, if a conflict occurs, users can inspect the conflicting resources by performing a GET on the conflicts URI path.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.