Introduction
This page explains to exporting a query data using the APIs.
Exporting query data
Method | POST |
URL |
|
Body | {
"savedQueryId": <QUERY_ID>,
"drivingForm": "<DRIVING_FORM>",
"cpId": <CP_ID>,
"aql": "<AQL>",
"wideRowMode": "<DEEP/SHALLOW/OFF>"
}
|
Response | {
"dataFile": "query_0_61e59bc2-9350-47db-9af8-a1e7a3b65bc2",
"completed": false
}
|
Parameters
Attribute | Description | Allowed values |
|---|---|---|
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 |
| 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 |
Download Exported Data File
Method | GET |
URL |
|
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. |
Sample code
Below is attached a zip file, which includes the bash script along with a config file. Download the zip file.
How to run
Extract the zip file.
unzip export-query-data.zip
Navigate the directory.
cd export-query-data
Open query-details.config file and add valid values
Make the script executable.
chmod +x export-query-data.sh
Run the script.
./export-query-data.sh query-details.config