Manage Functions

You can define your own RESTful endpoints by creating functions. You can call your JavaScript in  and return a JSON response using functions. Functions can declare explicit arguments.  includes functions in Swagger documentation. Functions are easily discoverable.
You can define your own RESTful endpoints by creating functions. You can call your JavaScript in 
CA Live API Creator
 and return a JSON response using functions. Functions can declare explicit arguments. 
CA Live API Creator
 includes functions in Swagger documentation. Functions are easily discoverable.
Functions can pass rows automatically. Set some fields and
CA Live API Creator
 updates the row (including relevant reactive logic). Instead of getting, altering, and saving a row by having to issue APIs, you can create a function.
You can create a function for the 
 table and the explicitly defined
 resource that gives an employee a raise. The following code snippet shows the JavaScript code:
var theRaise = parameters.percentRaise * (row.Salary/100);
row.Salary += theRaise;  // runs logic, persists change row(s) to database...
return [ {"status": "Success"}, {"raise": theRaise} ];
This JavaScript code is from the
function code example. This example is also illustrated in the Business to Business (B2B) Give Raise example.
For more information:
In this article:
Function Types
You can define the following types of functions:
  • Top-level functions
    Top-level functions are functions that are not associated to a table, view, or table-based resource. By default, functions are top-level functions. Use top-level functions to define any logic or service operation as endpoints.
  • Resource-oriented functions
    Resource-oriented functions are functions that are associated to a table, view, or table-based resource. They are operations on a table, view, or table-based resource row.
    CA Live API Creator
     makes the row available to the function and any arguments. The function can then operate on the row (for example, 
     to alert a colleague about an Order), including update (for example, 
     to an employee based on a 
    Resource-oriented functions advance the API interface from create, read, update, and delete (CRUD) operations to operations the application requires. You can regard resource-oriented functions as the methods that encapsulate your business logic. Reactive logic ensures that your API behavior is reused over all verbs (PUT, POST, and DELETE) for tables, views, and table-based resources. This behavior contributes to a separation of concerns (SoC). Client development can enforce data integrity by proceeding based on the API interface, in parallel with API Server logic.
Create Functions
Create a New Function
  1. With your API open, in the Create section, click 
    If your API does not have existing functions, the Welcome to Functions page appears. If your API has existing functions, they are listed on the By function tab that displays by default.
  2. Complete one of the following options:
    • If you have not defined any functions, on the Welcome to Functions page, click 
      Create a Function
    • If you have defined at least one function, on the By function tab, click
      Create Function
    The Definition tab for the new function appears by default.
  3. Complete the following fields, and then click
    Function name
    The name for the function. Enter a meaningful name for your function (or accept the default name).
    Defines the JavaScript code for the function. You can:
    • Access and insert example JavaScript code by clicking 
       and then
       for the JavaScript code example you want to insert.
      For more information about the JavaScript code examples that are available from the functions code editor, see Code Examples.
    • Code functions in JavaScript that reference JavaScript libraries and Java JAR files in your 
      For more information about the context variables that are commonly accessed in JavaScript code, see the "Commonly Accessed Context Variables in Function JavaScript Code" section.
  4. (Optional) On the Parameters tab, complete the following, click 
    Add Parameter 
    to add more parameters, and then click 
     to save the parameters:
    • Define the parameter names and the type (number, string, or Boolean).
    • Specify whether the Parameter is required.
    • Include a comment to describe the parameter.
  5. (Optional) On the Resources tab, associate this function to one or more tables, views, or table-based resources. This allows the function to access individual records in the function JavaScript code using the current table
    object. Enter the names on separate lines in the text box.
    Use the following syntax for tables:
    <data source prefix>:<table name>
    For more information:
  6. On the Documentation tab, describe the purpose of this function by defining comments and the return type that the function expects.
    The comments and return type are included in your Swagger API documentation.
  7. Save your changes.
Your function is created and is active. The function is listed on the By function tab, using the following syntax:
<Function name>(<param1>,<param2>, etc.)
Commonly Accessed Context Variables in Function JavaScript Code
You code functions in JavaScript. They can reference JavaScript libraries and any Java JAR files included in your 
. Your function returns a JavaScript object, which is converted to JSON or translated if you are using XML output.
Your functions can access the following variables:
var theRaise = parameters.percentRaise * (row.Salary/100);
Define your parameters.
For more information about how to define your parameters, see the "Create a New Function" section.
row.Salary += theRaise;
Row variable attributes are based on the column names for the table or view. Alias column names (or attributes) for resources are not available from the row variable.
For more information about Read/Write row access, see the "Resource-Oriented Functions - Read/Write Row Access" section.
var user = req.userIdentifier
var functionResponse = SysUtility.getFunction(eachTest.TestName, null);
See the
The following image shows an example of the
function's JavaScript code (for the B2B sample):
Screen Shot 2017-01-09 at 8.51.15 AM.png
Resource-Oriented Functions - Read/Write Row Access
You can optionally associate functions with tables or table-based resources. Users of the API can call these function only on rows to which they have at least Read access. In such cases, your function's code can reference the row variable, as shown in the previous image. Note this is 
row. Mapping and translation has already been provided (column de-aliasing, etc.). You can use your function code over multiple table-based resources based on the same table.
You can also update the row in functions. When the function completes,
CA Live API Creator
 calls the associated logic, and (if no errors are detected), persists the row to disk.
You cannot access the
object within functions.
You can call resource-oriented functions from Data Explorer.
Call Functions
You can call functions in the following ways:
Call Functions as Endpoints
You can call functions using the function name, optionally with parameters, using the following syntax:
Call Functions on Tables, Views, or Resources
Prerequisite: (Views) You have added a virtual primary key to the view.
For more information about how to add a virtual primary key to a view, see Manage Views.
You can call functions on tables, views, or resources and pass arguments.
Use a URL with the following syntax:
.../v1/<data source prefix>:<table, view, or resource name>/1/<function name>
The following are examples of calling the
Call Functions using the SysUtility.getFunction() Method
You can call functions by way of GET operations. You can call functions from within API Server (for example, from logic, libraries, and functions), using the 
 method, for example:
var parms = {parm1: 1, parm2: 2};
var functionResponse = SysUtility.getFunction("myfunction", parms);
Test Functions from the REST Lab
You can use the REST Lab to test your function. You can select top-level functions as an endpoint from the list. For resource-oriented functions, you can enter the URL directly.
For more information about how to test functions in the REST Lab, see Test your API Using the REST Lab.
Call Functions on Tables from Data Explorer
You can call resource-oriented functions in Data Explorer.
For more information about how to call functions on tables from Data Explorer, see Data Explorer.
Export Functions
You can save a function and its parameters as a JSON definition file to a download directory.
  1. From the By function tab, click the function that you want to export.
    The function opens in edit mode.
  2. Click
 file containing the exported function is downloaded.
Import Functions
You can import a previously exported function into your API.
  1. From the By function tab, click
    Import Function
    The Import JSON window opens.
  2. Select the previously exported function JSON file by name.
    If the function name already exists, API Server appends
    and a timestamp to the duplicate function using the following syntax:
    <Function name>_clone_<timestamp>(<param1>,<param2>, etc.)
The function is imported and displays in the list.
Set Function Permissions
As an admin, you can control access to your functions by setting function-level permissions for roles. By default, roles have permission to call all functions. You can also set permissions to specific functions for a given role. If your auth token has more than one role with differing permissions to a function, the Execute permission takes precedence.
For more information about how to control a role's permission to call specific functions, see Role-Based Endpoint Access.