Method

POST

URL

http[s]://<server_url>/rest/ng/query/export

Body

Response

savedQueryId

The id of the query that you are trying to export.

Integer only

drivingForm

The search perspective is determined by the driving form. If left empty, it defaults to "Participant."

(For instance, when the driving form is set to "Participant," the root table becomes 'catissue_coll_prot_reg,' which is then joined with other tables. Similarly, if the driving form is set to "Specimen," the root table will be 'catissue_specimen,' which will also be joined with other tables.)

Participant, Specimen

cpId

When exporting for a single CP, include its CPID. For exporting all CPs, use a value of -1.

Integer only

aql

A valid AQL query for exporting data to a CSV file.

String

wideRowMode

• Default value is OFF, meaning multi-valued attributes result in a single row.

• Other permitted values are SHALLOW and DEEP. Experiment to determine which option best suits your use case.

DEEP, SHALLOW, OFF

dataFile

Handle or file ID to use for downloading the exported CSV file.

string

Completed

Boolean indicating whether the exported CSV file can be downloaded right away.

true, false

Method

GET

URL

http[s]://<server_url>rest/ng/query/export?fileId=<dataFile>

Response

Case 1:

When export data file is not ready, you will get HTTP response code 400 with the below message.

[
  {
    "code":"QUERY_EXPORT_DATA_IN_PROGRESS",
    "message":"The query result data export is in progress. Retry downloading the file after some time."
  }
]

Case 2:

When the exported data file is ready, you will receive an HTTP response code 200 along with the ZIP binary stream included in the response body.