Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Filtering the Results of Rest API — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filtering the Results of Rest API

Received Response
edited Mar 23, 2018 7:38AM in Configure Price Quote 2 comments


How to add the filters to REST call to reduce the number of recordsi n the result


To retrieve transaction data filtered by date in the REST API request, I am trying to use the following REST url:

https://instance URL/rest/v5/metadata-catalog/commerceDocumentsOraclecpqoTransaction/"q":"{'createdDate_t':{$gt:'06/01/2017'}}"

However, I am getting an error.

"Child resource \"q\":\"{'createdDate_t':{$gt:'06 doesn't exist or is not accessible in Resource commerceDocumentsOraclecpqoTransaction for current user."

I can confirm the the attribute 'createdDate_t' is available in the relevant commerce process.

Could you please suggest the correct way and pointer to more study material on this?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!