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 300 $ 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)