Support forum

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