Load Row action
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:
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:
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:
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:
Or add new properties:
Last updated