AP CPI integration - Query filter conditions and null date&time issue!

[amer_alsharif]

Hi Experts,

I am trying to get business partner list of records that created or modified within specific date and time duration.

Example: get all business partners from system that created between 1-1-2025 10:00AM to 1/2/2025 11:00AM  or last changed on 1-1-2025 10:00AM to 1/2/2025 11:00PM

Notes: -

1. SAP business partners thurogh CPI integration has 4 fields for creation date or updated date:

"CreationDate": "2025-01-20T00:00:00.000",
"Customer": "21600031",
"LastChangeDate": "2025-01-21T00:00:00.000",
"BusinessPartner": "21600031",
"CreationTime": "1970-01-01T11:11:16.000",
"LastChangeTime": "1970-01-01T08:45:20.000",

2. LastChangeDate or LastChangeTime will be null in SAP system unless the record is not changed.

My CPI Query option filter is:

$select=Customer,BusinessPartner,Supplier,CreationDate,CreationTime,LastChangeDate,LastChangeTime&$filter=CreationDate ge datetime'${property.CreationDate}'
and (LastChangeDate ne null) or LastChangeDate ge datetime'${property.LastChangeDate}'

when try to consume the cpi return bad request.

Please support by write the right query option filter in order to get all business partners within a specific creation or updating date&time and ignoring the null last change datetime records.

refer to screenshot.

Thanks.