Release Notes


CA Live API Creator Release Notes 3.0

posted Jul 22, 2016, 4:32 AM by Val Huber   [ updated Oct 3, 2016, 1:42 PM by LauraC ]

CA Live API Creator Release Notes 3.0 summarizes new features, known issues, and other important information specific to this Live API Creator release.

What's New

This section outlines the marquee new features in Live API Creator:
  • Managed API

You can now create schema objects (tables, columns, relationships) in the databases you specify using Data Explorer. You can create new databases (schemas) from the Home page using the Create API wizard.

For more information:

  • Salesforce data source definition

You can now connect to Salesforce data sources. You can use a Salesforce JDBC driver to create, read, update, and delete Salesforce data.

For more information about Salesforce data sources, including how to connect to Salesforce instances, see Salesforce Data Source.

  • Code completion

When editing JavaScript code, you can now get suggestions for system objects, functions, SysUtility, SysLogic, and variables by pressing Control + Space on your keyboard.

For more information about code completion, see Code Completion.

  • XML as input format

You can now send (PUT/POST) data to API Creator using XML format.

For more information about the request formats, see Request Formats.

  • Debugger

You can now debug your rules, including events and JavaScript libraries, using the JavaScript debugger.

Note: The debug services are only available on the single-user version demonstration package that is based on Jetty.

For more information about the JavaScript debugger, see Debugger.

  • Improved development experience
You can now write your code more efficiently using the following new features:
    • Inline editing of libraries files
You can now edit your JavaScript libraries directly in API Creator instead of having to switch between two editors. You can develop your APIs and edit JavaScript in the same development tool.
    • Just-in-time derivation rules

When you add new derivation rules (formula, sum, count, and min/max), you can now specify that Live API Creator recompute the data values. If the value in the database is null, Live API Creator executes the rule on the first access (read or update), and stores the value for that column in the database. This is useful, for instance, to recompute values without incurring the cost up front.

For more information about Just in Time, see Synchronize Data with Logic.

    • Transform to resource

You can now use custom resources as transformation definitions (for example, in event handlers).

For more information about the logicContext object's transformCurrentRow method, see The logicContext Object.

    • System objects are returned as JavaScript objects

Live API Creator now executes your JavaScript code using the Oracle Nashorn JavaScript engine. In addition to improved performance, Nashorn properly handles Java strings in JavaScript. You can now instantiate objects in JavaScript using a syntax Nashorn understands.

For more information about the Nashorn JavaScript engine, including details about the syntax, see JavaScript.

    • Metadata access APIs

The LogicContext object now provides APIs to return information about tables and custom resources.

For more information about this object, see The logicContext Object.

    • Leverage JAR files as libraries in your API project

You can now make your Java Archive (JAR) files available to your API projects as libraries.

For more information about loading JAR files, see Install on Apache Tomcat.

    • Documentation reorganization

The documentation has been reorganized and now provides better navigation. Key pages have been clarified, including Row Objects, Customize your API, Custom Endpoints, Event HandlersComplex Transaction Processing, and Automatic Key Generation.

  • PostgreSQL admin database

You can now use PostgreSQL as an admin database.

For more information about using PostgreSQL as an admin database, see Use PostgreSQL as your Admin Database.

  • End User License Agreement (EULA)
You must now accept the terms of the EULA before you can use Live API Creator.

Known Issues

  • Salesforce does not support non-persistent attributes which use count, sum, min, max.

For more information about non-persistent attributes, see Non-persistent Attributes.

  • DE200323: XML - MySQL STRESS_FLOAT error during POSTDuring a POST to MySQL, float values passed into a text datatype are facing parsing issues (alphanumeric is OK).
  • EGL-666: You cannot install Live API Creator using Tomcat 8.0.32 as a Java container. A bug in org.apache.catalina.loader.WebappClassLoaderBase.filter prevents the proper operation of the DBaseTypes resource. If the Tomcat classloader is asked about a class named "org" (as will happen if the JavaScript engine requests a class), an exception is thrown.

For more information about this known Tomcat issue, see the Apache Software Foundation site.

  • EGL-891: In Data Explorer, dates are now edited as text.

  • DE227641: If you are on JDK 1.8.0_91 or older, you must use req.verb.toString() == 'POST' in expressions in request events. The same approach must be taken when comparing any other Java enum type with a string.

