string filters in the API (groovy)

Separate your problems by getting it to work in postman first. Then you’ll know if the problem is syntax in groovy or syntax in the api call itself.

{{url}}/setting/admins?filter=status:"active"

This ^^ works for me in postman.

So, you just want your url string to result in that same thing:

resourcePath = "/setting/admins"
queryParams = "offset=${offset.toString()}&size=1000&filter=status:\"active\""
url = "https://${account}.logicmonitor.com/santaba/rest${resourcePath}?${queryParams}"
println(url)

I took this url and popped it into postman and it worked just fine.

Are you getting an authentication error? Is it possible you’re not calculating your signature properly?

Joe’s answer should be marked as the right answer. I can’t believe i forgot about that, but i probably built the encoder into my query param handler function. FWIW: if you encode just the value portion of each query parameter, then join together with the key, then join each key value pair together, it should work cleanly. I get it if you don’t want to do that.

Stuart,

I dont think its an auth error, because without filters, I'm getting back all my users and I can loop through. And I can even add filter= onto the end with nothing there, and that works. I can even do other filters and get back the responses I expect, such as filter=id:1234 for my user id. I can even do status:11111 just to show that my string overall works, and that its just the value for status I cant get right as a string.

But as soon as I do filter=status:"active" then I get a string error.

Yours: {{url}}setting/admins?filter=status:"active"
Mine:  {{url}}setting/admins?size=1000&offset=0&filter=status:"active"

You can see below (company redacted) that its some kind of illegal character when I'm using groovy to do the http get. I admit I'm stumped.

The script failed, elapsed time: 0 seconds - Illegal character in query at index 93: https://REDACTED.logicmonitor.com/santaba/rest/setting/admins?size=1000&offset=0&filter=status:"active"
java.lang.IllegalArgumentException: Illegal character in query at index 93: https://REDACTED.logicmonitor.com/santaba/rest/setting/admins?size=1000&offset=0&filter=status:"active"
    at java.base/java.net.URI.create(URI.java:883)
    at org.apache.http.client.methods.HttpGet.<init>(HttpGet.java:66)
    
I appreciate the help, and I know its rough with people just asking you do debug their junk. :)

I was hoping I was doing something fundamentally wrong with the URL and etc itself, but I think mine matches yours for the filter syntax. So I'm stumped. :)

Thanks!
 

Thanks, that worked out for me. I had to hard code the %3A and %22, but it worked perfectly. When I tried to use some html escape package, it also converted the & to the html notation, which made the filter NOT work. But if I leave the ampersand as-is and manually do the rest, it works brilliantly.

Thanks to both of you!!!

Sounds like a good idea, I’ll give it a shot.

Thanks Stuart, and thanks Joe!

Could someone please post an example of the expected encoding when using advanced filters (customProperties in my case). I am using C# btw.

See REST API Advanced Filters | LogicMonitor

Regards,

Andrew