This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

UCCS API email filtering granularity

I'm wondering if anyone has had any exepreience with the REST API and filetering emails by the hour?

For example:

The following Query returns the entire days worth of email even though I'm looking for only the last hours worth...

var messages = await m_client.
For(x.EmailMessages).
WithinLast(1, RelativeDate.Hour).
Where(x.Direction == 2). //inbound, 3 is outbound
Select(x.Key, x.Sender.EmailAddress.DisplayName, x.Sender.EmailAddress.Name, x.SendDate, x.Subject, x.Recipients.EmailAddress.Name, x.Recipients.EmailAddress.Person.Department, x.Direction).
QueryAllAsync();

I have also tried using between with DateTimes that are hour lone with the same results... and help or suggestions are appreciated.

Top Replies

David.Cummings over 5 years ago in reply to David.Cummings +1 verified

Hello jnewman

UCA supports two types of queries, aggregate queries and object queries.

Your query is calling a object query and "selecting" additional fields.
Unfortunately, object queries…
David.Cummings over 5 years ago in reply to jnewman +1

I have more on this jnewman

You could try to add a second 'where' clause against the Message Date

(i.e. x.MessageDate) where >= $dateValue.

$dateValue would be a Powershell date that is computed…