I need an api interface to populate a table from incoming messages on EZTexting. In return, the API should poll another table every 5 seconds to send through API EZtexting.
Please see [url removed, login to view] for API information. [url removed, login to view]
I need this written in either python or php connecting to a mysql db.
Thanks - please contact me for questions.
For Inbound from EZTexting:
Table to populate "unparsed" with field schema as follows: sender,receiver,msgsubject,msgdata, senttime,receivedtime
sender should be the person who sent the inbound message
receiver should = 393939
msgsubject = msgdata = inbound message
For Outbound to EZTexting:
Table to poll "outbox" with field schema as follows: id,sender,receiver,msg,senttime,receivedtime,reference,status,msgtype,operator,errormsg
The api should look at the STATUS = SEND and SENDER = 393939
if that is true, then execute api and send the msg to the receiver through the EZTexting program.
Upon sending, update STATUS to SENDING
Once that is complete and a response is given, the API should update STATUS = SENT
If failed, UPDATE status = NOTSENT