Scripting

Search…
Scripting
Introduction
The Medable platform offers a JavaScript API for developers to create, read, update, and delete cortex objects; query and aggregate data; send custom notifications; perform callouts; console and debug logging; create object triggers; run scheduled jobs; create custom API routes and more.
All scripts run synchronously. There are no callbacks or timers and as such no implementation of functions such as setInterval, setTimeout or setImmediate. For example, a route script employing an HTTP callout might look like the following.
import http from 'http';
​
try {
  const response = http.get('https://www.example.com/service?json');
  return JSON.parse(response.body);  
} catch(err) {
    // handle me
}
Environment Notes
Compatibility
The Javascript engine is ECMAScript 5/5.1 compliant. You can also use many ES2015 features and some decorators. The following babel plugins are enabled for that reason.
babel-plugin-check-es2015-constants
babel-plugin-transform-decorators-legacy
babel-plugin-transform-class-properties
babel-plugin-transform-regenerator
babel-plugin-transform-es2015-arrow-functions
babel-plugin-transform-es2015-block-scoped-functions
babel-plugin-transform-es2015-block-scoping
babel-plugin-transform-es2015-classes
babel-plugin-transform-es2015-computed-properties
babel-plugin-transform-es2015-duplicate-keys
babel-plugin-transform-es2015-function-name
babel-plugin-transform-es2015-literals
babel-plugin-transform-es2015-modules-commonjs
babel-plugin-transform-es2015-object-super
babel-plugin-transform-es2015-parameters
babel-plugin-transform-es2015-shorthand-properties
babel-plugin-transform-es2015-spread
babel-plugin-transform-es2015-template-literals
babel-plugin-transform-es2015-destructuring
babel-plugin-transform-es2015-for-of
babel-plugin-transform-es2015-typeof-symbol
babel-plugin-transform-object-rest-spread
Decorators
The following decorators are built-in and can be imported using the decorators-{decoratorName} convention like in this example: autobind, decorate, deprecate, enumerable, extendDescriptor, lazyInitialize, nonconfigurable, nonenumerable, override, readonly
import autobind from 'decorators-autobind';
import readonly from 'decorators-readonly';
​
class Eye {   
​
    @readonly
    pie = 'pie'; // initializable properties support.
​
    @autobind
    apple() {
        return this.pie;
    }
​
    orange = () => this.pie; // bound functions support.
}
​
const eye = new Eye();
​
eye.apple.call(null); // 'pie' returned even though bound to null.
eye.orange.call(null); // 'pie' returned even though bound to null.
eye.pie = 'not allowed'; // throws
Modules
Module loading is available via CommonJS; Standard and custom modules are loaded using require and defined using module.exports. Imports and exports are also supported.
For example, a module exported as c_utils, defined as:
import _  from 'underscore';
​
export default {
​
  dateToAge: function(birthDate) {
    if (!_.isDate(birthDate)) return 0;
​
    const today = new Date(),
          m = today.getMonth() - birthDate.getMonth();
​
    let age = today.getFullYear() - birthDate.getFullYear();
​
    if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {
      age--;
    }
    return age;
  }
};
might be loaded and used in a route as follows:
import utils from 'c_utils';
​
const me = org.objects.Accounts
  .find({
    _id: script.principal._id
  })
  .paths('dob')
  .next();
​
return utils.dateToAge(new Date(me.dob));
All scripts run in strict mode. For triggers, jobs and routes the entry point to the script is called main, which can be seen in script stack traces. In order to get meaningful stack traces, it's good practice to name all functions.
Stack traces are available for debugging via the Error object's trace property or the getCurrentStackTrace global function. A stack trace is also provided with calls to the logger or console modules.
The console, consts, org and script auto-globals are always guaranteed to be available, though console printing only works on the development servers.
--
InsertOperation
Operation defaults are bypassCreateAcl(false), dryRun(false), grant(null), lean(true), skipAcl(false).
bypassCreateAcl(bool = true)
dryRun(bool = true)
execute()
grant(level)
lean(bool = true)
locale(identifier)
skipAcl(bool = true)JavaScript
const Items = org.objects.c_items;
​
const _id = Items.insertOne({c_key: 'unique key'}).execute();
​
return Items.find({_id: _id}).paths('c_key').next();
InsertOperation.bypassCreateAcl(bool = true)
Skips createAcl checks.
Arguments
bool (Boolean)
Returns
this
InsertOperation.dryRun(bool = true)
The operation performs a dry run. Though no documents are inserted, before triggers are called.
Arguments
bool (Boolean)
Returns
this
InsertOperation.execute()
Executes the operation.
Returns
ObjectID|Object If the lean option is turned off, the inserted document is returned. When true, only the inserted identifier is returned.
InsertOperation.grant(level)
Sets the grant level for the operation.
Arguments
level (Number)
Returns
this
InsertOperation.lean(bool = true)
On by default, turning off this option reads the entire inserted document after execution.
Arguments
bool (Boolean)
Returns
this
InsertOperation.locale(identifier)
Specifies the locale of the operation for any localized strings.
Arguments
identifier (String) The locale identifier, which consists of a 2 or 3 letter language tag optionally followed by a region separated by _. For example, en, en_US, en_UK, etc.
Returns
this
InsertOperation.skipAcl(bool = true)
Skips acl checks.
Arguments
bool (Boolean)
Returns
this
UpdateOperation
Operation defaults are dryRun(false), grant(null), lean(true), skipAcl(false).
const Items = org.objects.c_items;
​
const _id = Items.updateOne({c_key: 'unique key'}, {c_key: 'very unique'})
  .skipAcl()
  .grant(consts.accessLevels.update)  
  .execute();
