Overview
Creates a connection to the relevant system with the information defined on the domain and runs the query
DataTable $Database.ExecuteQuery(connectionName: string, query: string, timeout: number, parameters: object)
Arguments
string connectionName
name of external database name
string query
query to be run
number timeout
request timeout. Optional.
object parameters
Parameters set on the query. Optional.
Remarks
CONNECTION_NAME can be set on Edit Domain → URL Credentials → External Database Credentials.
Example
$Database.ExecuteQuery("CONNECTION_NAME", "select * from wDomains where Id=@Id", {
Id: "17cec122-a909-45ac-89f9-78b5e96fc0c4"
});