Filtering in API call

ismaelDev

Hi All, I have a problem while I'm trying to get filtered data from API, I have configured an API method so I can have all the tickets without any problem, but when I add a filter so I can get only closed or opened tickets, It still shows all the tickets instead of the filtered ones, here is an image:

And below an image of a ticket with "closed": false, when the url ask for ticket.closed=true

Maybe there is an error in the way a do the call, I searched for any example in the REI3 docs but I didn't find it
http://localhost:14000/api/lsw_tickets/get_tickets/v1?ticket.closed=true

Would you give me an example of how to call correctly a method filtering, or how to correctly add a filter in the builder app, or both if I made a mistake in both processess,

Today I can get all the tickets, or get ticket by id without any problem, Please your help!

As always.... Thank you all!!!

gabriel

Your filters are problematic as the first line 0) ticket.id ILIKE fixed value [EMPTY] should either always match or never match (can´t test right now, but its nonsensical). As the first filter line is nonsense and combines the second one with an OR operator, the second filter line will not work as you expect.

You can remove the first filter line - it does not do anything but either always remove all records or show all records. If you remove it, the second filter line 0) ticket.closed = true will work as you expect. Though you should use the operator TRUE value instead of fixed value to compare against a boolean in your second filter line.

Regarding filtering the API call via GET parameter, you cannot. Right now our API feature does not support filtering via getters. It is on our wishlist but does not have an ETA.

Currently if you want to either get closed tickets or not closed tickets, you need 2 APIs. One filters for closed the other filters for not closed.

ismaelDev

I really appreciate your response, You are right, so now I have 3 versions, first for all tickets and by id, 2nd for opened tickets and 3rd for closed tickets, and IT WORKS!!!!!!
Once again....Thank You!