Hi! I have one service that connects to a MySQL database, and I want to fetch records using a filter with two fields. Basically, I’m doing the request like this: http://dsp_url/api/v2/service/_table/tablename?filter=[field1='value1' AND field2='value2'] (I’m using test_rest.html utility, that’s w…

Problem fixed. The problem were the missing parenthesis. Here is the correct query: http://dsp_url/api/v2/service/_table/tablename?filter=(field1%3D'value1')%20AND%20(field2%3D'value2') The clue came from here: Service Type list missing after update to 2.04/ admin 2.06 Considering the need for pa…

Filter in a GET request not working for more than one parameter

REST API

formerstaff August 3, 2016, 3:29pm 11

Closing this thread. The discussion has moved to Is there support for filtering WHERE x LIKE y?

Topic		Replies	Views
Unable to filter SQL using AND REST API	1	1460	April 5, 2016
Invalid or unparsable field in filter request REST API	2	3203	January 19, 2016
Querying records with multiple filters Client SDKs	1	3791	August 8, 2016
Losing http sent filters when adding role filter REST API	9	1853	October 11, 2014
Service Type list missing after update to 2.04/ admin 2.06 REST API	5	2831	January 28, 2016

Filter in a GET request not working for more than one parameter

Related topics