Syntax error ODATA Excel

(0) Share

Report

Posted on by Community Power Pla...

I need a help. Using simple odata sheet isn't enough for flow. I'm getting a lot of syntax errors.

I need:

filter=substringof(Name, ‘urn’)

For excel ODATA I got to the point It have to be filter substringof(Name, 'Urn') and I'm getting syntax error at position 18.

Thanks for help.

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (2)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Looks like your substring syntax is wrong. You need to specify startindex and length along with the string.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It's complete different function. It's ODATA. Not expression. Its not substring its substringOF. Please read more carefully 😉

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Thanks for the clarification. Yes for some reason I couldn't run substringof as FilterQuery.

The other alternative is use the Filter Array to filter the value

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

This works as well

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Here it says why it's not working

https://stackoverflow.com/questions/24994774/webapi-2-2-does-not-support-substringof-function

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Can you tell me where you found contains as ODATA query? I was told to use that:
https://help.nintex.com/en-us/insight/OData/HE_CON_ODATAQueryCheatSheet.htm

I would be grateful for showing me where I can find it. That was pretty obvious function and I was geting mad because "Contains should be sort of basic function!" and I couldn't find anywhere proof of existing that function.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

https://www.odata.org/getting-started/basic-tutorial/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

One more. I have new issue. I need to create <contains(name,'x') or contains(name,'y')> Its possible?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

I did tried now. It's not possible to have OR operator under contains. What you could do is try to set another List filter and combine both results into one.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thanks! From my experience filter array is bad direction. Because of performance. It's a lot of slower than using ODATA. I'm more into making parallel listing with ODATA.

Was this reply helpful? Yes No