Stored procedures on free hosted version


#1

Hi,
is it possible to create stored procedures on the hosted edition?

Or alternatively is it possible to filter by two db fields via API?

Regards,

Robert


#2

Robert,

Hey - unfortunately, you’re not able to create stored procedures through the hosted edition. This is because access to phpmyadmin is not granted through the hosted system. You are able to call a stored procedure through the hosted DSP using GET and POST.

Thanks man,

  • Mark

#3

Hey Robert,

Regarding the second part of your question, you can filter with the API on multiple fields with AND / OR clauses and operators, same as you do with regular SQL filters. You can try it out in the API docs by entering your query string in the filter field e.g., age > 5 AND state = “MA”


Appery.io rest api help
#4

Hi,
thanks for your reply. The filtering works great!

Regards,

Robert


#5

cool, glad that helped :slight_smile: