MS SQL Server routine to call application API methods

We need to call API interface to an application from SQL Server. Our application processed data and stores it in a SQL database. Everything is working as expected, and we are able to execute SQL commands from within our application. We are not able to execute external API/Web services however. We would like to leverage SQL Server to provide this capability, as SQL server can make API/Web Service calls, and we can trigger SQL Server commands, so there is a logical path from our application to the application serviced by the API through SQL Server.

This is where we need assistance, developing the SQL Server interface between our application and the other application.

The application API is in C or Java, but C interface is slated to be discontinued at some point, so leaning towards Java. Full documentation on API is available, along with sample apps (not in SQL Server though).

Functions required:

-> Call API that sends data from SQL Server to application. This will be either a create record or an update record. This will be known in advance. I envision calling the SQL Server process, passing the following:

a. Instruction: Call Insert API, Call Update API

b. Primary Key:

c. Data

Functions preferred:

-> Call API that retrieves data from application in a lookup fashion (i.e.; get details from people form where id = "jones"), and returns to SQL Server. I am not sure what options are available to me, so this can be done in different ways, such as: 1. Return values in an object that the SQL server routine can return to the calling function 2. Place results in a results table that the calling routine can reference 3. Other ways to do this???? I'm open to all suggestions on the best way to do this.

--> Call API that retrieves data from application as a list (i.e.; get list of people where status = "active"). Return methodology is open to discussion, as I may not be aware of the best ways to do this in SQL Server.

Please respond with any questions if more details are needed.



Skills: .NET, Java, SQL

See more: sql call api, api calls sql, api call sql server, call api sql server, sql server web, ms lookup, java api table, e leaning, what is ms sql, sql server or, java api reference, sql java, sql commands, record call, net sql server, net c# sql server, java sql, call record, call id, java create call function, web api sql server, sql different, update sql form application, sql assistance, call function

About the Employer:
( 11 reviews ) Lorton, United States

Project ID: #5033579

10 freelancers are bidding on average $234 for this job


I have 6 yeas experience in JAVA, WebServices and good at SQL. I am very much interested in your project.

$166 USD in 4 days
(37 Reviews)

I have programmed in SQL Server for over 10 years now, and know how to manipulate SSAS so that external calls to API, in my case AD, to return functions that allow direct querying of the resultant set. This would be a More

$222 USD in 3 days
(16 Reviews)

Hi. What version of MS SQL Server do you have? If it is mssql 2005 or above then using SQLCLR is most suitable for your task. I will create stored procedures realized in .net assembly. Regards, Yuri.

$222 USD in 5 days
(20 Reviews)

You are correct that you can make API calls, web services calls, etc. from SQL Server. In my experience that is typically not the best path. I try to use each tool to its strength, and SQL Server's strength is in s More

$250 USD in 5 days
(2 Reviews)

Hey, I'm free tonight to help if you'd like. I'm American, live in NY, can talk on the phone at any time, and have been developing MSSQL and .NET applications for over 20 years (VB and Access before .NET and MSSQL). More

$172 USD in 3 days
(1 Review)

Hi I am working on SQL Server from 17 years and can create you application based on your requirements .

$277 USD in 15 days
(2 Reviews)

Hi. I have experience on using [url removed, login to view] to call external UI API via MS Messaging Queue. I propose you to use this technic to call your API. I will develop wrappers for your More

$526 USD in 21 days
(2 Reviews)

Hello My name is Matthew Andrews have a look at my resume, please consider my bid. [url removed, login to view]

$147 USD in 3 days
(1 Review)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. As you can see in my profile,I'm serious bidder here and i have already worked on a similar project before and can deliver as u More

$210 USD in 12 days
(0 Reviews)

I have 12 years experience working with SQL Server, T-SQL programming and business applications with DotNet Framework. Ja purposes previously proyectos similar programs in C or API call routines developed in other prog More

$222 USD in 5 days
(0 Reviews)

I can help you sir.I am a professional developer of SQL Server R2. I can develop the application what exactly you want. I have done this kind of projects before. In one of my application we need to call sms sending More

$133 USD in 10 days
(0 Reviews)