Search with +group rule getting error response

mecmav · 2020-01-24 22:16:21

Hello,

I need do a specific search by API to return some tickets.

This is I trying in Postman:

http://MYIP/apirest.php/search/Ticket?is_deleted=0&as_map=0&criteria[0][link]=AND&criteria[0][field]=9&criteria[0][searchtype]=notequals&criteria[0][value]=10&criteria[1][link]=AND&criteria[1][criteria][0][link]=AND&criteria[1][criteria][0][field]=5&criteria[1][criteria][0][searchtype]=equals&criteria[1][criteria][0][value]=1408&criteria[1][criteria][1][link]=OR&criteria[1][criteria][1][field]=5&criteria[1][criteria][1][searchtype]=equals&criteria[1][criteria][1][value]=865&criteria[1][criteria][2][link]=OR&criteria[1][criteria][2][field]=5&criteria[1][criteria][2][searchtype]=equals&criteria[1][criteria][2][value]=3062&search=Pesquisar&itemtype=Ticket

Error response: [
"ERROR",
"Critério de busca mal formulado.; ver documentação em seu navegador em http://MYIP/apirest.php/#ERROR"
]

This is my URL of GLPI GUI:

http://MYIP/front/ticket.php?is_deleted=0&as_map=0&criteria%5B0%5D%5Blink%5D=AND&criteria%5B0%5D%5Bfield%5D=9&criteria%5B0%5D%5Bsearchtype%5D=notequals&criteria%5B0%5D%5Bvalue%5D=10&criteria%5B1%5D%5Blink%5D=AND&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Blink%5D=AND&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bvalue%5D=1408&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Blink%5D=OR&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bvalue%5D=865&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Blink%5D=OR&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bvalue%5D=3062&search=Search&itemtype=Ticket&start=0&_glpi_csrf_token=3dfca9c393921fd8d185cc88677626d3

It's the same way like GLPI GUI, only change the "%5b" and "%5d" by "[" and "]" respectively to run in Postman, but the error response it's the same.

Here an image to ilustrate glpi screen about what I'm talking:

https://ibb.co/qxgSFN2

How can I make this request correctly?

Last edited by mecmav (2020-01-24 22:17:59)

mecmav · 2020-01-24 22:43:02

Update:

I've try convert the entire URL --> http://MYIP/front/ticket.php?is_deleted=0&as_map=0&criteria%5B0%5D%5Blink%5D=AND&criteria%5B0%5D%5Bfield%5D=9&criteria%5B0%5D%5Bsearchtype%5D=notequals&criteria%5B0%5D%5Bvalue%5D=10&criteria%5B1%5D%5Blink%5D=AND&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Blink%5D=AND&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B0%5D%5Bvalue%5D=1408&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Blink%5D=OR&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B1%5D%5Bvalue%5D=865&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Blink%5D=OR&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bfield%5D=5&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bsearchtype%5D=equals&criteria%5B1%5D%5Bcriteria%5D%5B2%5D%5Bvalue%5D=3062&search=Search&itemtype=Ticket&start=0&_glpi_csrf_token=004a73c7619d4ebe2c37e56402b2ef13

from glpi GUI in this website: https://www.url-encode-decode.com/

and returns the URL to put in Postman.

Now when I try run this request, not get an error, but still in Login Page.

A image ilustrating this:

https://ibb.co/7JMj95B

And the response in login screen:

https://ibb.co/bgfkmJx

Need some help to understand this and solve.

Thanks for now.

LaDenrée · 2020-01-24 23:04:54

Try To remove &search=Pesquisar&itemtype=Rocker at url end

mecmav · 2020-01-25 03:07:32

After try, try and try, I have a different error.

Using all these criterias

