Forum | Appery.io

I have set up a server and have made connection with mysql db through APIexpress.
I want to use a where clause but can't get it to work.

i used this as an example : https://devcenter.appery.io/documenta...

But now when i test it with whatever value it gives the following error (in the APIexpress tab) :
"{
"code": "MS009",
"message": "Incorrect server configuration",
"status": "INTERNAL_SERVER_ERROR"
}"

Type = GET

Query parameter =
typeRapport

SQL statement =
select from invBeoordKenmerken where typeRapport = :typeRapport

Query Params (underneath SQL) =
queryParams.typeRapport

Any help would be much appreciated...

never mind, i must have had a setting wrong, after trial number so many it now works.

Great! Thank you for update.

I'm having the same issue - what exactly did you change in order to get it to work?

Is your examples above correct? I'm following the help document as well, but seems I'm missing something.

I posted here as well - https://getsatisfaction.com/apperyio/...

Anyone got around this issue? I'm stumped. Need help? Is it something i'm doing wrong or a bug with API Express platform?