Community
Showing results for 
Search instead for 
Do you mean 
Reply

OData filter on opportunity process

Highlighted
Copper Contributor
Posts: 189
Country: Netherlands

OData filter on opportunity process

[ Edited ]

How can I filter opportunities by process id? I've tried several things but none of them worked:

 

$filter=stage/process/id eq '2380e83d-cef4-4b6d-ad15-dc9a558431ab'

$filter=stage.process.id eq '2380e83d-cef4-4b6d-ad15-dc9a558431ab'

$filter=stage/process/id eq guid'2380e83d-cef4-4b6d-ad15-dc9a558431ab'

$filter=stage.process.id eq guid'2380e83d-cef4-4b6d-ad15-dc9a558431ab'

$filter=stage/process/name eq 'Act! Sales Cycle'
$filter=stage.process.name eq 'Act! Sales Cycle'

 

All with the following prefix:

 

/api/opportunities?$select=name&$expand=contacts,stage($expand=process)&$filter=contains(name, '' ) and 
Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 115
Country: USA

Re: OData filter on opportunity process

You can't filter by 'id', because Act! does not provide the API with metadata for that field, so it can't join on it. Will open a ticket for this.

 

 

However, you can filter on other columns:  This seems to work just fine:

 

/api/opportunities?$filter=(stage/process/name eq 'Act! Sales Cycle')&$select=name&$expand=contacts,stage($expand=process)