Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

SMS Reply with MySQL Query
sp_NewPost Add Reply sp_NewTopic Add Topic
December 29, 2014
11:21 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Avohay,

If you have multiple SQL Connectors in Diafaan SMS Server, routing an incoming message from one Gateway to a specific SQL Connector is only possible with an 'HTTP callback'. This means that you have to process the incoming message on an external HTTP server and set the 'connector_list' parameter of the HTTP response to the connector(s) you want the message routed to. However, if you already process the message on an external web server using PHP or ASP.NET, it is probably easier to to the database look up there, instead of using a trigger on a database.

A database trigger can probably be used to generate a response on an incoming SMS message but I do not have enough database experience to help you with this.

There is another way to generate a database look up for incoming messages but this also requires an external web server. The Web Connector can generate an HTTP call for each received message and send the response from the HTTP server back to the sender of the message. This option is called 'Reply HTTP response to sender', you can find it in the 'Receive SMS' options of the Web Connector.

Regards, Henk

December 29, 2014
12:22 am


I want to know how can I reply to SMS including the result of an query to a table on my MySQL DB based on Incoming number. I already know that this can be done in two ways: By Scripting Connector or By the Database itself on reading the MessageIn table.

So, can I do the reply SMS using Triggers (in case of MySQL)?

If yes, how can i route incoming SMSs to specific SQL Connector that contains the Database i want to query?

Thanks in Advance!


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502