Posts

Showing posts from July, 2017

Calling DocumentDB (CosmosDB) Stored Procedure from Azure Logic App

Image
In this blog post we will learn how to call DocumentDB Stored Procedure from Azure Logic App.  If you are not familiar with Azure DocumentDB (CosmosDB) please go through my previous article - Working with Stored Procedure in Azure DocumentDB (CosmosDB) URL:  http://learntechalways.blogspot.in/2017/07/working-with-stored-procedure-in-azure.html We will be using Stored Procedure created in my earlier post. If you have not created your Stored Procedure in Azure Cosmos DB, please follow the steps mentioned in blog- Working with Stored Procedure in Azure DocumentDB (CosmosDB) Let's start creating Logic App- Login to Azure Portal. Click on new in left panel. Search for Azure Logic App. Click on "Logic App". Click on "Create" button. Provide details e.g.- Logic App name, Resource group & location. Click on "Create" button. Select Logic app & open designer in edit mode. This will open different ...

Working with Stored Procedure in Azure DocumentDB (CosmosDB)

Image
In this blog post we will learn how to create & test Stored Procedure in Azure DocumentDB (CosmosDB). Login to Azure Portal & click on New. Search for cosmosDB- Click on "Azure Cosmos DB". Click on "Create". Fill up all details e.g.- CosmosDB ID, API (for this demonstration we will select DocumentDB), Subscription, Resource Group & Location. Click on "Create" button. After creating cosmos DB ID you can view as below screenshot- Below are the some important points which we should keep in mind- 1. We can create multiple Databases under one Cosmos DB.  2. One database can have multiple collections.  3. One collection can have multiple documents.  4. Each document have one field as "id" this is primary key for each document. This is also unique under one collection. We can't create multiple documents with same id under one collection. To create collection and database click ...