on 11-03-2020 8:21 AM
Hi,
When sending a Get request to Service Layer, I passed a long filter. something like
$filter=startswith(Table/Field,'A1') or startswith(Table/Field,'A2') ....
SL returns me error
{
"error": {
"code": 201,
"message": {
"lang": "en-us",
"value": "Not supported query option: Mismatched parentheses"
}
}
}
I believe this is because my query string is too long ( >2200 characters)
When I remove some of the filter until it is abt 2050, the request is successfull.
Is there anywhere we can set the maximum length of the query params?
Regards
Edy
Hi, Edy.
For your specific questions, no. There is no configuration for that.
That aside, such a big URI is usually a bad idea. There is a nice diiscussion here and there are several other articles explaining why you should keep it below 2000 characters.
If you can't make a shorter query, maybe a semantic layer would be better (and faster) ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ralph,
Since my long filter are lists of 'or', I split it up and made multiple calls.
I have another post about comparing of NTEXT in filter. If you have time for a suggestion please?
Regards
Edy
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.