Access API from Stored Procedure in SQL Server


This document describes how to call any API with POST, GET, PUT and DELETE methods from stored procedure. For example, if we want to send email from SQL Server using stored procedure but don’t want to use inbuild functionality of SQL Server but to use any third party API.
To make it working (For the purpose of testing) first I created API you can get the API of GET and POST http://mongobox.azurewebsites.net/swagger
Now created a CLI Project in Visual Studio and created a method called SendMail which is accepting few parameters like WebURL, EmailTo,EmailBody,EmailSubject. See below image.




Now as I am utilizing the POST method API, so I need to pass various parameters in that API and I am passing it to API with given method: (Name, Age and other params are according to API we can use any params as per need of API)



Now, I need to build and publish this code in folder to get DLL file which will be used as assembly file in SQL server see below image (We need to add other dependent DLLs as well.)


Now created a Stored Procedure as


To call this stored procedure use below syntax:





Comments

Post a Comment

Popular posts from this blog

Tricky SQL Interview Questions

SQL Interview Questions How to insert 10 default records in SQL Table. For example suppose we have Student Table with columns Name, Address and other. Write a query to insert default value in one go. INSERT INTO mytable DEFAULT VALUES GO 10 What is GO keyword in SQL? GO keyword is not associated with SQL but it is property of SQL Server Management Studio. GO can be understand simply for following example. Student with Mark on their T-Shirt 1,2,3,4,5,6,7,8,9,10 and 11,12….20 are ready to run in an event but when it is said student from 1 to 10 Go then they start running but students from 11 to 20 wait until they are not said. So it is batch separator in SQL. What is Temp table and Temp variable in SQL and why they are used? 1.       Temp Table store location is Tempdb while Temp variable storage location if not specified is current database. 2.       Table variables can only be accessed within the batch an...
Read more

How to use AngularJs with MVC C#

Image
So this tutorial is related to JSON data Download the project file form here What we will do in this tutorial? 1. Will know what is JSON data? 2. How to get JSON data returned from a method in C#? 3. How to use them in AngularJs or in Javascript? First start with  what is JSON data? As per Json.org it is Javascript Object Notation which is very lightweight and easy to use for machine and us also. For more details visit : http://json.org/ How to get JSON data returned from a method in C#? So yo can see video here and get to know how it actually works. Steps are as:  Take a empty MVC project and name it what ever you want.  Create a new model StudentDetails (or what ever you want you are free to do so)  Take a controller and it will be good to take Default for learning purpose  Create A JsonResult (Represents a class that is used to send JSON-formatted content to the response.) Type method as mentioned in Video  Create instance o...
Read more

Infinite Scroll in Asp.Net C# using Javascript without Third party Plugin

Image
Infinite Scroll is very common today in website as we all see in facebook , google + , LinkedIn and many other sites, as we scroll down data from server automatically appears in our browser without clicking any button. How We will do it?  We first create a database and then after that we will apply a jquery that will execute when our scroll bar reaches bottom of the page. For demo I will fetch YouTube video link from local server and bind that in iframe when scrolled down..  Here I will define a variable or you can say in other word a counter that will increase according to our requirement when scroll down. and that value will pass to the server so that server can send data when scrolled down. Here in my example I am increasing counter by one and initial value is 14 since my table ID started from 14 (you know when you delete some data this happen when it is PK) How to pass data from a page to server using jquery ? Follow these Steps: 1. Create a ...
Read more