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

REST API Need to Filter Activities by Child ActivityAssignee LastUpdateDate

edited Jan 7, 2021 5:25AM in Sales 10 comments

Content

We are trying to filter acitvities based on the LastUpdateDate.

This works fine where the Acitvity Object has been updated.  

https://cagp-test.crm.us2.oraclecloud.com:443/crmRestApi/resources/latest/activities?onlyData=true&expand=ActivityAssignee,ActivityContact&fields=ActivityAssignee:AssigneeId,ResponseCode,AssigneeName,PrimaryEmail,ActivityAssigneeId,AssigneePartyNumber,LastUpdateDate,UserName&q=LastUpdateDate>2021-01-07T01:55:37.637Z

However the problem is that when an activity assignee is modified, the LastUpdateDate is not set on the parent activity record.

We need to query activities based on the LastUpdateDate of the child ActivityAssignee record. How do we represent this in REST? have tried setting the q=ActivityAssignee:LastUpdateDate>2021-01-07T01:55:37.637Z.... however this fails

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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