How to query activities by it's regarding object ODATA/Fetch?

(0) Share

Report

Posted on by TerryShowman

How could I make a query for activities but filtering by regarding object. I mean there are activities regarding to lead, opportunitites, with odata or fetchXml

if I'd like to filter those regarthing to leads.

I've tried something like activitypointers?$select=activityid&$filter=_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname eq 'lead' but no works. Any help. thanks.

All responses (4)

Answers (1)

Suggested answer

Torrado 1,270 on at

Like (0)

Report

RE: How to query activities by it's regarding object ODATA/Fetch?

Hello Terry,

With one of the tools that I suggested above you can create / test your fetchxml queries.

FetchXMLBuilder is a XRMToolbox plugin, you can easily connect to your environment and use it to check that kind of scenarios.

Hope this helps you.
TerryShowman 60 on at

Like (0)

Report
RE: How to query activities by it's regarding object ODATA/Fetch?

Hi ty, if I'd like to hake two entities could i use this?

for Opportunities and leads? or I must separate them?

Thanks.
Suggested answer

Torrado 1,270 on at

Like (0)

Report
RE: How to query activities by it's regarding object ODATA/Fetch?

Hello,

for that kind of requirement, where you need to build a fetchxml or odata query, you can make use of two useful tools:

FetchXML Builder

CRMRestBuilder

Hope this helps you.

Please mark the answer as verified if helpful. That will help others in future.
Verified answer

meelamri 13,206 User Group Leader on at

Like (0)

Report
RE: How to query activities by it's regarding object ODATA/Fetch?

Hi,

please refer to this example: