...
- Via GUI, create a query with the required filters (e.g. filter by CP) and add the columns needed by the external system
- Save the query
- Schedule the query to run at required intervals (E.g. nightly, hourly etc) (For details: Scheduling Queries)
- In every query run, the data satisfying the filters are exported to a CSV file. The exported CSV file is stored in the directory
$OS_DATA_DIR/query-exported-data
using the following name format -scheduled_query_<query_id>_<job_run_id>.csv
. - Write an external program to monitor the query export directory and process the required CSV files (using the filename scheduled_query_<query_id>_*.csv).
...