SMS API integration with SQL Server 2008

The solution has 2 components. (this information is also available in the PDF attached. It is much more readable)

First is a SQL Server 2008 stored procedure that sends an SMS using the HTTP API (documentation attached) when there are unsent messages in the “messagesout” table. A trigger is ok for this if necessary, but preference is to run stored proc as a SQL Agent Job, scheduled every minute or two to check the table for new messages to send. System needs to be robust and able to handle large volumes of data. For performance reasons, please do not use any cursors.

Second, a script/web application is needed to receive SMS messages sent over HTTP from the SMS provider and insert messages to database. Details below.


1. Record all responses that are generated by the SMS gateway/provider during the send/validation process (success response, or errors received). Update “messagesout” table with status for each message or batch sent. (see “Database Tables” information below) Set ‘Status’ column value = 200 if successful; If error received, record error number in ‘Status’ column. If success response received, will receive a string message from gateway containing JobID:[MobileNumber]:[SMSID]. I would like to record the JobID in the “messagesout” table in the ‘smsjobid’ column; also, record the SMSID in the ‘smsid’ column.

2. Stored proc needs to be able to handle the following:

- Sending a message to a single recipient. Refer to Section “A. Send SMS Message using Gateway”;

- Sending of a message to multiple recipients in one HTTP POST call. Refer to API documentation for “Batch API: Bulk SMS API.”;

- Optional DeliveryDateTime variable (see documentation). This is used if specifying a future date/time for gateway to send message(s). Every message sent from my MS SQL server will not require the use of this variable, but when it is needed, it has to be included in the HTTP call variables.

3. Script/web application to receive incoming text messages sent by SMS provider to my web server (ASP.NET 2.0/Windows 2003/IIS6). HTTP GET is used. Please use C#. Data received should be parsed into columns and inserted into the MS SQL Server table named “messagesin” (see “Database Tables” information below). Refer to API documentation, Section “B. Receive SMS/Text Messages from Gateway.”


1. SQL Server 2008 stored procedure that sends SMS using HTTP POST. Refer to API documentation, Section “A. Send SMS Message using Gateway.”

2. Script/web application to run on ASP.NET 2.0 web server (Windows 2003/IIS6) to receive and store to database the incoming messages sent by SMS provider.

3. Any documentation about the design, requirements, usage, and/or installation of code delivered.

4. All source code. If any compiled code is delivered, please provide source code as well.


Table name: MessagesOut

Messages being sent from SQL server out to SMS Provider.

- msgid: (identity column) - distinguishes outgoing messages from each other

- receiver: phone number(s) of the recipient(s) of the message

- msg: text of the message

- batchname: name of batch, if this is a batch send. (null allowed)

- deliverydatetime: for scheduled date time of outgoing messages if delayed delivery is desired. If messages sent immediately, this is not used. (null allowed)

- status: stores the response from SMS provider/gateway. 200 = success; When error response received, record error number here.

- smsjobid: stores the jobid received from success response from gateway

- smsid: stores the smsid received from success response from gateway

- sentdatetime: datetime when message was sent

Table name: MessagesIn

Messages received from SMS provider, which originated from a mobile user sending a text to a shortcode.

- msgid: (identity column) - distinguishes messages from each other.

- mobilenumber: phone number of the sender of the message.

- operatorid: denotes which service provider connection was used to receive message.

- msg: text of the message.

- smsinboxid: SMS provider’s reference number for all incoming messages.

- received: datetime message was received.

- shortcode: short code the message was sent to.

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

Beceriler: Grafik Tasarımı, HTML, Logo Tasarımı, PDS den HTML ye, Web Sitesi Tasarımı

Daha fazlasını gör: sms sql server 2008, using sms api send sms sql server 2008, send sms sql server 2008, sms integration sql server, sql server 2008 sms, sms api integration sql server 2008, sending sms sql server 2008, sms send sql server 2008, send sms using sql server 2008 trigger, sql server 2008 sms message, sms integration sql, send sms gateway using sql server 2008, using sms http api sql server 2008, call http sms api sql server, sms sql server using http api, sending sms messages sql server job agent, send sms sql server 2008 using, call api sql server 2008, sending sms sql server api, sms sql integration, sql sms message, sql server run sms api, sms api sql server, call sms api sql server, send sms using sql server 2008

İşveren Hakkında:
( 0 değerlendirme ) Lahore, Pakistan

Proje NO: #709279

Bu iş için 5 freelancer ortalamada $166 teklif veriyor


Please check PMB for our portfolio. Thanks

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Dear Sir I have been eagerly waiting to land my first job. This time i have got a chance to start my outsourcing career with you. If you let me do this job then i will be able to make you satisfied. Since,this is my f Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Dear Sir/Ms, 8 years’ experience can assure you that we provide the professional service to meet your needs. I will send you some of our cases in the PM. Thank you for reading Terry

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hi, i am interested in the job and have an experience in developing tools working with SMS

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello, I have read your requirements, understand what you need and can provide my services for this job. I have flare of programming using new techniques, so please give me a chance to prove my worth. I am very Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)