Syncari offers a multitude of functions that can be used to build your data pipelines.
Function
Lookup External Record
Availability
- Entity Pipeline ✅️
- Field Pipeline ✅️
Purpose
The Lookup External Record function allows you to run a lookup, similar to our Lookup Syncari Record function, but allows you to look directly to an external system instead of the Syncari data set. This is especially useful when you have a large data set that will be used very infrequently in Syncari and isn't necessarily part of your unified data model.
Noteworthy Facts
- Lookup External Record currently supports database Synapses and the Salesforce Synapse
- This is not a replacement for Lookup Syncari Record
- Lookup External Record is going to be much slower than Lookup Syncari Record
Usage
- Display Label: Enter the name you want to give this function on the canvas.
- Description: Enter a few words to remember what this functions purpose is in your pipeline.
- Synapse: Select the Synapse you want this function to look to.
-
Search Condition: Enter the SQL/SOQL query you want the function to run against the external system. If you need to specify a variable in the WHERE clause use a
?
to designate a variable value and set the tokens in the Positional Params setting below. For example:SELECT field FROM table WHERE field_x = ?
-
Positional Params: A comma separated ordered list of tokens that will replace the
?
in your Search Condition.
Results Tokens
In order to work with the results of the Lookup External Record function, you'll need to use the following token:
{{Records from <node name>}}