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 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

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 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates