Enhanced Filtering Options for Data Extract API

We’ve enhanced the Oracle Data Extract API to provide you with greater flexibility when retrieving data from your warehouse management system. You can now use both create_ts_gt and mod_ts_gt filters in a single API request for dual timestamp filtering.

• Expanded Results: Records matching either of the timestamp conditions (created or modified after the specified times) will be included in your extract. This offers a broader and more efficient way to capture relevant data changes.
• OR Logic: When both filters are provided, records will be returned if they meet either the creation time or modification time criteria.

As before, the optional status_id__lt filter can be used if the entity contains a status ID column.

Now you can Easily capture any data created or modified since your last extract, without having to make multiple requests. This allows you to tailor extracts to suit a wider range of data management and reporting scenarios.

URL

wms/lgfapi/v10/data_extract/push_to_object_store

EXAMPLE PAYLOAD

{
    "options": {
        "file_size_in_mb": "10",
        "endpoint": {
            "name": "Extract_OCI",
            "object_store_path": "26A/Oct23_1"
        },
        "file_format": "json",
        "compressed": "0",
        "unique_identifier": "Data_extract_group_Oct23_1"
    },
    "parameters": {
        "entities": [
            {
                "entity": "work_order_type",
                "fields": "activity_type_id,autocreated_wo_backflush_flg,company_id,create_ts,create_user,description,id,mod_ts,mod_user,partial_allocation_flg,work_order_type",
                "filter": {
                    "mod_ts__gt": "2020-10-10T00:00:00.000",
                    "create_ts__gt": "2021-10-10T00:00:00.000"
                }
            },
            {
                "entity": "load",
                "fields": "act_arrival_ts,act_departure_ts,bol_nbr,carrier_id,company_id,create_ts,create_user,cust_field_1,cust_field_10,cust_field_2,cust_field_3,cust_field_4,cust_field_5,cust_field_6,cust_field_7,cust_field_8,cust_field_9,document_notification_email,driver,est_departure_ts,externally_planned_load_nbr,facility_id,first_gdr_nbr,first_load_ts,freight_class,id,last_load_ts,load_nbr,mod_ts,mod_user,pro_nbr,route_nbr,sched_delivery_ts,seal_nbr,status_id,total_shipping_charge,total_volume,total_weight,trailer_id,trailer_type_id,type",
                "filter": {
                    "mod_ts__gt": "2020-10-10T00:00:00.000",
                    "create_ts__gt": "2022-10-10T00:00:00.000",
                    "status_id__lt": "90"
                }
            }
        ]
    }
}

Steps to Enable and Configure

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.