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. Appendix A: Using REST APIs to Add Records
  10. Appendix B: Using REST APIs to Upload Files
  11. Appendix C: Using REST APIs to Manage Reports

Exporting the SearchQuery Results to a CSV File

Exporting the SearchQuery Results to a CSV File

To export the results of a SearchQuery request to 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 records that match the field values that you specify:
http://<host>:<port>/<context>/<database ID>/
<business entity>.CSV
?action=query&filter=<business entity field name 1>='<business entity field value 1>' AND <business entity field name 2>='<business entity field value 2>'...AND <business entity field name n>='<business entity field value n>'

Sample API Request

The following sample request queries for records with 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=query&filter=firstName='STEVE' AND lastName='SMITH'&fields=recordID,firstName,lastName

Sample API Response

The following sample shows the query results in the CSV format for a query with the first name STEVE and last name SMITH:
recordID,firstName,lastName 00023,Steve,Smith 00048,Steve,Smith

0 COMMENTS

We’d like to hear from you!