Skip to main content
Version: 2.11

Exec Stored Query

Execute a pre-defined query in the gateway

Description​

Execute a query that is pre-stored in the gateway. Define a type that extends "Stored Query" type. Use that type as input of this brick. Give the body in the request as argument. Returns the result of the query against the specified database

Inputs​

  • Control Flow (Control Flow)
  • Stored query (Type): Stored Query inherited type: defines a stored query
  • Body (Object): Request body. Should contain "bindings" value: an object containing the value that needs to be added to the query, corresponding to a named template. Templates are ":bindingName" for values, ":bindingName:" for identifiers

Outputs​

  • Control Flow (Control Flow)
  • Error Flow (Error Flow): Error if the execution of stored query fails
  • Result (Array): Rows array of json column named with row values.