query_fusion
Run read-only SELECT queries against Oracle Fusion and receive results as XML. Use filters and column aliases to control output size and formatting.
Instructions
Run a read-only SELECT against Oracle Fusion and return the rows as XML.
Args: sql: A single SELECT statement. No trailing semicolon. Add WHERE/ROWNUM to keep the result small — BIP serializes the whole set. columns: Output column aliases in SELECT order, upper-case identifiers. Alias every column in the SQL to a simple upper-case name. fusion_user: Fusion user to run as (default bip_user).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| columns | Yes | ||
| fusion_user | No | bip_user |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |