Introduction

To export query data using APIs and obtain a CSV file, a A two-step process is required . First, you'll utilize an API to initiate the query export, and then another API to download the resulting CSV file.

...

to export query data as CSV using APIs.

1. Run query export API: This API initiates the export process. It allows you to specify the query data you want to export and sets up the necessary parameters for the export operationAQL and other parameters. The query is run in the background and might take a few seconds or minutes to run.

2. Download CSV API: Once the export is scheduled, this : This API enables you to retrieve the exported CSV file containing the queried data. It completes the export process by providing you with a downloadable link or directly fetching the file.

We've provided a sample code for utilizing these APIs daily. By examining this code, you can seamlessly integrate it into your preferred programming language.

...

1. . Since the query might still be running, you will have to run this in a loop.

See the example code below.

Exporting Query Data

{
    "drivingForm": "<DRIVING_FORM>",
    "cpId": <CP_ID>,
    "aql": "<AQL>",
    "wideRowMode": "<DEEP/SHALLOW/OFF>"
}

{
  "dataFile": "query_0_61e59bc2-9350-47db-9af8-a1e7a3b65bc2",
  "completed": false
}

...

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

Sample

...

Code

Attached zip file , which includes the bash a shell script along with a config file. Download the zip file.

...