Actions8
Select
AI-generatedSummary
Query Cosmos DB container using a SQL query
Inputs
- authenticationType — Authentication method (masterKey or Microsoft Entra ID)
- databaseName (required) — Name of the Cosmos DB database
- containerName (required) — Name of the Cosmos DB container
- sqlQuery (required) — SQL query to execute against the container
- options — Additional query options, such as excluding vector fields
Output shape
a list of result items
May be empty; errors appear only when continueOnFail is enabled, otherwise errors are thrown
Examples
Example 1: Retrieve active documents from a container
authenticationType=masterKey, databaseName=my-database, containerName=my-container, sqlQuery=SELECT * FROM c WHERE c.status = "active"