Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter

Summary

Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter

Content

Hi,

RestAPI structure : 

{

'accountNum' : '123456'

'product' : ['abc','def','ghi']

}

I can receive multiple product name in rest api, i need to concatenate the array like this ('abc','def';'ghi') and which i was able to do using XSL concat & create-delimited-string function. i can see the same when i log the same function in logger. But when i pass that variable the ATP adapter to run a query like this.

Select accountid, accountName, productid, price from producttable where productname in #productname

it should work similar to below query which i run in ATP db directly