Forum | Appery.io

I have a REST GET call that returns all entries from my own REST service and populates a list with each item having 5 fields

What I want to do, is filter the list based off items that have their STATUS column = 2.

I'm trying to do it in the Before Send event using return {"STATUS":"2"}; in the query string in a variable called, 'where' that's mapped from a field called 'status' but I'm having no luck.

my GET service doesn't have a WHERE clause, it returns everything in the table, I figure I can filter on the app side somehow

what am I doing wrong?

bump

Hello Ryan,

Do you use Appery.io DB? If so - please add request parameter "where" to your service

NO, I wrote a .NET C# MVC Web API REST service that points to my MSSQL DB.

Please look this tutorial (paragraph 7): https://devcenter.appery.io/documenta...