Fixed Issues

  • EGL-730: Slow pagination on tables without a primary key.
Note: Your table must have the primary key before you can change (update and delete) tables. The only exception is with Oracle, where we can get around this.
  • EGL-892: Timestamp parsing for Derby databases may fail on POST and PUT.

    CA Live API Creator Release Notes 2.1

    posted Mar 12, 2016, 9:02 PM by Val Huber

    CA Live API Creator Release Notes 2.1 summarizes new features, known issues, and other important information specific to this Live API Creator release.

    What's New

    This section outlines the marquee new features in Live API Creator:
    • Integration with CA API Gateway
    You can now publish your API project's Swagger documentation to your configured API Gateway.

    For more information, see Integrate with CA API Gateway.
    • IBM DB2 Support
    This release supports the following databases:
      • DB2 for z/OS
      • DB2 for Linux, Unix, and Windows
    For more information about DB2, see IBM DB2 Data Source.
    • Non-Persistent Attributes
    This release supports non-persistent attributes (NPAs), which are pseudo-columns (attributes) that you can add to your API project without affecting the database schema.

    For more information about non-persistent attributes, see Non-persistent Attributes.
    • Combined Resources
    This release supports combined resources, which are resources whose attributes are included in the containing resource.

    For more information about combined resources, including sub-resources, see Combined Resources.
    • CLI-based Configuration Management
    You can script most of the tasks that you can do in API Creator using the admin Command Line Interface (CLI).

    For more information:
    • Response Formats
    This release supports multiple response formats, including CSV, XML, JSON, and JSONObject. For read-only, this release supports CSV and XML.
    Note: The CSV response format is for single-level resources only.

    For more information, see Manage your API Project or context help.
    • Development Life Cycle
    This release supports a number of admin-cli enhancements, information, and samples to facilitate the following:
    • JNDI-based Data Source Definition
    This release supports JNDI as a datasource connection.

    For more information about connecting to JNDI data sources, see
    JNDI-based Data Source definition.
    • Create API Projects with No Database
    You can now create an empty API project without a connection to a database.

    For more information about this new feature, see Create APIs Without Databases or the context help.
    • Improved performance for databases without a primary key.
    You can now ensure consistent ordering and expected pagination results.

    For more information about the Force Consistent Pagination when no primary key setting, see Manage your API Project.
    • Custom Endpoints that Return HTML
    You can now define custom endpoints that are not based on database objects and can return any response type, such as JSON, HTML, or binary data.

    For more information about custom endpoints, see 
    Custom Endpoints.
    • Data Explorer Show Parent
    In Data Explorer, you can zoom to view the parent from the child grid.

    Known Issues

    • EGL-666: Tomcat 8.0.32 is not a supported Java container. A bug in org.apache.catalina.loader.WebappClassLoaderBase.filter prevents the proper operation of the DBaseTypes resource. If the Tomcat classloader is asked about a class named "org" (as will happen if the JavaScript engine requests a class), an exception is thrown.
    • EGL-891: In Data Explorer, date selection pop-up issue.
    • EGL-730: Slow pagination on tables without a primary key.
    • EGL-892: Timestamp parsing for Derby databases may fail on POST and PUT.

    Fixed Issues

    • EGL-531: Auth provider not working.
    • EGL-734: Binary data. You can now define columns with binary data types, including primary keys and foreign keys.

    CA Live API Creator Release Notes 2.0.00.2

    posted Feb 16, 2016, 1:40 PM by Michael Holleran   [ updated Sep 9, 2016, 12:06 PM by LauraC ]

    This is the initial release of CA Live API Creator. It contains:
    • Live API Creator - Web-based UI for defining APIs, Resource Endpoints, Reactive Logic, and Data Security

    • Data Explorer - tablet-ready HTML5/JavaScript app for testing, back-office Data Maintenance

    • API Server - RESTful server
    Known Issues:

     Issue   Work around
    In the API Creator, you cannot create a new authentication provider (EGL-402).Create or edit an auth provider using the REST API directly.
    Under some circumstances, importing multiple resources can result in duplicated sub resources.Identify the problem and correct it by deleting/reimporting the resource.

    For more information about how to do this, see Resource Import Issue.

    1-3 of 3