Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
SummaryRun a select clause in ATP database with 'in' Operator using OIC ATP Adapter
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