Forum | Appery.io

I am making a request to the database using the distinct operator and am getting a bad request returned when I post the request directly into a browser I get:
'The request sent by the client was syntactically incorrect ().' The request looks like:

https://api.appery.io/rest/1/db/colle...

If I remove the 'where' section from the request I still get the error so the problem what is the correct syntax for this type of request.

Hi Joe -

Have you tried this query in your database “Query” section? Is it works?
:: http://devcenter.appery.io/documentat...

Hi Illya,

Sorry it has taken me some time to get back to you, I have attempted to repeat the query from a test app and I still get the same error.

{
"status":400,
"uri":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"BCXX002",
"description":"Cannot consume content type"
}
}

Hi Joe,

Is your collection secure or not? Please check at Security and permission tab of collection. And could you share print screen with your query from test app please?

Hi
The collection is not set to secure! below is an image of the test tab on the service.

Hi Joe -

Please share your app and tell us its name and describe steps how to reach your service in it.

The app is shared and is named popuptest. There is only one service in the app.

Joe - please enter your session token in Headers parameters of your list service:

Hi I have included the session token, in the mapping (I have logged on with another application which includes login page and provides a valid token.) I get exactly the same response!

Hi, I have added a button to the form which will log the user in to a test account!