Skip to main content
Go to the Studio
MySQL

MySQL - Get single result

MySQL - Get single result

Gets one row from the results of a MySQL: Query action by its index. Useful when you need a specific row without iterating over every result. To read the fields of that row, use MySQL: Get result field.


Options​

Query​

Reference to the MySQL: Query action whose results will be used.

Result position​

Index of the row to get. The first result is at position 0.

Returns​

Javascript code​

js
actions["action-id"].resultIndex // index of the selected result (Number)
actions["action-id"].result      // selected row (Any)

Field selection​

  • resultIndex — index of the selected result (Number)
  • result — row selected from the query (Any)

Rules and Conditions​

  • The Query and Result position fields are required.
  • The index starts at 0 for the first result.
  • If the index is outside the result range, the return will be empty.