REST API Error 124 "Wrong query format cannot have nested parentheses" when querying with the fields option

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System Server


    APPLIES TO:

    AR Server 18.08 and 18.05



    PROBLEM:

    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 

     


    CAUSE:

    Filed as defect SW00551600


    SOLUTION:

    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\))


    Article Number:

    000159773


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles