I am looking for some guidance around URL parameter formatting....
I have an asprunner.net site which has REST API enabled, and in which there is a query and list form called handout.
using okhttp to encode the url, this get call works just fine:
url="http://xxx-001-site5.btempurl.com/api/v1?table=handout&action=list&q=(fullname~contains~Test )";
as does this
url="http://xxx911-001-site5.btempurl.com/api/v1?table=handout&action=list&q=(locid~equals~22 )";
But i need to do is combine both variable queries, so locid=22 AND fullname contains Test, and I cannot find any resources that guide as to the accepted format, and nothing I have tried works. You arent allowed to have more than one q= , and none of the following work for example:
url="http://xxx-001-site5.btempurl.com/api/v1?table=handout&action=list&locid=22&q=(fullname~contains~Test)";
url="http://xxx-001-site5.btempurl.com/api/v1?table=handoutt&q=(fullname~contains~Test~and~locid~equals~22 )";
url="http://xxx-001-site5.btempurl.com/api/v1?table=handoutt&q=(fullname~contains~Test)&(locid~equals~22 )";
(when I say dont work, the api completely ignores the q= section and returns the full dataset
In the absence of finding any documentation I have run out of permutations to try and guessing rarely works! Strangely I cant even find the documentation that included the use of ~contains~ and it doesnt seem to be anywhere on Mr Google but it does work!
I have looked at okhttps urlbuilder, but it doesnt seem to cater for q=
I hope it is possible to have more than one query variable parameter - can anyone guide me as to the correct syntax
Many thanks DAvid
