Ability to use named cell ranges as query variables in Oracle Visual Builder add-in for Excel
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).
Tagged:
3