Returns a row from a rowset or array.

The Row() function has two parameters:

  • rowset (string): Required. The rowset to return a row from.
  • rowPosition (string): Required. The row number to return. The first row is row 1.

To use the function, pass it a rowset, and the row number that you want to return. This example sets the value of @row to the first row of the rowset contained in the @rowset variable.

You can combine the Row() function with the Field() function to output a specific piece of data from the specified row. This example creates a rowset from JSON data. The Row() function retrieves the first row from the rowset. The Field() function retrieves the value of the "Price" attribute from the first row.

The function outputs 100.