​
return Items.find({_id: _id}).paths('c_key').next();
UpdateOperation.dryRun(bool = true)
The operation performs a dry run. Though no documents are updated, before triggers are called.
Arguments
bool (Boolean)
Returns
this
UpdateOperation.execute()
Executes the operation.
Returns
ObjectID|Object If the lean option is turned off, the entire updated document is returned. When true, only the identifier is returned.
UpdateOperation.grant(level)
Sets the grant level for the operation.
Arguments
level (Number)
Returns
this
UpdateOperation.lean(bool = true)
True by default, disabling this option reads and returns the entire updated document after execution. "modified" may also be used to return an object containing just the modified properties. Otherwise, simply the _id of the updated document is returned.
Arguments
bool (Boolean)
Returns
this
UpdateOperation.locale(identifier)
Specifies the locale of the operation for any localized strings.
Arguments
identifier (String) The locale identifier, which consists of a 2 or 3 letter language tag optionally followed by a region separated by _. For example, en, en_US, en_UK, etc.
Returns
this
UpdateOperation.merge(bool)
Enabling this option allows for an update operation on an array to include elements with and without identifiers. Elements with identifiers will update the existing array elements while those without identifiers will be pushed into the array as new elements. If disabled, and the update operation includes a mix of elements with and without identifiers, a kInvalidArgument will be returned with the reason "Pushed document has an _id and/or updated document is missing an _id."
Arguments
bool (Boolean)
Returns
this
UpdateOperation.pathDelete(path = null)
Deletes a single property or array value using the current cursor options. Passing a path argument overwrites the pathPrefix() option. For example, org.objects.c_object.updateOne({_id: _id}).pathDelete("c_docs.5a2c44f836412438e4c372c2.c_array.bar"); removes "bar" from the c_array string array in the c_docs document array.
Arguments
path (String) Optional. Overrides pathPrefix().
Returns
Object
UpdateOperation.pathPrefix(path = null)
Sets or removes the operation path prefix. When a prefix is present the operation can target documents in a write-through list or nested document array. For example, c_parent.updateOne({_id: parentId}, {$push: [{c_name: 'new child'}]}).pathPrefix('c_children').execute() creates a new c_child instance through the c_parent object's c_children list property.
Arguments
path (String)
Returns
this
UpdateOperation.pathPush(path = null, body)
Shortcut for updateOne(..., {$push: [body]}).pathPrefix(path).execute()
Arguments
path (String) Optional. Overrides pathPrefix().
body (Object) The value(s) to push.
Returns
Object
UpdateOperation.pathUpdate(path = null, body)
Shortcut for updateOne(..., {$set: [body]}).pathPrefix(path).execute()
Arguments
path (String) Optional. Overrides pathPrefix().
body (Object) The value(s) to update.
Returns
Object
UpdateOperation.skipAcl(bool = true)
Skips property acl checks.
Arguments
bool (Boolean)
Returns
this
DeleteOperation
Operation defaults are dryRun(false), grant(null), skipAcl(false).
dryRun execute grant skipAcl
const Items = org.objects.c_items;
​
return Items.deleteOne({c_key: 'unique key'})
  .skipAcl()
  .grant(consts.accessLevels.delete)
  .execute();
DeleteOperation.dryRun(bool = true)
The operation performs a dry run. Though no documents are deleted, before triggers are called.
Arguments
bool (Boolean)
Returns
this
DeleteOperation.execute()
Executes the operation.
Returns
Boolean true if the instance was deleted.
DeleteOperation.grant(level)
Sets the grant level for the operation.
Arguments
level (Number)
Returns
this
DeleteOperation.skipAcl(bool = true)
Skips acl checks.
Arguments
bool (Boolean)
Returns
this
Aggregation Operators
Script Types
Last modified 10mo ago
Copy link
Outline