Pass array to where clause in sql select statement

App Building
1

I have an array {{array}} [0,1,2] that I need to pass the the where clause of a sql statement.

Select *
From TableCustomers
Where TableCustomersId in ({{array}})

what would be the best way to accomplish this?

2

Use a resource as Query JSON with SQL

3

don't understand your answer.

my current issue is if the array contains more than 1 value it is displayed as = '6, 1'

Conversion failed when converting the nvarchar value '6,1' to data type int.

4

Screen Shot 2022-09-20 at 9.03.07 AM
Screen Shot 2022-09-20 at 9.03.07 AM860×118 9.62 KB

then add your query in there...
select * from TableCustomers where TableCustomersId IN ({{array}})
or
select * from TableCustomers where TableCustomersId = ANY({{array}})