Forum | Appery.io

my collection like below.

I follow your tutorials to set the POST service and "where" parameter,also return the localstorage variables from previous page.

If user select Asia,it will show country"Taiwan"、"Japan"、"Hongong" ,besides "Europe1".
did I set something wrong?
thanks!!

You are querying right? Then your Method should be GET and not POST.

For testing use a hard coded value for where parameter and check the result. Once it is confirmed that it works, then substitute the variable or use the value from a UI / Input component

Hi Spark,

You have two solutions:

1. Use "GET" method instead of "POST".

2. If you want to use "POST" method - move "where" request parameter to "body" section of the request tab.

   Regards.

Yurii
Thanks for your help!!!
I will try it later,and will let you know does it work!!!

Yurii
Thanks for your help.
It is work!!

Yurii
I try it by " GET" way,it will show error message like below.
{
"status":400,
"uri":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"BCXX002",
"description":"Cannot consume content type"
}
}

One more thing need your help,when I gat the response value like Japan,can I also get another column's info of the same value?

Hi Spark,

Please check if you have in "get" method in request-headers "content-type" header - delete it.

Also if you still have this problem show us your service all tabs screen shots.(request tab subtabs too).

Thanks.

1、settings

2、Request Headers

3、Request Query String

4、Response Body

5、test

If you are testing it on your browser you need to enable appery proxy

Hi Spark,

Please follow this solution:

1. Open service "request tab".

2. Open "headers" subtab.

3. Add there following parameter:

   Content-Type application/json

   Details: http://prntscr.com/63o6nb/direct

   Regards.