Looking for some help to trouble-shoot a MS SQL DB connection I made between my bubble app and a SQL db. I got the sql db connection to work, but can’t get it to return the data I want into my bubble db.
There might be some things I’m missing or that I could check that I’m not aware of, so I’m looking for help on how to trouble-shoot this.
Here’s the current situation
I created a MS SQL database on AWS and created some sample records.
Here’s a screen shot of the DB fields and records from RazorSQL.
Within bubble, I figured out how to make the connection string work
Editor link to the plugins: https://bubble.io/page?version=test&type=page&name=startcall&id=callbossbriggs&tab=tabs-5
Here’s the configuration image.
You’ll notice from the parameters that I’m giving the sql db a phone number and it’s returning all of the records.
The connection worked. Here’s bubble asked me to define the data types of the returning values.
Here’s the issue.
I created a little test button to see if I could pass the sql db a phone number and it would return variables around address and existing customer status.
Here’s the live URL: http://briggsmechanical.getcallboss.com/startcall
U: [email protected]
Editor link to workflows: https://bubble.io/page?version=test&type=page&name=startcall&id=callbossbriggs&tab=tabs-2
Here’s the workflow configuration
I knew that number I was passing it “+12073701354” was in the mssql db already.
The problem is that two records I asked it to update “aws_existing” and “everyone_api_address” don’t get updated in my bubble db.
Any advice on what I should check here? Please keep in mind I’m super new to this.
Here’s a few thoughts on what could be wrong, these are just guesses.
- Wrong query is being sent to SQL database.
- Data types are messed up somehow between what bubble is sending. The data type of “phone” within both bubble and MS SQL is text. Not sure if this would create an issue.
- Perhaps I’m setting up the return program in bubble incorrectly.