1
Vote

oData Query for Activity for an Account

description

I am using this tool for creating oData Query for different requirements and working on Activity count but couldn't able to figure out the URL for OData for counting activity associated with Account.

For the activity , the relationship is little different because acitivityParty and activitypointer tables are involved behind the scene. can you please take a look and see if there is an easy way to do it??

https://testorg/xrmservices/2011/OrganizationData.svc/ActivityPointerSet?$filter=OwnerId/Id eq guid'xxxxxxxx-E5D5-xxxx-xxxx-9CB65494xxxx'

https://testorg/xrmservices/2011/OrganizationData.svc/ActivityPartySet?$select=ActivityId&$filter=ActivityPartyId eq guid'xxxxxxxx-0E20-xxxx-xxxx-2F6620C0xxxx'

Any assistance is greatly appreciated.

thanks,

Nick

comments