Endpoint

Upsert a document in the container

Name

upsert_document

Insert JSON document in Cosmos DB Container. [API reference]

Parameter

Label

Required

Options

Description

Table

Table Name (Case-Sensitive)

YES

Upsert

Database

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

Leave blank to use default DB set on connection screen

Document

PartitionKey

Partition Key Value (default is supplied Id)

The partition key value for the document. Must be included if and only if the collection is created with a partitionKey definition

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
_rid	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
_ts	`DT_I8`	`bigint`		`False`
http_status	`DT_I4`	`int`		`False`

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

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
PartitionKey	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Document	`DT_NTEXT`	`nvarchar(MAX)`		`False`

Required columns that you need to supply are bolded.

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

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Cosmos DB

[Dynamic Table]

Upsert

Use these SQL queries in your ODBC application data source:

SELECT * FROM upsert_document

upsert_document endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).

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

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

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];

upsert_document endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).