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.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

meelamri 13,216 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:

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No