search cancel

OPS/MVS RESTful Web Services % wildcard not working

book

Article ID: 252999

calendar_today

Updated On:

Products

OPS/MVS Event Management & Automation

Issue/Introduction

Using % in a RESTful query Where Query String LIKE clause is not working.  For example:

GET /opsmvs/web/tables/STCTBL/NAME?where="NAME LIKE 'XB%'" returns 404 Not Found with no "AppInfo" data.
% was "percent-encoded" as %25.  

Additional symptom can be seen in the webSvcListener.log:

ERROR Oct 26 2022 at 08:11:26 PM | com.ca.automation.opsmvs.websvc.WebSvcUtil.zOSRunRexx Line:832 | Thread:41
      Error processing:java.lang.IllegalArgumentException: URLDecoder: Illegal hex characters in escape (%) pattern - For input string: "'&"

Environment

Release : 14.0

Resolution

Repeat the  '25' after the percent sign. For example:

where=%22NAME%20LIKE%20%27XB%2525%27%22

Notice the %2525 in the where clause.

The string is decode from %2525 to %25 first and then decoded to '%' alone.