Uploading data to Simple Database
Posted: Thu Mar 11, 2010 11:32 am
We've got a table in our "Simple Database" on our hosted application server ("theTable")--this has fields for all the values used in our calls.
Some of these fields in theTable will be inputs into the call--e.g., we will be asking for verification of material in some of the fields. Other fields will be outputs of the call: If the call recipient says "yes" to some prompt, we put one thing in the relevant output field and another if she/he says "no."
As I understand it, we can automate the call system so, among other things, it will make a call whenever it sees a new row in theTable. What we are not clear about is how we can upload our input data to the table, creating the new row. We'd like to do that from our server at Caspio, that collects the data via a table embedded in one of our webpages. If we can't figure a way to do it directly from Caspio, we will use their webservice to extract it to our server and then send it to theTable at PlumVoice.
So to start we need some general information on how we would upload and download new rows to and from theTable. Would that be an HTTP POST? Could you give a sample of what the PHP code to do that might look like? (I think this would be a different process than using queuecall.php, which (a) seems to actually initiate a call and (b) has a limit of 255 characters in the "call_parameters" Parameter.)
Thanks
Some of these fields in theTable will be inputs into the call--e.g., we will be asking for verification of material in some of the fields. Other fields will be outputs of the call: If the call recipient says "yes" to some prompt, we put one thing in the relevant output field and another if she/he says "no."
As I understand it, we can automate the call system so, among other things, it will make a call whenever it sees a new row in theTable. What we are not clear about is how we can upload our input data to the table, creating the new row. We'd like to do that from our server at Caspio, that collects the data via a table embedded in one of our webpages. If we can't figure a way to do it directly from Caspio, we will use their webservice to extract it to our server and then send it to theTable at PlumVoice.
So to start we need some general information on how we would upload and download new rows to and from theTable. Would that be an HTTP POST? Could you give a sample of what the PHP code to do that might look like? (I think this would be a different process than using queuecall.php, which (a) seems to actually initiate a call and (b) has a limit of 255 characters in the "call_parameters" Parameter.)
Thanks