Common Data Service Trigger Filter

Like (0) Share

Report

Posted on 2 Sep 2020 23:38:00 by SeanHenderson

1,104

Hi,

I am using a Common Data Service Current Environment Connector. I have a trigger for each time a new lead is created. For the filter on the trigger, I want to get records created by a certain owner. So Filter expression I have:

ownerid eq "guid" where guid is the userid for the user I want to filter for.

Annotation 2020-09-02 173251.png

The error I get back is:

Exception parsing ownerid eq \"guid\" submitted for attribute filterexpression of callback registration. Target entity: lead. Exception: Microsoft.OData.ODataException: Syntax error: character '\"' is not valid at position 11 in 'ownerid eq \"guid\"'

I don't get why it's complaining about a \ that clearly isn't there.

Any ideas? Thanks.

All responses (4)

Answers (1)

Verified answer

SeanHenderson 1,104 on 03 Sep 2020 at 17:27:54

Like (0)

Report

Re: Common Data Service Trigger Filter

I figured it out. Don't wrap it in anything.
_ownerid_value eq ec12345-abc134-e1234-789e-e01234b6aa0c1
or whatever your guid is.
SeanHenderson 1,104 on 03 Sep 2020 at 17:04:50

Like (0)

Report

Re: Common Data Service Trigger Filter

@mequan

I switched to single quotes and got the error:
"Exception parsing _ownerid_value eq 'guid' submitted for attribute filterexpression of callback registration. Target entity: lead. Exception: Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'.
SeanHenderson 1,104 on 03 Sep 2020 at 16:34:12

Like (0)

Report

Re: Common Data Service Trigger Filter

I still get the same error:
"Exception parsing _ownerid_value eq \"guid\" submitted for attribute filterexpression of callback registration. Target entity: lead. Exception: Microsoft.OData.ODataException: Syntax error: character '\"' is not valid at position 18 in '_ownerid_value eq \"guid\"'.

There is no \ in my expression so I don't know where it's getting that from.
mequan on 03 Sep 2020 at 02:34:09

Like (0)

Report

Re: Common Data Service Trigger Filter

Hi @SeanHenderson ,

I think you may need field name '_ownerid_value' instead as https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/lead?view=dynamics-ce-odata-9.

CDS filter is same as CRM API filter.So you may try using CRM link to test filter first as https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api#filter-results.

Thanks

Community site session details

Common Data Service Trigger Filter

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Common Data Service Trigger Filter

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates