Retrieve data from a table using lookup conditions

This example demonstrates how the Lookup Snap retrieves data from a table called customer1.


SQL Server Lookup Example Pipeline

  1. Configure the SQL Server Lookup Snap to pass the dynamic variable used in the WHERE clause from an upstream Snap like JSON Generator. Retrieve customers with the condition applied on customername field. In this example, only two fields (customername, product) are shown in the output fields set in the Output fields property.

    SQL Server Lookup Snap Configuration

  2. View the sample output showing the retrieved customer data.

    SQL Server Lookup Output