criteria[0][link]:AND
criteria[0][field]:9
criteria[0][searchtype]:notequals
criteria[0][value]:10
criteria[1][link]:AND
criteria[1][criteria][0][link]:AND
criteria[1][criteria][0][field]:5
criteria[1][criteria][0][searchtype]:equals
criteria[1][criteria][0][value]:1408
criteria[1][criteria][1][link]:OR
criteria[1][criteria][1][field]:5
criteria[1][criteria][1][searchtype]:equals
criteria[1][criteria][1][value]:865
criteria[1][criteria][2][link]:OR
criteria[1][criteria][2][field]:5
criteria[1][criteria][2][searchtype]:equals
criteria[1][criteria][2][value]:3062

I get a response ["ERROR", "Malformed search criteria; view documentation in your browser at http://MYIP/apirest.php/#ERROR"

And when using only the first criteria

criteria[0][link]:AND
criteria[0][field]:9
criteria[0][searchtype]:notequals
criteria[0][value]:10

I got a correct response..

Now when I try use more criterias from here

criteria[1][link]:AND
criteria[1][criteria][0][link]:AND
criteria[1][criteria][0][field]:5
criteria[1][criteria][0][searchtype]:equals
criteria[1][criteria][0][value]:1408
criteria[1][criteria][1][link]:OR
criteria[1][criteria][1][field]:5
criteria[1][criteria][1][searchtype]:equals
criteria[1][criteria][1][value]:865
criteria[1][criteria][2][link]:OR
criteria[1][criteria][2][field]:5
criteria[1][criteria][2][searchtype]:equals
criteria[1][criteria][2][value]:3062

Always returns error "malformed search".

It's possible to get response using that search like explained on the start of this post??
The example I'm referring is in this link https://ibb.co/qxgSFN2

Or my criterias are really setted wrong?

mecmav · 2020-01-25 03:24:40

Using with backslashes like this

?criteria\[0]\[link]=AND&criteria\[0]\[field]=9&criteria\[0]\[searchtype]=notequals&criteria\[0]\[value]=10&criteria\[1]\[link]=AND&criteria\[1]\[criteria][0][link]=AND&criteria\[1]\[criteria][0][field]=5&criteria\[1]\[criteria][0][searchtype]=equals&criteria\[1]\[criteria][0][value]=1408&criteria\[1]\[criteria][1][link]=OR&criteria\[1]\[criteria][1][field]=5&criteria\[1]\[criteria][1][searchtype]=equals&criteria\[1]\[criteria][1][value]=865&criteria\[1]\[criteria][2][link]=OR&criteria\[1]\[criteria][2][field]=5&criteria\[1]\[criteria][2][searchtype]=equals&criteria\[1]\[criteria][2][value]=3062

returns all tickets

{
"totalcount": 151,
"count": 20,
"sort": 1,
"order": "ASC",
"data": .......
}

It's like the criterions don't be applied... Can I How fix this?

LaDenrée · 2020-01-25 18:25:21

writing query like this seems to work ( i guess problem comes from carriages return)

$url="/search/Ticket/";
$url .="?criteria[0][link]=AND&criteria[0][field]=9&criteria[0][searchtype]=notequals&criteria[0][value]=10";
$url .="&criteria[2][link]=AND&criteria[2][criteria][0][link]=AND";
$url .="&criteria[2][criteria][0][field]=5&criteria[2][criteria][0][searchtype]=equals&criteria[2][criteria][0][value]=1408";
$url .="&criteria[2][criteria][1][link]=OR&criteria[2][criteria][1][field]=5&criteria[2][criteria][1][searchtype]=equals&criteria[2][criteria][1][value]=865";
$url .="&criteria[2][criteria][2][link]=OR&criteria[2][criteria][2][field]=5&criteria[2][criteria][2][searchtype]=equals&criteria[2][criteria][2][value]=3062";

mecmav · 2020-01-25 20:51:36

LaDenrée wrote:

writing query like this seems to work ( i guess problem comes from carriages return)

$url="/search/Ticket/";
$url .="?criteria[0][link]=AND&criteria[0][field]=9&criteria[0][searchtype]=notequals&criteria[0][value]=10";
$url .="&criteria[2][link]=AND&criteria[2][criteria][0][link]=AND";
$url .="&criteria[2][criteria][0][field]=5&criteria[2][criteria][0][searchtype]=equals&criteria[2][criteria][0][value]=1408";
$url .="&criteria[2][criteria][1][link]=OR&criteria[2][criteria][1][field]=5&criteria[2][criteria][1][searchtype]=equals&criteria[2][criteria][1][value]=865";
$url .="&criteria[2][criteria][2][link]=OR&criteria[2][criteria][2][field]=5&criteria[2][criteria][2][searchtype]=equals&criteria[2][criteria][2][value]=3062";

I can't urderstand a way to do it with Postman, So I do it directly in the code like you say, but get same error: Malformed criteria.

Update: I think it's because

$url .="?criteria[0][link]=AND&criteria[0][field]=9&criteria[0][searchtype]=notequals&criteria[0][value]=10";
$url .="&criteria[2][link]=AND&criteria[2][criteria][0][link]=AND";

goes from criterion 0 to 2 instead of 1

here my code

$api_url_glpi='MYGLPI/apirest.php'; 

...

initSession...
getFullSession...

$url_search="/search/Ticket/";
$url_search.="?&criteria[0][link]=AND&criteria[0][field]=9&criteria[0][searchtype]=notequals&criteria[0][value]=10";
$url_search.="&criteria[1][link]=AND&criteria[1][criteria][0][link]=AND";
$url_search.="&criteria[1][criteria][0][field]=5&criteria[1][criteria][0][searchtype]=equals&criteria[1][criteria][0][value]=1408";
$url_search.="&criteria[1][criteria][1][link]=OR&criteria[1][criteria][1][field]=5&criteria[1][criteria][1][searchtype]=equals&criteria[1][criteria][1][value]=865";
$url_search.="&criteria[1][criteria][2][link]=OR&criteria[1][criteria][2][field]=5&criteria[1][criteria][2][searchtype]=equals&criteria[1][criteria][2][value]=3062";

$url_search_complete=$api_url_glpi.$url_search;

echo "\n".$url_search_complete;

Here my result with the error: https://ibb.co/RBtc4vJ

After correct the criterion from 0 to 1, in GLPI GUI I get all tickets with this search.
But by API, getting Malformed search criteria

Last edited by mecmav (2020-01-27 14:43:13)

mecmav · 2020-01-27 17:19:24

Anyone can help with this ?

Nobody never had "Malformed search criteria"?

Searching about this error, nearly haven't topics or results about that.

mecmav · 2020-01-27 20:48:09

Update: using a test GLPI 9.4.5 this request returns all tickets that I want.

Why is not possible in 9.4.2?

LaDenrée · 2020-01-27 21:20:11

ithink there was a bug in 9.4.2 fixed by :
https://github.com/glpi-project/glpi/pull/5889

see changelog.

mecmav · 2020-01-28 14:04:07

LaDenrée wrote:

ithink there was a bug in 9.4.2 fixed by :
https://github.com/glpi-project/glpi/pull/5889
see changelog.

Thanks by the useful answer.

I applied this commit, and now returning correct response with desired tickets.

It's was really a bug and the fix works to me.

Thanks again!

Last edited by mecmav (2020-01-28 14:35:31)

Forum GLPI-Project

Announcement

#1 2020-01-24 22:16:21

Search with +group rule getting error response

#2 2020-01-24 22:43:02

Re: Search with +group rule getting error response

#3 2020-01-24 23:04:54

Re: Search with +group rule getting error response

#4 2020-01-25 03:07:32

Re: Search with +group rule getting error response

#5 2020-01-25 03:24:40

Re: Search with +group rule getting error response

#6 2020-01-25 18:25:21

Re: Search with +group rule getting error response

#7 2020-01-25 20:51:36

Re: Search with +group rule getting error response

#8 2020-01-27 17:19:24

Re: Search with +group rule getting error response

#9 2020-01-27 20:48:09

Re: Search with +group rule getting error response

#10 2020-01-27 21:20:11

Re: Search with +group rule getting error response

#11 2020-01-28 14:04:07

Re: Search with +group rule getting error response

Board footer