John6904392
Posts: 0
Joined: Sat May 31, 2014 8:56 am

Filtering external JSON data

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?

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Filtering external JSON data

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.

John6904392
Posts: 0
Joined: Sat May 31, 2014 8:56 am

Filtering external JSON data

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

Yurii Orishchuk
Posts: 0
Joined: Fri Feb 14, 2014 8:20 am

Filtering external JSON data

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.

Return to “Issues”