Showing posts from 2017

Describing ORDS RESTful Services using a WADL

Recently I got this question (or better specification) from a customer:   "For exchanging  data ,  we either want a SOAP webservice or a REST service offering a WADL ".   WADL?   What's a WADL? I know WSDLs as descriptive endpoints for SOAP webservices, but WADL?! It occurs, that WADL's are intended to do just that, but in a more generic way.  WADL  stand for  Web Application Description Language .  The  World  Wide Web  Consortium (W3C) currently has no plans to implement  WADL  as a standard. Oracle's  ORDS is going the  swagger / openapi  route which is partially implemented in the 17.3 release .   With no existing functionality to provide a WADL for Oracle RESTful services, I had to come up with  my own solution, using the APEX  re pository  views to generate a WADL endpoint. I came up with a  small  procedure for this and add an additional URI Template to my service, called " wadl " with a single GET Resource Handler calling this

APEX SmartPivot Plug-in: Release 1.1

  The  APEX SmartPivot Plug-in is an Oracle Application Express Plug-in that enables users users to analyze data much like they are used to in Excel. It allows to present data in a customizable multilevel data grid. Developers can add the plug-in to any APEX application, just like adding an interactive report. Website: What’s new in Release 1.1 The new release of the APEX SmartPivot Plug-in focuses on integration with the latest APEX version: Users/UI Enhancements Font APEX The UI now supports Font APEX in APEX version 5.1 (Font Awesome in APEX 5.0). Your pivot report will look consistent with the rest of your application. Font APEX can also be used in conditional formatting rules. Conditional Formatting Users can define, apply, save and share conditional formatting rules with a report layout. Conditional formatting is not restricted to setting text and background colors, but offers to translate (ranges of) values i