Create an OmniScript and use lookup input.
First we are Drag & Drop Text Field And Lookup Input In Canvas
Here we will do dynamic Query Without Extract DataRpator using Lookup Inputs.
Here we first select the data source sObject type in Lookup.
Here we can bring the data from the database without extracting it throught the Lookup Input.
Populate Lookup Element with Query Result: Here, we specify what we want to store in the variable using a colon, which is then used in the following path.
Let’s preview and check the JSON.