DATABASE_READ

Allows data to be read from external databases. Supported databases include MySQL, SQL and Postgres.

Properties

Database Connection
dbread_connection

A reference to the database connection record that contains the details on how to connect to the remote database service. Database connections can be defined in the project settings view. An empty value enables a custom connection string to be set.

Database Connection Template (Use DB record ID) ${}
dbread_connection_template

When the connection is not set, allows the connection URI to be set as a URI. This field accepts template syntax.

Collection / Table name ${}
dbread_collection

The database table or collection that the action will access once connected to the database.

Sort Key
dbread_sortKey

When provided, this key will be used to sort the results in the query.

Sort Direction
dbread_sortDir

When a sort key is provided, determines the order of the sort for the query.

valid options
ASCResults will be sorted in ascending order.
DESCResults will be sorted in descending order.

Page Size
dbread_pageSize

Specifies the maximum number of results to be returned.

Page Number
dbread_pageNumber

Specifies the "page" of records to retrieve. The number of records in a page is specified by the page size. As an example, a page size of 50 and a page number of 3 will retrieve the 101st to 150th record that matches the query.

Out Key
dbread_outkey

The property that will contain the result of the query.

Record Identifier Template ${}
dbread_recordIdentifierTemplate

An identifier for the query that will be recorded in the Outbound Call Record created. This identifier will be searchable. Please set this to make your logs easier to interpret.

Do Raw Query
dbread_doRawQuery

When enabled a raw query will be sent to the server rather than using the query fields.

Raw Query Value ${}
dbread_rawQuery

Provides the raw query to be sent to the server. Accepts template syntax.

Parse List Values (MSSQL)
dbread_allowListParsing

When enabled, allows the provided raw query to accept an array of values rather than a simple value that will be inserted into the query.

Include these query fields...
queryFields

A set of records that are used to define conditionals for use in database queries.

Input Key
queryFields[].key

The property of the database record to evaluate. Uses dot notation conventions.

Operator
queryFields[].queryOperator

The logical operator that determines how the value of the property will be compared against the value supplied in the condition.

valid options
Equals
$eq
The property must be equal to the condition value.
Not Equals
$ne
The property must be different from the condition value.
Less Than
$lt
The property must evaluate to a number and must be less than the condition value which also must evaluate to a number.
Greater Than
$gt
The property must evaluate to a number and must be greater than the condition value which also must evaluate to a number.
Less Than Or Equals
$lte
The property must evaluate to a number and must be less than or equal to the condition value which also must evaluate to a number.
Greater Than Or Equals
$gte
The property must evaluate to a number and must be greater than or equal to the condition value which also must evaluate to a number.
In
$in
The property must contain the condition value.
Not In
$nin
The property must exclude the condition value.

Value ${}
queryFields[].value

The value will be compared against the database using the designated operator.