Page 1 of 1

Filtering external JSON data

Posted: Sat May 31, 2014 8:56 am
by John6904392

I am using a couple of JSON feeds from an external website in my app, and they are supplying data well. However, when I try to filter them, I simply get the full dataset rather than just the filtered results. I am using a where parameter and using the normal JSON data format as described in http://devcenter.appery.io/documentat...

Any ideas?


Filtering external JSON data

Posted: Sat May 31, 2014 9:31 am
by Illya Stepanov

Hi John,

The 'where' parameter shown in our docs is for use with Appery.io Database service.
As you're using an external resource, you should check if their service is accepting the filtering parameters, then you can add it in the settings request parameters.


Filtering external JSON data

Posted: Sat May 31, 2014 10:42 am
by John6904392

Thanks for the reply. The external resource is an ASP page that I have set up with the data. I will see what I can do to filter from the other end.

When I add a parameter in Appery, will it be added to the end of the URL as:
www.test.com/json_data.asp?parameter_name=variable_string


Filtering external JSON data

Posted: Tue Jun 03, 2014 1:06 am
by Yurii Orishchuk

Hi John.

If you using external data source you should use external datasource filtering system.

So you need to know about filtering in your external service and then pass needed parameters in appery.io service.

Also you can use filtering on client side(not recomended but could be used if no another way to do it on server side) with generic security context.

See details here: http://devcenter.appery.io/documentat...

Regards.