Integration Cloud 7.0.0 | Built-In Services | Built-In Services | searchDocuments
 
searchDocuments
Searches a set of documents for entries matching a set of Criteria.
Input Parameters
documents
Document List Set of documents from which the documents meeting the search criteria are to be returned.
searchCriteria
Document Criteria on which the documents in the documents parameter are to be searched.
Valid values for searchCriteria parameters are:
*key. Name of the element in documentList whose value provides the value for the search text. The value for key can be a path expression. For example, "Family/Chidren[0]/BirthDate" retrieves the birthday of the first child from the input Family document list.
*value. Optional. Any search text. If no value is specified, the service searches for null in the document list.
*compareStringsAs. Optional. Allowed values are string, numeric, and datetime. The default value is string.
*pattern. Optional. pattern will be considered only if the compareStringsAs value is of type datetime. For information about using patterns, see the Time Zones section.
sorted
String Optional. The value of the sorted parameter is true if the document list is already sorted based on the search criteria and same search key; otherwise false.
If the value for the sorted parameter is set to true, the required documents are searched faster.
Output Parameters
resultdocuments
Document List List of documents which are matching the search criteria.
documentListIndices
String List Positions of search documents in the document list.
documents
Document List List of documents that were input.
Usage Note
For example, if you want to search a set of documents for documents where BirthDate is 10th January 2008, the values for the searchCriteria parameter would be:
key
value
compareStringsAs
pattern
Birthdate
2008-01-10
datetime
yyyy-MM-dd