Endpoint

Update Document in the Container

Name

update_document

Update full or part of the document in Cosmos DB Container. [API reference]

Parameter

Label

Required

Options

Description

Table

Table Name (Case-Sensitive)

YES

Document Id

Database

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

Leave blank to use default DB set on connection screen

Document

Full Document if RequestMethod=PUT else Partial Document [API reference]

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
RequestMethod	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
PartitionKey	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Id	`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]

Update

Use these SQL queries in your ODBC application data source:

SELECT * FROM update_document

update_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 update_document';

EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];

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