Skip to main content
Version: 1.x

Built-in functions

Besides basic JavaScript utilities and classes for SurrealQL types, there are a handful of utilities built into the embedded scripting functions.

FunctionDescription
async fetch(resource, options)Full fledged fetch implementation closely matching the official specification.
async query(surql)Run SurrealQL subqueries from within the embedded scripting functions.
async value(variable)Retrieve values for SurrealQL variables from within the embedded scripting functions.

async fetch(resource, options)

Full fledged fetch implementation closely matching the official specification.

NOTE: For complete documentation, please refer to the MDN documentation.

ArgumentsDescription
resourceREQUIRED

Accepts either a url in a string, or a URL or Request object.

options

Accepts various options related to the request. Refer to MDN docs for a full reference.

RETURN function() {
// List all posts
const posts = fetch('https://jsonplaceholder.typicode.com/posts');

// Update post with ID 1
const updated = fetch('https://jsonplaceholder.typicode.com/posts/1', {
method: 'PUT',
body: JSON.stringify({
id: 1,
title: 'foo',
body: 'bar',
userId: 1,
}),
headers: {
'Content-type': 'application/json; charset=UTF-8',
},
});

return { posts, updated };
}

async query(surql)

Run SurrealQL subqueries from within the embedded scripting functions.

NOTE: Only subqueries can be executed with the query() function. This means that only a single query can currently be executed, and that only CRUD operations are allowed.

ArgumentsDescription
surqlREQUIRED

Accepts a single SurrealQL query, which is limited to a CRUD operation.

CREATE user:john, user:mary;

RETURN function() {
// Select all users
const users = await surrealdb.query("SELECT * FROM user");

// Prepared query
const query = new surrealdb.query("SELECT * FROM $id", {
id: new Record('user', 'mary')
});

// Execute prepared query
const mary = (await surrealdb.query(query))[0];

// Assign variables later to prepared query
query.bind('id', new Record('user', 'john'));

// Execute prepared query
const john = (await surrealdb.query(query))[0];

return { john, mary };
}

async value(variable)

Retrieve values for SurrealQL variables from within the embedded scripting functions.

ArgumentsDescription
variableREQUIRED

Accepts the path to a variable

LET $something = 123;
LET $obj = {
nested: 456
};

LET $arr = [
{ value: 1 },
{ value: 2 },
{ value: 3 },
{ value: 4 },
{ value: 5 },
{ value: 6 },
];

RETURN function() {
// Get the value for a variable
const something = await surrealdb.value("$something");

// Get the value for a nested property
const nested = await surrealdb.value("$obj.nested");

// Filter properties from an array
const fromArray = await surrealdb.value("$arr[WHERE value > 3].value");

return { something, nested, fromArray };
}