On the Preferences tab of a Salesforce data dipdata dip - Data dips are search points that collect data from external platforms (like a CRM) or within the call flow. For example, if you ask a caller to input their customer number, this number will be verified against a database. the following configurations can be done:

Query: paste a SOQL expression in this field.
Retrieve data action: by selecting this option, the data structure of the information to be gathered will be presented.
Properties retrieved: displays the data model of the information to be retrieved and allows at each property level to define a variablevariable - Variables allow you to collect data and use it to make routing decisions. It includes, for example, information collected via IVR menus or via data dips into the account’s CRM system. Once added in a step, a variable can be reused in another step. Variables for Callbar can be managed through the 'Manage context' menu. to be used after in the flow and/or to be exposed.

The variables can be used along with the SOQL expression in WHERE clauses. In order to avoid formatting errors, the tag is available. This tag prevents some SOQL inconsistencies such as querying by names that contain single quotes. Please check the following SOQL example:

SELECT Id, Owner.Email, Owner.Name, CreatedDate FROM Account WHERE Owner.Name = '<escape>%{current_flow.ctx_name}</escape>'



The names of the Salesforce fields you are retrieving in the query are case sensitive, so they must be an exact match.

You should not isolate the Salesforce Objects (such as the Case Object) between double quotes to build the queries. Hence, the query should follow the example below.

SELECT Id, CreatedDate FROM Case WHERE CreatedDate = LAST_N_DAYS:7 ORDER BY CreatedDate DESC LIMIT