Unanswered

Flow error, Filtering Data with OData GUID

Like (0) Share

Report

Posted on 30 Jul 2018 08:58:17 by Yruiz

I need to filter all the records of the entity "Cases" that are of a specific "Project". For this I used the "Enumerate records" and in the ODATA query:

iav_proyectoid eq '@ {triggerBody ()? [' _ iav_proyectoid_value ']}'

This gives me an error that can not compare a string value with a GUID value. I also used the

iav_proyectoid eq guid '@ {triggerBody ()? [' _ iav_proyectoid_value ']}'

Giving me a syntax error.

I have tried these same queries in the quotes, with the + symbol, and nothing.

The question is: Using the "Enumerate Registers" of dynamics, you can do this type of ODATA queries: List all the records that have a given value of a lookup field?

Thank you so much

All responses (3)

Answers (0)

Hubertus 6 on 16 May 2024 at 14:34:26

Like (0)

Report

Re: Flow error, Filtering Data with OData GUID

Thank you, after spending hours on this issue I found your hint here. Thanks, Thanks, Thanks
sermormo 9 on 03 Jul 2019 at 17:12:05

Like (3)

Report

Re: Flow error, Filtering Data with OData GUID

Hello there,
I had a similar error during a ODATA user filter operation. In order to fixed, i had to removed the odata filter and look for the name of the field into the response. Doing that, I noticed that the lookup guid name have a different naming convention. So i had to modified the odata filter using the name convention listed on the response
Please find next the steps that i did to figure this out:
1. To Remove the odata filter and run the flow
2. To check the API resutl json, and copy the output json into a text editor.
3. To look for the guid value that i wanna filter. On my case i was filter opportunities based on ownerid. So i had to seek for ownerid.
4.Once i identifed the field name on the response i changed the name field found in the response with the one i was using on the filter criteria. On my case i have to change ownerid for _ownerid_value. e.g _ownerid_value eq '[GUID-IDENTIFIER]'
5. Test and run.

i hope this helps you to fix your issue.
Yruiz 29 on 30 Jul 2018 at 08:59:40

Like (1)

Report

Re: Flow error, Filtering Data with OData GUID