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

OIC Call to BIP report with multiple values in parameter

Received Response


OIC Call to BIP report with multiple values in parameter

Content (please ensure you mask any confidential information):

On the OIC SOAP Adapter for ExternalReportWSSService (to call BIP report), in the parameterNameValues, how can I pass more than 1 value in the same parameter with one Report call from OIC? I want to pass a parameter to BIP report that is used in the IN operator on a WHERE clause in BIP report

       (i.e. SELECT *
             FROM ABC 
             WHERE invoiceID IN (ATTRIBUTE1) --Where ATTRIBUTE 1 contains multiple comma-separated values, passed by OIC integration call

The Target node 'item' is a repeating element, so it seems that it would be able to handle multiple values passed to it, but I only want the BIP report to be triggered once from OIC integration.

Howdy, Stranger!

Log In

To view full details, sign in.


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