Sync with MySQL DB

[JamesMobiloo]

I love Caspio!

 

I have a MySQL DB whose data is managed by a custom user interface.  I want to access the data (read only) to pull out records for a variety of purposes.  Can anyone advise me how to go about doing this?  Is there some feature that can pull specified tables or new/updated records through into Caspio.

 

Any suggestions welcome so long as they’re polite ones!

 

James

[MayMusic]

Can you elaborate more with an example?

[JamesMobiloo]

Ok, let me simplify the request now that some time has passed and I am clearer about what I need!

 

In MySQL I have a table called Bookings

 

I want to set up a replica of that table in Caspio and have the tables kept synchronised via some API.  

 

Is it possible to have two-way sync?  That is, if I add a record to the MySQL table it will sync to the Caspio one and vice verse.