Service Request API Fails With Error: Unable to create criteria item from node: "LastUpdateDate"
(Doc ID 2536552.1)
Last updated on AUGUST 05, 2022
Applies to:
Oracle Fusion CX Sales Cloud Service - Version 11.13.19.01.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.19.01.0 version, CX Integration
The Service Request REST API get calls are failing with the following error:
Error: 400 Client Error 'Failed to build ViewCriteria from expression "LastUpdateDate >=\'2019-04-04T00:00:00Z\' and LastUpdateDate<\'2019-04-05T00:00:00Z\'" using view object ServiceRequestRest. Unable to create criteria item from node: "LastUpdateDate". Unable to create criteria item from node: "LastUpdateDate". '
REST API call details:
Headers: {'Content-Type': 'application/json', 'REST-Framework-Version': '2', 'Accept': '*/*', 'User-Agent': 'python-requests/2.11.1', 'Accept-Encoding': 'gzip, deflate', 'Connection': 'keep-alive'}
URL: https://<pod_name>.crm.us6.oraclecloud.com:443/crmRestApi/resources/latest/serviceRequests?onlyData=true&fields=SrId%2CSrNumber%2CTitle%2CAccountPartyUniqueName%2CAssigneePersonName%2CLastUpdateDate%3B&q=LastUpdateDate%20%3E%3D%272019-04-04T00:00:00Z%27%20and%20LastUpdateDate%3C%272019-04-05T00:00:00Z%27&totalResults=true&orderBy=SrNumber%3Aasc&offset=0&limit=500
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |