Data Lookup with ID
Last updated
Last updated
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.
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.
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.
The result for the above example is shown in the image below.
