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`

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:

Cosmos DB

Upsert a document in the container

Cosmos DB

Upsert a document in the container