30.11 EXPORT_SAVED_REPORTS Function

This function exports multiple saved reports from the current app and workspace. Exports default or user-saved reports.

If calling outside of Oracle APEX, use apex_util.set_workspace to set the current workspace.

Syntax

APEX_IR.EXPORT_SAVED_REPORTS (
    p_report_ids           IN wwv_flow_t_number,
    p_credential_static_id IN VARCHAR2 )
    RETURN CLOB;

Parameters

Parameter Description
p_report_ids The array of report IDs to export.
p_credential_static_id

The Key Pair authentication credential static ID. This credential is used to create a signature for the export.

Create compatible public and private keys using OpenSSH, and use those to create a Key Pair workspace web credential.

Returns

The signed and base64-encoded report export JSON object in CLOB.

Example

The following example exports report IDs ( 111111, 222222 ) from the current workspace using my_API_key_pair credential.

DECLARE
    l_export_clob clob;
BEGIN
    l_export_clob := apex_ir.export_saved_reports (
                         p_report_ids           => apex_t_number(
                                                       111111, 222222 ),
                         p_credential_static_id => 'my_API_key_pair' );
END;