Skip to main content
Version: Next

Exec Raw Sql

Execute a pre-defined query in the gateway

Description​

Execute a query provided in the parameters. Give the body in the request as argument. Returns the result of the query against the specified database

Inputs​

  • SQL query (String): The SQL query to execute on the database with the bindings to be matched by the Body input
  • 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
  • Control Flow (Control Flow)
  • DB Config ID (String): The id of the database which is supposed to receive the query

Outputs​

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