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)

Sort by

Verified answer

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!
Hi,

please refer to this example:
Suggested answer

Torrado 1,270 on at

Like (0)

Report
Copy link

Link copied!
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.
TerryShowman 60 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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.