Integration Cloud 6.1.0 | Reference Data | Reference Data Signature
 
Reference Data Signature
Reference Data signature is derived from the column names of the uploaded text file. You can filter the Reference data by providing an appropriate matchCriteria. The output of Reference Data is a list of documents that match the specified matchCriteria.
Note:
The root element in the output of Reference Data created from version 2.1.0 has the same name as the Reference Data.
Input Parameters
matchCriteria
Document Criteria on which documents from the Reference Data will be matched.
Parameters for matchCriteria are:
path: Column names of the Reference Data.
compareValueAs: Optional. Allowed values are string, numeric, and datetime. The default value is string.
datePattern: Optional. Pattern will be considered only if compareValueAs is of type datetime. Default value is MM/dd/yyyy hh:mm:ss a.
joins: List of join criteria.
Each join criteria consists of:
operator: Allowed values are equals, doesNotEqual, greaterThan, greaterThanEqual, lessThan, lessThanEqual, equalsIgnoreCase, contains, doesNotContain, beginsWith, doesNotBeginWith, endsWith, doesNotEndWith.
value: Optional. Allowed values are string, numeric, and datetime. The default value is string.
joinType: Specifies the way two joins can be linked. Values are “and” or “or”. Default value is “and”.
Output Parameters
<Reference Data Name>
Document List List of documents that match the retrieve criteria.
In the following example, the flat file contains “Type”, Our Type”, and Marketer” as headers and has one or more data rows.
Type,Our Type,Marketer
Existing - Growth,Growth,HUNT & SONS INC
The following graphic illustrates the generated Reference Data signature: