LevelOps Tables

Invoked with levelops.tables().

1. query(tableName, [ filters, [ filteringMode ] ]) : Object[]

• Parameters: filteringMode possible values: exact_match(default), contains, starts_with

• Returns: Array of JSON objects representing a table row (a map of column keys to values)

• Example:

levelops.tables().query("Table", { "Column 1": "search string" }, "contains");

2. distinct(tableName, columnName, [ filters, [ filteringMode, [ splitCommaLists ] ] ]]) : String[]

• Returns: Array of distinct values from the column provided, for rows matching the filters (if specified).

• Example:

levelops.tables().distinct("Table", "Column 1");

3. getColumnNameToKeyMappings(tableName) : Object

• Returns: Map of column display names to column keys.

4. updateColumn(tableName, columnName, rowId, value)

• Example:

levelops.tables().updateColumn("Table", "Column 1", row["id"], "new value");