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>}}