Endpoint

Create Permission Token for a User (One Table)

Name

create_token

Description

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

Parameters

Parameter

Label

Required

Options

Description

PermissionName

Permission Name (e.g. read_orders)

YES

User

User Name (Case-Sensitive)

YES

PermissionMode

YES

Option	Value
All	All
Read	Read
Write	Write
Delete	Delete

Table

Table (Add Permission for this)

YES

Database

Database Name (keep blank to use default) Case-Sensitive

Leave blank to use default DB set on connection screen

ExpiresInSecond

The validity period of the resource token returned by the operation. By default, a resource token is valid for one hour. To override the default, set this header with the desired validity period in seconds. The max override value is 18000, which is five hours.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
PermissionMode	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Resource	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Token	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

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

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.

Examples

SSIS

Use Cosmos DB Connector in API Source component to read data or in API Destination component to read/write data:

Create Permission Token for a User (One Table) using API Source

Cosmos DB

Create Permission Token for a User (One Table)

SSIS API Source - Read from table or endpoint

Create Permission Token for a User (One Table) using API Destination

Cosmos DB

Create Permission Token for a User (One Table)

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Create permission token for a user

SELECT * FROM create_token
WITH
(
    "PermissionName" = 'abcd-1234-permissionname',
    "User" = 'abcd-1234-user',
    "PermissionMode" = 'all',
    "Table" = 'abcd-1234-table'
)

SQL Server

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

Create permission token for a user

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM create_token
WITH
(
    "PermissionName" = ''abcd-1234-permissionname'',
    "User" = ''abcd-1234-user'',
    "PermissionMode" = ''all'',
    "Table" = ''abcd-1234-table''
)';

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];