Business Entity Services Guide

10.3 HotFix 2

Back Next

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

Rename Saved Search

Table of Contents

Business Entity Services Guide

Business Entity Services Guide

Exporting the SearchQuery Results to a CSV File

Exporting the SearchQuery Results to a CSV File

Sample API Request

Sample API Response