LEADCONDUIT ADD-ON
Lookup Table | Lookup Table - Query
Lookup tables let you enrich incoming leads with additional data based on fields you already have.
SPECIFICATION
Fields & configuration
The exact fields this add-on uses, appends, and the configuration options available in LeadConduit.
Appended Fields
ActiveProspect will append the following data to your lead.
| Appended Field | Description |
|---|---|
Outcome | success on match, failure on miss, error on transport or service failure. |
Reason | Human-readable reason on failure or error. |
Key | The matched key echoed back by the service (the query). For composite-key tables, the key column values joined by the ASCII unit separator. |
* | Value columns from the matched row, keyed by table column name. Includes both designated key columns and designated value columns, as returned by the service. When lookup_table.return_columns entries are mapped, only those columns are appended. |
Custom Input Variables
The following are configuration options (typically not collected with lead data).
| Variable | Description |
|---|---|
| Lookup Table Table Id | BSON id (24-char hex) of the lookup table to query. |
| Lookup Table Keys | Map of table key column name to lookup value. The user maps one entry per designated key column of the selected table (e.g. lookup_table.keys.zip mapped from lead.postal_code). |
| Lookup Table Return Columns | Columns to append to the event, one entry per column with the column name as the value (e.g. lookup_table.return_columns.1 set to territory). Leave unmapped to append all columns returned by the service. |
| Lookup Table Skip Filter Id | Id of the match-handling filter step managed by the Lookup Table config panel. Set by the UI for bookkeeping; not used by the integration. |
| Timeout Seconds | Produce an "error" outcome if the server fails to respond within this number of seconds (default: 360) |
GETTING STARTED
Add Lookup Table in three steps
Add the add-on
In your LeadConduit flow, add a new Add-On step and select Lookup Table.
Provide required data
Map the lead data the service needs. Required fields and configuration options are shown above.
Use the result
Run the flow and use the add-on result for real-time routing, validation, enrichment, or downstream decisions.
KEEP EXPLORING
More add-ons
Catch fraudulent leads before they move downstream
Add trusted services to your LeadConduit flow in minutes, or talk with our team about the right add-on for your workflow.