EndPoint Create a document in the container

Name

create_document

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

Parameter

Label

Required

Options

Description

Table

Table Name (Case-Sensitive)

YES

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

Upsert

Enable Upsert Mode (update if document found)

Option	Value
true	true
false	false

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:

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]

Insert