Reference

Endpoint Create User for Database

Name

create_user

Create a new user which you can later use to create permission set and obtain resource token. [API reference]

Parameter	Required	Options
Name: Database Label: Database Name (keep blank to use default) Case-Sensitive Leave blank to use default DB set on connection screen
Name: RequestBody Label: RequestBody

Label	Data Type (SSIS)	Data Type (SQL)	Length	Description
Id	`DT_WSTR`	`nvarchar(255)`	255	The unique name that identifies the collection.
ResourceId	`DT_WSTR`	`nvarchar(2000)`	2000	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`		System generated property. Specifies the last updated timestamp of the resource.
ETag	`DT_WSTR`	`nvarchar(4000)`	4000	System generated property representing the resource etag required for optimistic concurrency control.
Permissions	`DT_WSTR`	`nvarchar(4000)`	4000	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.

If the column you are looking for is missing, consider customizing Cosmos DB Connector.

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

Use Cosmos DB Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source - Cosmos DB

Connect to your Azure Cosmos DB databases to read, query, create, update, and delete documents and more!

Cosmos DB

Create User for Database

Optional Parameters
Database Name (keep blank to use default) Case-Sensitive
RequestBody	{"id": "TYPE_USERNAME_HERE"}

API Destination - Cosmos DB

Connect to your Azure Cosmos DB databases to read, query, create, update, and delete documents and more!

Cosmos DB

Create User for Database

Optional Parameters
Database Name (keep blank to use default) Case-Sensitive
RequestBody	{"id": "TYPE_USERNAME_HERE"}

Use these SQL queries in your ODBC application data source:

SELECT * FROM create_user

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM create_user';

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];