Skip to main content
Version: 2.50.0-LTS

Cosmosdb

ToolJet can connect to CosmosDB databases to read and write data.

Connection​

To establish a connection with the CosmosDB data source, you can either click on the +Add new data source button located on the query panel or navigate to the Data Sources page through the ToolJet dashboard.

ToolJet requires the following to connect to your Cosmos DB.

  • Cosmos DB Account End point
  • Cosmos DB Account Key
info

Azure Cosmos DB End point is the URL of the Cosmos DB service. Azure Cosmos DB Key is the key that is used to access the Cosmos DB service. You can find the endpoint and key in the Azure Portal.

ToolJet - Data source - CosmosDB

Supported Queries:​

Listing Databases​

This query lists all the databases in a Cosmos DB.

Listing Containers​

This query lists all the containers of a database in a Cosmos DB.

FieldsDescription
databaseid of the database

Inserting Item(s)​

This query inserts one or more items in a container of a database in a Cosmos DB.

FieldsDescription
databaseid of the database
containerid of the container
itemsitems to be inserted. Example: {{[{name: "one", val: 1}, {name:"two", val: 2}]}}

Retrieving An Item​

To read a single item from a container of a database in a Cosmos DB, use the following query.

FieldsDescription
databaseid of the database
containerid of the container
itemid of the item

Deleting An Item​

To delete an item from a container of a database in a Cosmos DB, use the following query.

FieldsDescription
databaseid of the database
containerid of the container
itemid of the item

Querying Documents​

To query documents from a container of a database in a Cosmos DB using SQL-like syntax, use the following query.

FieldsDescription
databaseid of the database
containerid of the container
queryquery to be executed. Example: SELECT * FROM c WHERE c.age > 20 AND c.age <= 30