The Data Retriever Connector applet cannot run all available SOQL functions, and certain limits are in place. To use SOQL in the Data Retriever Connector applet, you must take into account the following information.
LIMIT clause
You must use the LIMIT clause in all SOQL queries to specify the maximum number of records that you expect your query to return. The exception to this rule is if your query contains only aggregate functions. This enables the Data Retriever Connector to prepare the data sources that store the returned values.
...
In the SOQL query, refer to fields and objects using their names or API names as they appear in Salesforce. The resulting data sources use the corresponding labels for those fields and objects. For example, use NVMContactWorld__ACD__c in the SOQL query to return the value of the ACD field on a task (task) record. The corresponding data source is named Task|ACD.
...
You can include one or more placeholders in your SOQL query. The Data Retriever Connector applet replaces the placeholders with data source values or custom configuration settings retrieved at run time.
...
Date aggregate functions are also not supported.
Telephone number format
The telephone number in the CLID data source is in E.164 format. Because SOQL queries only return exact matches, if you plan to use the CLID to retrieve data, ensure that your Salesforce data contains telephone numbers in E.164 format.
Highlighting and autocomplete
...
Created data sources
When you save a Data Retriever Connector containing a SOQL query, a list of the data sources created by the applet appears.
...