SQL Database Connector: parameterizing a list

[chaos.master]

Hello,

I have successfully connected the bubble app to my external SQL server. Also, I could parameterize a single variable, as is shown below, and call and send the parameter from within the workflow.

However, ideally, I would like to query the database for multiple ids instead of one id at a time. For example, I would like to do something like the below, which of course gives me an error. How can I parametrize and send a list of numbers instead of a single number at a time?

Thank you so much for your help!

[joeyg]

Here’s a thread that should help:

SQL query with List parameter

I am using the Bubble SQL API Plugin and have successfully done so for many queries. My current query has a list of numbers as one of the parameters. Select top 100 tbl1.AppointmentID, tbl1.ClientID, tbl2.AppType, tbl1.Date, tbl3.UserName as Bookedby, tbl4.UserName as Clinician, tbl5.LocName from Appointments tbl1 inner join AppTypes tbl2 on tbl1.Apptypeid = tbl2.AppTypeId inner join Users tbl3 on tbl1.CreatedByID=tbl3.UserId Inner join users tbl4 on tbl1.UserId=tbl4.UserID Inner join l…

For future SQL Database Connector questions, I’ve found searching the forum for “SQL” can return a lot of valuable information.

[chaos.master]

Thank you so much for pointing me to that thread. It solved half the problem. Now, I can send a list, and the call is successfully initialized too.

The remaining issue is how to get the results from DB. I was expecting to get an array with the same size as the input. But DB always returns back the result for the first id value, but nothing for the rest. Any idea how to proceed from here?

For example, I am getting result for 11, but nothing for 434 or 324.

Any idea would be appreciated.

[joeyg]

Use your API call as the data source of a repeating group. All 3 rows should return.