Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
7
Views
0
Comments
edited Jul 26, 2019 3:43PM in Integration

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!