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

Ability to use named cell ranges as query variables in Oracle Visual Builder add-in for Excel

Accepted answer
9
Views
4
Comments
edited Nov 25, 2019 10:26AM in Visual Builder 4 comments

Content

Product idea (not sure if this is best placed here or on the OIC Ideas Lab).

Where we have a web service endpoint with multiple nested collections (e.g. invoice batch -> invoice header -> invoice lines -> invoice line details) we need to split each service call/OVB layout to different worksheets in Excel. We can create a query to retrieve an invoice batch on the first sheet, but then want to be able to pass the invoice batch ID as a query parameter in the second sheet to return all invoices in the batch (and so on).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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