API Express (Custom REST API) to run SQL query on oracle db

[Ibrahim Ahmed Taymor]

I am trying to create a service with API Express (Custom REST API) to run SQL query on oracle db and send a parameter to it as select * from CRM.LEAD where USER_ID in (:userin)
And it’s not working, after investigation I found that the parameter is being sent as
"'57bb1c1be4b02bb1ffec6c1c','57ba2a38e4b02bb1ffec6b24','57ba2a18e4b02bb1ffec6b1e','57ba2a1fe4b02bb1ffec6b20','57ba2a2fe4b02bb1ffec6b22'"
And it’s not working with oracle
SQL query:
select * from CRM.LEAD where USER_ID in ('57bb1c1be4b02bb1ffec6c1c','57ba2a38e4b02bb1ffec6b24','57ba2a18e4b02bb1ffec6b1e','57ba2a1fe4b02bb1ffec6b20','57ba2a2fe4b02bb1ffec6b22')

[maxkatz]

What is the correct SQL query that you run outside of Appery.io/API Express, for example from a SQL client?