Unanswered

SQL - Get Rows V2 - Why does my filter query not work

(1) Share

Report

Posted on by dukatz

165

I'm trying to do a simple filter query on my rows where all rows get returned where 'key' starts with generic. So in SQL I would use key LIKE 'generic%' But I get an error. Is there a documentation about which syntax is supported by the connector?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

dukatz 165 on at

Like (0)

Report

So the Problem is, the Connector doesn't use SQl queries but ODATA queries Query options overview - OData | Microsoft Learn.

In my case startswith(key,'generic') was the solution.

Was this reply helpful? Yes No
Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report

SQL connector doesn't use T-SQL for sintax. it use ODATA for queries. If you want to still using T-SQL, i would recommend that you use store procedure and send the data as parameter to be user in the way that you like.

Was this reply helpful? Yes No