SQL DB Connector - MSSQL Stored Procedures (EXEC) and SQL Functions

JamesC · 2025-02-05T07:34:47.645Z

Hi everyone.

I am trying to use the SQL Database Connector to make a call primarily via a Stored Procedure (Create a stored procedure - SQL Server | Microsoft Learn) which results in a SQL input in the following format using the EXEC command:

EXEC bubble_api.HousePoints ‘school_123’, ‘2024-01-01 00:00:00’, ‘2025-02-02 00:00:00’, ‘’, ‘’, ‘’, ‘Hello’;

The above successfully runs and returns data. When trying to paramaterise this to be able to feed in data from my application, I am using the $ signs as per the documentation. See below.

BubbleSQLScreenshot1910×1282 201 KB

I am getting the following error, which indicates to me that Bubble is parsing the text $1 instead of replacing it with the parameter, as this query works perfectly without parameters.

BubbleErrorMessage1066×492 21.2 KB

Does anyone have a suggested fix for this?

JamesC · 2025-02-19T22:31:06.204Z

For anyone who is experiencing the same issue in the future, Bubble have confirmed that the only supported operations using the SQL DB Connector are SELECT, UPDATE and DELETE

system · 2025-04-16T07:34:56.175Z

This topic was automatically closed after 70 days. New replies are no longer allowed.