Load Entities (SQL)
Load a list of entities from a SQL query into context; so further actions like execute actions on entity list will know to execute given actions for each entity, and expose the entity properties as tokens. A common scenario is to send an email to a list of leads. Note that this action also creates a
[EntityName:Count] token that holds the total number of entities that were loaded.
- SQL Query - SQL to execute. Can contain My Tokens.
- Entity Name - set a name for the entity so you can reference it later by name. Can contain My Tokens.
Properties - map columns returned by the SQL Query to properties of the entity.
SQL Column - column name
Entity Property - property that can be referenced later ([EntityName:PropertyName])
- On Error - define a list of actions to run on error. Otherwise, an error message is returned. It will contain the underlying error if debug mode is on.