From Bright Pattern Documentation
Jump to: navigation, search
• 3.10 • 3.11 • 3.12 • 3.13 • 3.14 • 3.15 • 3.16 • 3.17 • 3.18

Salesforce.com Search

The block is the part of Salesforce.com Integration with Bright Pattern Contact Center

This block executes the specified SFDC record selection statement written in either the Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL). Scenario variables can be used in this statement in the $(varname) from. Consider this example of an SOQL statement that uses the $(ANI) variable: SELECT id, name FROM Accounts WHERE phone = ‘$(ANI)’.

The columns of the first record of retrieved recordset are stored in variables <recordset_name>.<column_name>. For the statement above the results will be stored in variables Recorset.id and Recordset.name.

The number of returned records is stored in variable <recordset_name>.__count__, for example RS.__count__. (Note the double underscores in front and after count; they are used to reduce the chance of confusing the name of this variable with a column name in a recordset.)

To iterate through the recordset, use Get Next Record block.


Conditional Exits

  • Failed – Executes if the search operation failed.
  • No Data - Executes if no data matching the specified search criteria is found.


Settings

  • Title text - The name of the block instance.
  • Name the retrieved recordset – Name of the recordset that will be retrieved via this search operation.
  • Query language – Language used for the data query. Possible options include the Salesforce Object Query Language (SOQL) and Salesforce Object Search Language (SOSL). Unlike SOQL, which can only query one object at a time, a single SOSL query can be used to search multiple objects, which can both simplify and improve efficiency of searches, especially in large SFDC environments. For more information, see http://www.salesforce.com/us/developer/docs/soql_sosl/index_Left.htm.
  • Statement – Record selection statement in the selected Query language. May contain application variables in the $(varname) format.


The code and the body of the received HTTP response is stored in local variables $(integrationResultCode) and $(integrationResultBody) respectively. For troubleshooting purposes, use EMail or Internal Message block to obtain content of responses indicating a failed search attempt. For more information, see description of variable $(integrationResultBody).


< Previous | Next >
< Previous | Next >