Cosmos DB Connector
Documentation
Version: 2
Documentation

EndPoint Delete a Document by Id


Name

delete_document

Description

Deletes a Document by Id. [API reference]

Parameters

Parameter Label Required Options Description
Id Document Id YES
Table Table Name (Case-Sensitive) YES
Database Database Name (keep blank to use default) Case-Sensitive NO Leave blank to use default DB set on connection screen
EnableCrossPartition EnableCrossPartition NO
Option Value
true true
false false
PartitionKey Partition Key Value (default is supplied Id) NO
Option Value
Default .
SingleKeyValue ["someValue1"]
MultiKeyValue ["some_value1","some_value2" ]
The partition key value for the document. Must be included if and only if the collection is created with a partitionKey definition

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(4000) 4000 False
Status DT_WSTR nvarchar(4000) 4000 False
Table DT_WSTR nvarchar(4000) 4000 False
StatusCode DT_I4 int False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(4000) 4000 False
Required columns that you need to supply are bolded.

Examples

SSIS

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

Delete rows from [Dynamic Table] table using API Destination

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]
Delete
SSIS API Destination - Access table operation