Jump to

• Request
• Response

Export APEX application components

post

/apex/applications/{application_id}

Export a subset of the specified APEX application.

Request

Path Parameters

• application_id(required): string
  Application Primary Key, Unique over all workspaces.

Query Parameters

• export_format: string
  Indicates the file format to return the entire application components. Valid values SQL_SCRIPT | SQL_ZIP

  Allowed Values: [ "SQL_SCRIPT", "SQL_ZIP" ]
• export_type: string
  Parameter for APEX Export function. Comma-delimited list of export types to perform APPLICATION_SOURCE,EMBEDDED_CODE, CHECKSUM-SH1

  Examples

  Select an example Export application source

• p_with_pkg_app_mapping: boolean
  If true, export installed packaged applications with references to the packaged application definition. If false, export them as normal applications.
• with_acl_assignments: boolean
  Parameter for APEX Export function. If true, export ACL user role assignments. Only valid if export_format query parameter is also specified.
• with_comments: boolean
  Parameter for APEX Export function. If true, include developer comments. Only valid if export_format query parameter is also specified.
• with_date: boolean
  Parameter for APEX Export function. If true include export date and time in the result. Only valid if export_format query parameter is also specified.
• with_ir_notifications: boolean
  Parameter for APEX Export function. If true, include report notifications. Only valid if export_format query parameter is also specified.
• with_ir_private_reports: boolean
  Parameter for APEX Export function. If true, include private reports that a user saved. Only valid if export_format query parameter is also specified.
• with_ir_public_reports: boolean
  Parameter for APEX Export function. If true, include public reports that a user saved. Only valid if export_format query parameter is also specified.
• with_no_subscriptions: boolean
  Parameter for APEX Export function. If true, components contain subscription references. Only valid if export_format query parameter is also specified.
• with_original_ids: boolean
  Parameter for APEX Export function. If true, export with the IDs as they were when the application was imported. Only valid if export_format query parameter is also specified.
• with_supporting_objects: string
  Parameter for APEX Export function. If 'Y', export supporting objects. If 'I',automatically install on import. If 'N', do not export supporting objects. If null, the application's include in export deployment value is used. Only valid if export_format query parameter is also specified.

  Allowed Values: [ "Y", "I", "N" ]
• with_translations: boolean
  Parameter for APEX Export function. If true, include application translation mappings and all text from the translation repository. Only valid if export_format query parameter is also specified.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Type: object

This object represents a component export request.

Show Source

• components(required): array components
  Minimum Number of Items: 1

  Parameter for APEX Export function. The list of components in the specified APEX Application to export.

{
    "type":"object",
    "description":"This object represents a component export request.",
    "required":[
        "components",
        "export_format"
    ],
    "properties":{
        "components":{
            "description":"Parameter for APEX Export function. The list of components in the specified APEX Application to export.",
            "type":"array",
            "items":{
                "description":"Alias of the component. Format is TYPE:IDENTIFIER.",
                "type":"string"
            },
            "minItems":"1"
        }
    }
}

Nested Schema : components

Type: array

Minimum Number of Items: 1

Parameter for APEX Export function. The list of components in the specified APEX Application to export.

Show Source

• Array of: string
  Alias of the component. Format is TYPE:IDENTIFIER.

{
    "description":"Parameter for APEX Export function. The list of components in the specified APEX Application to export.",
    "type":"array",
    "items":{
        "description":"Alias of the component. Format is TYPE:IDENTIFIER.",
        "type":"string"
    },
    "minItems":"1"
}

Examples

Select an example Listing two specific APEX Applications components to export. The query parameter export_format MUST be specified.

Back to Top

Response

Supported Media Types

• application/sql
• application/zip

200 Response

The current state of the specified Oracle APEX application components.

Body ()

Root Schema : schema

Type: string(binary)

400 Response

Bad Request - The export request body is invalid.

Back to Top