Data Lookup with ID

Block Information

Available in: Page Flow and Cloud Flow

Toolbox Category: Data - Read

Block Type: Regular

Data Lookup with ID is a regular block that triggers the search for a record from a database table. The search operation is carried out using the automatically created ID field that is part of every database table.

Data Lookup with ID block

The block consists of the following (from top to bottom):

• Table: Value Parameter that accepts a text value representing the name of the Database Table .
• Dataset Name: Value Parameter that accepts a text value representing the name of the dataset. This can be any text value and can later be used to track the completion of the read.
• Record ID: Value Parameter that accepts a text value representing the record identifier.

To access the record after a successful search, use the Data Record Info block.

---

Usage Example

NOTE: Please refer to the prerequisite information shown here before seeing the example.

The image below shows an example of the Data Lookup with ID block where a search is conducted on the Customers database table which we have discussed here.

Example of Data Lookup with ID

The result for the above example is shown in the image below.