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

Query activities on a date range using Rest API

edited Feb 16, 2024 4:30PM in Sales 2 comments

Good morning,

We want to validate whether one of our collaborators has an activity or not in a date range using Rest API of for Sales and Fusion Service in Oracle Fusion Cloud Customer Experience.

What's going on?

Well, we have the following query, for example:

REST API call URL: https://hostname.oraclecloud.com/crmRestApi/resources/11.13.18.05/activities?q=OwnerEmailAddress="<OwnerEmail>";ActivityStartDate>=2018-07-23T15:00:00.000Z;ActivityEndDate<=2018-07-23T15:30:00.000Z&onlyData=true&fields=ActivityStartDate,ActivityEndDate

It returns the following result, as you can see, our collaborator has activities at that time, therefore he is busy:

But, if we ask for a time, between some activity, CX does not return results, which implies that the collaborator is available. Fact that is not true. See the following example, we made the same query, on the same day, but the only thing we changed was that we added 5 minutes at the beginning and subtracted 5 minutes at the end, the result being that our collaborator is available. See an example:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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