4Export Data using the API

Automate exports with an API call using start date and interval parameters to control each extraction window.

We recommend that you automate the exporting of data with API calls. You will need to set the start date and interval as part of your request. The earliest start date is when Export Views is enabled for your environment, unless you have requested Oracle to back fill time stamps for historical data.

Here's an example API call for ADDRESS_EXPORT_INCR:

curl -X POST -u file_name:password -o file_name.csv -H "Content-Type:multipart/form-data"  -F "ReportRequest={\"attributeFormat\":\"csv\",\"attributeTemplate\":\"ADDRESS_EXPORT_INCR\",\"parameterNameValues\":{\"listOfParamNameValues\":{\"item\":[{\"name\":\"p_min\",\"values\":{\"item\":\"60\"}},{\"name\":\"p_start_date\",\"values\":{\"item\":\"2025-10-12 00:00:00 +0000\"}}]}}};type=application/json" https://xyz.sfp.ocs.oc-test.com/sfp11/bip/xmlpserver/services/rest/v1/reports/SFP%20Export%252FExport%20Reports%252FIncremental%252FADDRESS_EXPORT_INCR/run

Results:

You will receive all rows and columns for the time period you specified.