EndPoint Upsert a document in the container

Contents

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.