Row()

Returns a row from a rowset, array, or object.

Availability

This function became available in Marketing Cloud Next during the Summer ’26 release (API version 67.0).

Syntax

Row(rowset, rowPosition)

The Row() function has two parameters:

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

Usage

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.

%%[
  Set @row = Row(@rowset, 1)
]%%

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.

%%[
  Set @json = '
  {
    "Flights": [
      {
        "Origin": "IND",
        "Dest": "NYC",
        "Price": 100.0,
        "PerBagSurcharge": "N/A"
      },
      {
        "Origin": "IND",
        "Dest": "LAX",
        "Price": 200.0,
        "PerBagSurcharge": "Free"
      },
      {
        "Origin": "IND",
        "Dest": "SEA",
        "Price": 500.0,
        "PerBagSurcharge": 25
      }
    ]
  }'
  Set @rowset = BuildRowsetFromJSON(@json, "$.['Flights'][*]", true)
  Set @row = Row(@rowset, 1)
  Set @field = Field(@row, "Price", 0)
  Output(v(@field))
]%%

The function outputs 100.