Calling DocumentDB (CosmosDB) Stored Procedure from Azure Logic App

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-


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 template to create logic app. Click on "When an HTTP request received" option.


This will open Logic App in designer mode with one Request action as below-


Click on "New Step" and "Add an action" option.


This will add option to add new action in logic app.


Search for "document" it will give you following options-


Click on "Azure DocumentDB - Execute stored procedure" option. If you are using DocumentDB in Logic App for first time, it will as you to save DocumentDB connection with name.


Provide connection name & select DocumentDB Account from list. Click on "Create" button. Now it will ask you to provide details of Stored Procedure.


Select Database ID, Collection ID, Stored Procedure ID and provide input parameters.


Add new "Response" action to give output of Stored Procedure to Logic App client.


Select Stored Procedure response Body in Response action Body field. Below will be the final Logic App.


Save Logic App. Click on Run option. Verify that we have received result of DocumentDB Stored Procedure in Logic App.


Body of Response action contains JSON received from DocumentDB Stored Procedure.

I hope you have understood using DocumentDB Stored Procedure in Logic App. If you have any query or question write to me at dharam.pal95@gmail.com.

Comments

Post a Comment

Popular posts from this blog

Serverless Integration design pattern on Azure to handle millions of transactions per second

Image
Recently i was working on one of the integration project where client have following requirements- It should support millions of transactions per second Based on demand/number of requests it should auto-scale. Client don't want to procure huge hardware up-front. It should support multiple applications integration & open for future integrations without any or minimum changes. If any application is down for some time, framework should have in-build retry logic after some configured schedule. We have analyzed below options for this integration framework- 1. Biztalk Server 2. Azure Function, Logic App & Event Hub 3. Third party integration server Every option has its own pros & cons. Based on client requirement analysis with each option we found option 2, Azure Function and Event Hub approach most suitable for this type of integration. Below are the main features which played a key role to select this framework for integration- Azure Function- A...
Read more

Cloud-Neutral Development is the future of IT

Image
Cloud becomes first choice for deployment of applications for most of the companies. Major benefits of cloud is cost, speed, scale & reliability. With the increase in the number of cloud providers, today companies have many choices to pick their deployment cloud provider. Now major question for any organization is which cloud provider they should choose? Generally all cloud provider gives browser-based dashboard that makes it easier for IT professionals and developers to order resources and manage their accounts. Some cloud computing services are also designed to work with REST APIs and a command-line interface (CLI), giving developers multiple options. If you have specific need in your application and some provider provides PaaS service which fulfill maximum of your requirement than you can go for cloud-native development model. In this model you will stick with particular cloud provider. You will not able to move to other cloud provider in future without any or major changes...
Read more

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 ...
Read more