Table of Contents

Search

  1. Preface
  2. Introduction to Business Entity Services
  3. Enterprise Java Bean Business Entity Service Calls
  4. Representational State Transfer Business Entity Service Calls
  5. Simple Object Access Protocol Business Entity Service Calls
  6. Services for Cross-reference Records and BVT Calculations
  7. Supporting Corporate Linkage Service
  8. External Calls to Cleanse, Analyze, and Transform Data
  9. Using REST APIs to Add Records
  10. Using REST APIs to Upload Files

Exporting the SearchMatch Results to a CSV File

Exporting the SearchMatch Results to a CSV File

To export the results of a SearchMatch request as a CSV file, in the request URL path, specify the name of the business entity as a
.CSV
file. You can use all the query parameters in the request URL.
For example, use the following request URL to export the results of a search for matching records based on a match rule set:
http://<host>:<port>/<context>/<database ID>/
<business entity>.CSV
?action=match&fuzzyFilter=<business entity field name 1>='<business entity field value 1>',<business entity field name 2>='<business entity field value 2>',...<business entity field name n>='<business entity field value n>'&matchRuleSet=<match rule set name>

Sample API Request

The following sample request searches for records that match the first name STEVE and last name SMITH and returns the query results in the CSV format:
GET http://localhost:8080/cmx/cs/localhost-orcl-DS_UI1/Person.CSV?action=match&fuzzyFilter=firstName=STEVE,lastName=SMITH&fields=recordID,firstName,lastName

Sample API Response

The following sample shows the query results for records that match the first name STEVE and last name SMITH in the CSV format:
recordID,firstName,lastName 00023,Steve,Smith 00035,Steven,Smith 00048,Steve,Smith 00079,Steve,Smithson

0 COMMENTS

We’d like to hear from you!