- Welcome BMC Customer Support Site Guest User
Knowledge Article
REST API Error 124 "Wrong query format cannot have nested parentheses" when querying with the fields option
Error when you use the qualification in the URL wih ?fields=values(field1,field2) if any of the field names have a parentheses
Remedy AR System Server
AR System Server
AR Server 18.08 and 18.05
If you enable REST API in AR Server version 18.08 and 18.05, you may encounter the following error when using the fields option with fieldnames that contain parentheses Example: https://servername:8443/api/arsys/v1/entry/HPD:Help Desk?fields=values(Incident Number,Assignee,Budget Cost (Currency))
"messageType": "ERROR", "messageText": "One of the items specified in the field or value list contains error.", "messageNumber": 124, "messageAppendedText": "Wrong query format cannot have nested parentheses at 34 in values |
Filed as defect SW00551600
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers. This has been resolved with AR Server 19.02. To use the fields option with field names that contain parentheses, you must 'escape' the parenthesis with the escape character "\" ex: https://servername:8443/api/arsys/v1/entry/HPD:Help Desk?fields=values(Incident Number,Assignee,Budget Cost \(Currency\)) |
Attachment(s):