Docs‎ > ‎CA Live API Creator‎ > ‎Create‎ > ‎Resources‎ > ‎


RESTful APIs - part of Live API - provide the "crud" services for your resources:
  • GET (read), including filters and sort

  • POST (insert, one or multiple rows)

  • PUT (update, one or multiple rows)


The diagram at right shows that you can use the REST Lab to test your API, without having to write a one-off test program.

The page below described some of the key services provided by the REST APIs that result from your Resource definitions.

Key APIs

This table introduces some of the main APIs.  You can test these - without writing a program - in the REST Lab (shown at right).  You can find details about REST parameters here, under the package

 URL  REST is usually an HTTP based protocol.  This page describes how your projects' URLs are constructed
 GET  Retrieving Resources defined in the Logic Designer
 POST  Creating new resources
 PUT  Updating existing resources
 DELETE  Delete existing resources
 MERGE_INSERT     Insert new row or Update if row exists by metadata key
 Summary Information  Important summary information returned from Post, Put and Delete, including information to refresh page data and verify rule processing

API Samples

In addition to the REST Lab, you can review programs:

Several general principles are noted below.

Application Oriented

A key design goal has been to simplify client design, particularly with respect to performance.  See optimistic locking, refresh, and heterogeneous updates.

Parameters vs. Headers

Request elements typically associated with headers can be supplied as parameters, to facilitate testing via browsers.  For example, you can specify the api key as the auth parameter.

Sub Resource Reference and Operation

Resources can consist of Sub Resources, typically for related data (the Lineitems contained in an Order, or the Product information for a LineItem).  The API is designed so you can operate on Sub Resources (e.g, update them), which you reference with a dot notation in your URL such as Customer.Orders.Lineitem.


A key goal of REST is to make your API discoverable by software.  GET requests on base table resources return link objects:

    "@metadata": {
      "href": "",
      "checksum": "A:d1e88016526ce84e"
    "order_number": 1,
    "amount_total": 35,
    "paid": false,
    "item_count": 2,
    "notes": "This is a small order",
    "customer_name": "Alpha and Sons",
    "salesrep_id": 1,
    "links": [
        "href": "",
        "rel": "children",
        "role": "lineitemList",
        "type": ""
        "href": "",
        "rel": "children",
        "role": "purchaseorder_auditList",
        "type": ""

The following Admin Resources are provided:

 URL  Description
http://localhost:8080/rest/default/demo/v1/@tables?projectId=1078&auth=vSrmIZxaAJA9StW2XTcy:1 Returns a list of all the tables in a project (here, the eval LogicDemo project)
http://localhost:8080/rest/default/demo/v1/@resources?projectId=1078&auth=vSrmIZxaAJA9StW2XTcy:1   Returns a list of all the Resources in a project

Subpages (24): View All