Leading % in LIKE filter for ION API requests is not being recognized

Waylon Smith · 2025-05-08T16:14:20+00:00

There was an error rendering this rich post.

Hi, I am encountering an issue where when I provide a LIKE statement in a filter query parameter for an ION API request, the leading ampersand wildcard is not being recognized. I have provided screenshots below for various cases:

Image 1: Like statement with no leading wildcard returns a record as expected.

Image 2: Leading wildcard provided and placed before the starting item name will return the record.

Image 3: Leading wildcard provided and should return a record that is confirmed to exist but does not.

Find more posts tagged with

Accepted answers

Waylon Smith

This issue has been resolved. The filter needed to be converted to ASCII like this:

?filter=Item LIKE '%25062718%25'

?filter=Item%20LIKE%20'%25062718%25'

All comments

Waylon Smith

Images 1 and 2 show the correct and expected results. Image 3 shows the incorrect issue that is happening.

Waylon Smith

This issue has been resolved. The filter needed to be converted to ASCII like this:

?filter=Item LIKE '%25062718%25'

?filter=Item%20LIKE%20'%25062718%25'