Support forum

Hi,

Would it be possible for the email connector to do a lookup in the Web Connector database, for the latest/last message that was sent to a particular number which has been received, then append this as a variable/field to the email message that is sent out on template?

I'm far from a coding expert, but logically I see it flow like the following...

For instance:

1. User sends a message to '+441234567890' saying "Hello, this is a test."

2. Message is received by user on their mobile. They send a reply: "Yes, I have received."

3. Message is received by Diafaan server. Diafaan does a query lookup into the WebConnector DB with a query such as:
-----------------
SELECT
Contacts.FirstName,
Contacts.LastName,
Contacts.Name,
MessageOut.MessageText,
Contacts.Number
FROM
MessageOut
INNER JOIN Contacts ON Contacts.Number = MessageOut.MessageTo
WHERE
Number = '+441234567890' AND
MessageOut.Id IN (SELECT
Max(MessageOut.Id)

FROM
MessageOut
GROUP BY
MessageOut.MessageTo)
-----------------
...this runs and uses incoming ReceivedFrom number to run the query WHERE number = 'xxxx' against. The MessageText is then passed along to a variable which can be used in the Email connector template, so the email can be formatted as:

Received from: [ContactName] [number]
Message:
[Message]

Last message sent to this number:
[LastMessage]

...It's conceivable that this could also be used to display the Contact Name as a variable too, which would be ideal.

Please can you let me know your thoughts on this if possible?

Thanks.