Share via

Odata filter with Oracle Get Rows

Priepke, Hans 96 Reputation points
2021-11-23T18:36:15.39+00:00

I'm having some trouble trying to work with the oracle connector in a logic app. I'm able to get an example setup where I can use Get Rows against a table (or a view, even though it says views are not supported). I get all rows back. Great, but I need to filter that query down a bit. Trying to use an odata filter option, I get "BadRequest. Http request failed: the content was not a valid JSON." An example of how it is written is attached, it works fine if I take the filter query out.

Anyone have any idea of what I'm doing wrong here?

151933-azure-logic-app-oracle-getrows-odata-filter.jpg

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,904 questions
0 comments
Accepted answer
  1. Priepke, Hans 96 Reputation points
    2021-11-23T19:36:05.58+00:00

    Actually, I solved my own issue. When I added the entire value of the item to the email so I could see the data more directly, I noticed that the studentid column was in UPPER case - probably due to it being Oracle and our database settings. Once I changed by odata filter expression to use UPPER case to match, it started filtering.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest