Hello,
I need an api interface to populate a table from incoming messages on Trumpa. In return, the API should poll another table every 5 seconds to send through API Trumpia.
Please see [login to view URL] for API information. [login to view URL]
I need this written in either python or php connecting to a mysql db.
Thanks - please contact me for questions.
For Inbound from Trumpia:
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 = 69302
msgsubject = msgdata = inbound message
For Outbound to Trumpia:
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 Trumpia 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