LIST based off WHERE clause

[Ryan Keith]

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?

[Ryan Keith]

bump

[Serhii Kulibaba]

Hello Ryan,

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

[Ryan Keith]

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

[Serhii Kulibaba]

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