cosmosdb_query_items
Run SQL queries against a Cosmos DB container to retrieve data, with a maximum of 1000 items. Cross-partition queries are enabled by default.
Instructions
Run a SQL query against a Cosmos DB container and return results.
Uses Cosmos DB SQL API syntax, e.g.: SELECT * FROM c WHERE c.status = 'active' SELECT c.id, c.name FROM c ORDER BY c._ts DESC
max_items is capped at 1000. Cross-partition queries are enabled automatically. Use cosmosdb_query_items_to_file instead if the result set may be large.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | Yes | ||
| database | Yes | ||
| container | Yes | ||
| query | Yes | ||
| max_items | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |