SMS Clickatell API integration with SQL Server

The solution needed is a SQL Server 2008 table/trigger/proc that sends an SMS using the Clickatell API ([url removed, login to view]) each time data is inserted into the table. Data will contain phone number and the message. System needs to be robust and able to handle large volumes of data

Here is some code I found in internet which is pretty much is the start of what I want. Please use HTTP/S API not the COM Object. Also, I don't think cursors are a good idea for performance reasons.

[url removed, login to view]

Here is the Clickatell documentation for HTTP/S API:

[url removed, login to view]

I also require the following features:

1) Record any errors that are generated by the Clickatell gateway during a validation phase

before message is accepted by Clickatell. Refer to Appendix A: Error codes

2) Record the message statuses that are generated after the Clickatell gateway has accepted the message

for delivery. Refer to Appendix B: Message statuses

3) Use a Clickatell Callback URL using an HTTP GET so that Clickatell posts message status updates to our application via means of a Callback URL. Detailed information can be found in the “Callback URL” section under “Message parameters”. Please pass user id and password pamameters and use authentication in a C# callback function. Also require that the database be updated with the message status information received in the callback.

I think this is very clear, but contact me if you have any ideas or questions

Taidot: .NET, AJAX, C# -ohjelmointi, SQL, Langaton

Näytä lisää: clickatell api, clickatell sql, clickatell, sms api integration sql server 2008, sms gateway using sql server 2008, sql server clickatell, clickatell status, clickatell api start, clickatell sms sql server, clickatell sql server, sql code pdf, microsoft phone number, get wireless, t-sql with, callback url, system integration, sql server c# 2008, sql integration, social integration, social api, sms, sms api integration, ProC, net sql server, net c# sql server

Tietoa työnantajasta:
( 58 arvostelua ) Manchester, United States

Projektin tunnus: #504354

Myönnetty käyttäjälle:


Hi, I understand your requirements and propose the below develop the solution using dotNet, making use of SQL dependencies. Log the status of the call to the backend(sql2008). Callback url would be a webservice expos Lisää

$50 USD 10 päivässä
(1 arvostelu)

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, Thanks for the invite. Bid placed. Best Regards, Yousef

$750 USD 8 päivässä
(65 arvostelua)

As discussed.

$500 USD 7 päivässä
(26 arvostelua)

Hi Good day, MSSQL DBA Bid. MCTS in MSSQL 2005. Ready to start the work. Please check PM for more details. Regards [url removed, login to view] B.E

$200 USD 5 päivässä
(26 arvostelua)

hi, plz find similar example in pm. thank you

$500 USD 15 päivässä
(4 arvostelua)

Hi Thank you for asked me to Bid. I have gone through the documentation and mssql code. We shall do this in the way you have asked. But I think there are some different ways instead of using SP and Mssql, such as Lisää

$200 USD 7 päivässä
(3 arvostelua)

I can help you.

$150 USD 7 päivässä
(8 arvostelua)

hi plz check pm

$60 USD 0 päivässä
(8 arvostelua)

hi Check PM Please. Thanks

$80 USD 5 päivässä
(3 arvostelua)

please Check for PM! Cheers!

$100 USD 5 päivässä
(1 arvostelu)

I offer a very professional service and will ensure that you are getting exactly what you require and that you are completely [url removed, login to view] 10 years experience in the web industry and countless solutions under my bel Lisää

$250 USD 15 päivässä
(0 arvostelua)

Hi, I have read the description. I give the approximate time and bid. I will send you the resolution after I read the Clickatell_HTTP.PDF. thianks! Leslie

$220 USD 15 päivässä
(0 arvostelua)

Hi I can do this work, I have 4+ years of experience in this field and I did like this work. Thanks Deep

$550 USD 20 päivässä
(0 arvostelua)

Dear we are able to development on your applications with .net and php. we are working with web development(.Net,MSSql server,php) from last 3.5 years and able to working in all type web site project. we working w Lisää

$650 USD 15 päivässä
(0 arvostelua)

Hi, I'm using Clickatell API for personal system. I can do this for you. Best regards

$399 USD 3 päivässä
(0 arvostelua)

Hi. I have got my own component for SMS sending. It uses sockets and AT-commands to comunicate with cell phone.

$150 USD 0 päivässä
(0 arvostelua)

I can give u project with sending bulk sms with sql server

$300 USD 7 päivässä
(0 arvostelua)

Hi, I have worked in clickatell API, So I can do it quickly with quality

$250 USD 5 päivässä
(0 arvostelua)

Hi Iam MCAD,MCSD in .NET with over 5yrs of expericence.I have already designed such system for one of my client too.. For further details please go through the PM. Regards Vikas

$250 USD 7 päivässä
(0 arvostelua)

has previous experience in integrating clickatell api with our web application we have Experts in J2EE,AJAX,web applications

$500 USD 7 päivässä
(0 arvostelua)

We have worked with click a tell api. Please pm us to show you our demo. Or give a chance to complete the work in shortest time. Regards

$200 USD 5 päivässä
(0 arvostelua)