Load Row

The Load Row action allows you to load a row from a table by a given condition.

Specify the filter condition to find the row to load:

// id = 23
{{ui.table.selectedRow.data.id}}

You can also specify multiple conditions, in this case the row will be loaded if all conditions are met.

This condition will be sent to the server and converted to a SELECT statement like this:

SELECT * FROM users WHERE id = 23 LIMIT 1;

Note: you can check the Payload section to see the actual condition sent to the server.

Note: if the conditions aren't specified, the first row will be loaded.

Load Row action returns a single object response:

{
  id: 1,
  name: "Bobbie Bogan II",
  first_name: "Bobbie"
}

You can also use various condition operators to filter the table. For example, to load rows with a partial match, use the like operator.

Data transformation

If the database returns its data in a different format than the components expect, enable transform result toggle or add a new Code step to transform the data.

Then you can map the object to a proper format:

return {
  ...{{data}},
  name: {{data}}.name.toUpperCase(),
};

Or add new properties:

return {
  ...{{data}},
  created_at: new Date(),
};action