פיתוח webhooks

We have a web application that send messages - emails and sms by using sparkpost.com and plivo.com

Transmitting API is working, but we need to get the final result trough webhooks.

https://www.plivo.com/docs/getting-started/sms-delivery-reports/
https://www.sparkpost.com/docs/tech-resources/webhook-event-reference/

Server is Microsoft Windows 2012.
Code can be written in PHP/CS or anything else, as long as we can change connection parameters later on (s.a account details/ user/ password/ key / website...)

We prefer you will build a controller activate a store procedure.


something like this:

public class WebhookController : ApiController
{


public class mdSparkPostWHEvent
{

public string Request { get; set; }

}
[HttpPost]
public HttpResponseMessage SparkPostWHEvent([FromBody] mdSparkPostWHEvent Inputs)
{
return new HttpResponseMessage()
{ Content = new StringContent(SQLFunctions.SQLStoreProcedure("sWH01_SparkPost", Inputs, true) ,System.Text.Encoding.UTF8, "application/json") };
}
}

}

* JSON payload can be send complete to one string param (VARCHAR in sql)
* SQLFunctions.SQLStoreProcedure not need to be developed. we have RESTful working code.