+ rest_source_id – If the request was done for a REST Data Source, the internal ID of the REST Data Source + rest_source_sync_id – If the request was done as part of a REST Source synchronization, the internal ID of the synchronization O component_type/id/name – now support REST sync and Automations New: APEX_APPL_WEB_SRC_SYNC_STEPS – Synchronization Steps for REST Data Sources + sync_* – Several identifiers detailing sync attributes + sync_is_active – Whether the synchronization of the REST Source is active or not + web_source_type_code – Return the internal name of the native type or plugin O web_source_type – Prepare for REST source modules and deliver the right description New: APEX_WORKSPACE_PRINT_SERVERS – Print servers configured within a workspace + is_filterable – Identifies (for Plug-In developers) whether the this is a filterable column + valid_for_url – Linefeed-separated list of URLs which this credential can be used for O credential_type – added support for HTTP Header and HTTP Query String + stack_font_* – Defines font family/style/… of the stack label + wsm_*_function – Function which is called when an APEX component uses the REST Data Source functions O plugin_type – now supports “WEB SOURCE TYPE” as “REST Data Source Type” + lov_language – Identifies the programming language of INLINE_LIST_OF_VALUES + use_local_sync_table – Whether to use the local synchronization table instead of the REST service + function_body_language – Identifies the programming language of REGION_SOURCE + initial_chart – Identifies whether the chart displaying facet values is initially shown + show_chart – Identifies whether the facet values can be shown as a chart + facet_group/_id – Identifies the group this facet belongs to + lov_language – Identifies the programming language of LOV_DEFINITION + item_source_language – Identifies the programming language of ITEM_SOURCE + item_default_language – Identifies the programming language of ITEM_DEFAULT New: APEX_APPL_PAGE_ITEM_GROUPS – Identifies facet groups on a page + print_credential_* – Remote print server credentials + print_server_remote* – Identify remote print server
ORACLE APEX API CODE
+ print_server_type/ code – Application Level Report Printing settings type + accept_old_checksums – whether apex 20.1 generated checksums are still valid Web Source Modules are now named REST data source.īLM hit APEX, it is now Allowlist and Blocklist, instead of … you know Views This also means “PLSQL returning…” is renamed to “Function returning…”. MLE now supported, means we have new attributes telling which coding language is used for code blocks. Just remember, this posting deals with Views and PL/SQL APIs, only ! My personal favorite is a small enhancement to APEX_WEB_SERVICE to handle multipart REST calls.Īlso the new APEX_AUTOMATION will be super helpful, just like many new views like: APEX_WORKSPACE_PRINT_SERVERS, APEX_REST_SOURCE_SYNC_LOG, APEX_AUTOMATION_LOG, just to name a few.
ORACLE APEX API DOWNLOAD
You can find the download on this shortcut link: /download/Īs you know, from previous posts like, my first task is to see what has changed under the hood, like the metadata repository aka Views and on the API Layer.Īnd I can tell you, many new and good things are in this release !īiggest new thing, without any doubt, is the new APEX_DATA_EXPORT API, which let’s you export any data source (table/view, query, REST) to one of those formats: CSV, HTML, PDF, XLSX, XML, PXML, JSON, PJSON. Oracle APEX Release 20.2.0.00.20 was released on October 21, 2020.