Devart SurveyMonkey Lookup component joins the input data with the data from SurveyMonkey objects. It has the following custom properties:
Property |
Description |
|---|---|
BatchSize |
The number of objects in the batch query. The default value is 1. |
CacheSize |
The number of cached objects. The default value is 2000. |
CaseInsensitiveLookup |
Determines whether to use case insensitive comparison in Lookup. The default value is False. |
LocalSQLEngine |
Enables local SQL processing, which allows using a more standard SELECT statement features. The default value is True. |
Lookup Object |
The name of the reference object. |
NoMatchAsError |
Determines whether to redirect not matching rows to the Error output. The default value is False. |
UseFirstMatchInMultipleResults |
Determines either to pick the first row from the lookup object in case more than one matching row is found, or to redirect the input row to the Error Output with the corresponding error message. |
UseNullsIfNoMatchFound |
Determines whether to set null values or create no Lookup relationship between the objects, if no matches are found. The default value is False. |