cosmosdb_item_query
Query items in a Cosmos DB container using SQL syntax. Specify the container, database, and optional parameters to retrieve targeted data efficiently.
Instructions
Query items in a Cosmos DB container using SQL
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| container_name | Yes | Name of the Cosmos DB container | |
| database_name | No | Name of the Cosmos DB database (optional, defaults to 'defaultdb') | |
| parameters | No | Parameters for the SQL query (optional) | |
| query | Yes | Cosmos DB SQL query string |
Input Schema (JSON Schema)
{
"properties": {
"container_name": {
"description": "Name of the Cosmos DB container",
"type": "string"
},
"database_name": {
"description": "Name of the Cosmos DB database (optional, defaults to 'defaultdb')",
"type": "string"
},
"parameters": {
"description": "Parameters for the SQL query (optional)",
"items": {
"properties": {
"name": {
"type": "string"
},
"value": {}
},
"type": "object"
},
"type": "array"
},
"query": {
"description": "Cosmos DB SQL query string",
"type": "string"
}
},
"required": [
"container_name",
"query"
],
"type": "object"
}