filter
, 
sysfilter
, 
userfilter
. An object with the desired filters for each resource.
Use aliased attribute names (not table attribute names) for 
filter
 and 
sort
.
By default, these properties work with 
SysUtility
 calls. If you have turned off regular filters and sorts, only named filters (the 
sysfilter
 and 
userfilter
 properties) work with 
SysUtility
 calls. For more information about how to turn off regular filters, see Manage your API.
For more information about using named filters, see Structured Filters.
order
, 
sysorder
, 
userorder
. An object with the desired sorting orders for each resource.
By default, these properties work with 
SysUtility
 calls. If you have turned off regular filters and sorts, only named sorts (the 
sysorder
 and 
userorder
 properties) work with 
SysUtility
 calls. For more information about how to turn off regular filters (and sorts), see Manage your API.
For more information about using named sorts, see Structured Sorts.
pagesize
. The maximum number of row per resource level.
offset
. The number or records to skip from the top resource.
chunksize
 . Determines the number of queries 
CA Live API Creator
 executes to return the rows for table-based subresources.

var settings = {sysfilter: "equal(OrderID:" + row.OrderID + ")"
  ,"sysfilter..SupplierAlert.Order_DetailsList.Product.Supplier":
  "equal(CompanyName: '" + "Pavlova, Ltd." + "')" };

var details = {
  filter: "name like 'ABC%',
  order: "name asc",
  pagesize: 20,
  offset: 0,
  chunksize: 10
};

var supplierReport_response = SysUtility.getResource("SupplierAlert", options);

About how to disallow free-form filters, see Manage your API.
About how to use URL parameters in GET, PUT, POST, and DELETE, see URL Parameters.

var parts = SysUtility.
getResource("main:Products", {sysfilter: "less(price:100)", sysorder: "(price:desc)"});
for (var i = 0 ; i < parts.length ; i++) {
   log.debug(JSON.stringify(parts[i]));
}

sysfilter: ["less(total: 100)", "equal(name: 'Acme')"]

'sysfilter.Customer.Orders.Product': 'less(price:100)'

var parts = SysUtility.getResource("
nw:Customer Orders", {filter: {"
nw:Customer Orders": "price < 100"}});

var orders = SysUtility.getResource("nw:MyProc", {procArgs: {empName: "Doe", amount: 123.45}});

SysUtility.
getFunction(functionName, parameterList)

var sum = SysUtility.
getFunction("addNumbers", {parm1: 10, parm2: 20});
log.debug(sum);

About how to use the JSON object, see JavaScript.
About functions, see Manage Functions.

SysUtility.
restGet(url, params, settings)
SysUtility.
restPut(url, params, settings, requestData)
SysUtility.
restPost(url, params, settings, requestData)
SysUtility.
restDelete(url, params, settings)

var result = SysUtility.
restGet(url, params, settings);
var myJson = JSON.parse(result);

var params = {
   name: "Acme",
   country: "Elbonia"
   };
var json = SysUtility.
restGet('http://rest.example.com/myservice', params);
var resultObject = JSON.parse(json);

http://rest.example.com/myservice?name=Acme&country=Elbonia

SysUtility.restGet('http://rest.example.com/myservice',
{name: 'Acme', country: 'Elbonia'}, 
{headers: {
  Authorization : "Basic <base64string>",
  "Cache-Control" : "no-cache"
  },
  proxy: {
    hostname: "proxy.example.com",
    port: 8282
    }
});

var result = SysUtility.
restPut(url, params, settings, requestData);  // requestData is a JSON object
var myJson = JSON.parse(result);

var result = SysUtility.
restPost(url, params, settings, requestData);
var myJson = JSON.parse(result);

var settings = { headers: { Authorization: "CALiveAPICreator supplier:1" }};
var pavlov_response = SysUtility.restPost(url, null, settings,
supplierReport_response);

var result = SysUtility.
restDelete(url, params, settings);
log.debug(result);
var myJson = JSON.parse(result);

var settings = {
  "headers" : {
    "Authorization" : "Basic base64string",
    "Cache-Control" : "no-cache"
  }
};

SysUtility.
restGetBinary(url, params, settings)

var resourceURL = req.baseUrl + "/v1/demo:employee_picture/1/picture";

resourceURL = resourceURL.replace("rest","data");
var params = {};
var settings = { "headers": {"Authorization" : "CALiveAPICreator demo_full:1"}};
var byteArray = SysUtility.
restGetBinary(resourceURL, params , settings);
row.content = byteArray;// set the current row (type CLOB)