Issue with "Perform Advanced Search" in HCM Data Loader Data Sets API returning invalid Date Format
Summary:
When using the GET API —
/hcmRestApi/resources/11.13.18.05/dataLoadDataSets —
the “Creation Date” appears in this format:
2025-10-28T05:30:38+00:00.
However, when using the Advanced Search Query, the “Creation Date” appears as:
10/28/25.
POST API —
/hcmRestApi/resources/latest/dataLoadDataSets/action/findByAdvancedSearchQuery
Request Payload:
{"displayFields": ["DataSetId", "DataSetName", "ContentId", "CreatedBy", "CreationDate", "LoadStatusCode", "ImportStatusCode", "TransferStatusCode"],
"sort": [{"name": "CreatedBy","direction": "desc"}],
"filters": [{"name": ["CreatedBy"],"values": ["Test User"]}]}
Is there a way to retrieve it in the same format as the API (2025-10-28T05:30:38+00:00)?
The use case involves retrieving all requests made within the last 5 minutes and processing them in OIC. Without the date format, it will not be possible to filter the request IDs accurately.