I’m really excited about the way Parabola.io can be used to accomplish a much-needed workaround for Bubble.io users who want to remotely connect to a MySQL database that only allows access to a whitelist of IP addresses:
My goal
Since Bubble.io applications are hosted on a dynamic IP address, the company is not able to provide a reliable IP address for users to whitelist in the MySQL database host security settings (as many hosts require).
But since Parabola.io does have a reliable set of IP addresses, I can whitelist them in MySQL and then use Parabola.io to remotely connect to my MySQL database, import, and then export it to my Bubble.io application.
My issue
But I’m encountering one big problem…I can’t figure out how to update existing data records in Bubble using Parabola. I have only successfully posted new records (using POST). When I try uploading the same thing twice and want it to simply update the existing record, it uploads duplicate records instead (even though I have set my ‘Primary Key’ column in Bubble).
When I try any other method offered in Parabola.io (PUT, PATCH, or DELETE), I get the following error in Parabola:
{
“body”: {
“message”: “Unrecognized method. Currently supported: get,post”,
“status”: “ERROR”
},
“statusCode”: 405
}
Since the Bubble/Parabola documentation seems to indicate it is possible to update existing records, can you please help me understand how I might accomplish that?
Thank you!