We've Moved! Please visit our new and improved forum over at our new portal: https://portal.plumvoice.com/hc/en-us/community/topics

Uploading data to Simple Database

Questions and answers about Plum Fuse development

Moderators: admin, support

Locked
wrothman@dealermagic.net
Posts: 69
Joined: Wed Feb 24, 2010 5:59 pm
Location: Chagrin Falls, OH
Contact:

Uploading data to Simple Database

Post by wrothman@dealermagic.net »

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
DMIVS

support
Posts: 3632
Joined: Mon Jun 02, 2003 3:47 pm
Location: Boston, MA
Contact:

Re: Uploading data to Simple Database

Post by support »

Dear Wayne,

What you describe is actually very similar to how we are building the outbound capabilities right now. Outbound campaigns will run on a Simple Database table much like you say, with selectable fields that will be prepopulated in the application and the ability to write back fields to the row. However, we're still working on putting it into beta; it should be coming soon.

We also plan to provide webservices at that point to upload and download data from Simple Database tables, and start campaigns on them. They will be accessible both via SOAP and HTTP POST. We will release details on them when they are ready.

Cheers,
SynApps Team

support
Posts: 3632
Joined: Mon Jun 02, 2003 3:47 pm
Location: Boston, MA
Contact:

Re: Uploading data to Simple Database

Post by support »

Hi Wayne,

We've made some APIs available to developers for the private beta. For now, they are all REST services (everything is done via HTTP). We may add SOAP access to the same services in the future.

Right now there are services for uploading and downloading data from tables, and queueing a campaign.

You can check out the documentation for these APIs at the SynApps documentation site, or click on the little purple API icons wherever you see them in the interface.

Best,
SynApps Team

Locked