Data Record Info
Last updated
Last updated
Data Record Info is an output block that provides the object representing a database record when used inside specific contexts that are discussed below.
The output is of type object and is compatible with Value Parameters of type object or of type any.
NOTE: This block will provide valid values only when used in the contexts discussed below:
Data Record Loop block (inside Tasks Flow Parameter) : In this case the Data Record Info block provides the record for the current loop iteration.
Data Status block (inside Success Tasks Flow Parameter) : Here the Data Record Info block provides the first record read from successful execution of the Data Read, Data Read Next Page , Data Read Previous Page and Data Lookup blocks.
Data Lookup with ID block (inside Success Tasks Flow Parameter) : Here the Data Record Info block provides the record that matched the provided record ID.
NOTE: Please refer to the prerequisite information shown here before seeing the example.
The image below shows an example of the Data Record Info block. This example incorporates the Usage Example function, as outlined in the Database Reading Logic for examples section on the prerequisite information page mentioned above.
Here is a summary of the above example:
The Data Record Loop block is used with the Customers Database Table and the dataset name of ds1 are as Value Parameters .
For each iteration inside the Tasks Flow Parameter, we use the Write Log Message block to log the customer's email address by accessing the EmailAddress field of each record.
To access information about the record, we use our Data Record Info block.
The result for the above example can be seen in the browser's web console, and a sample is shown below:
