I am trying to help another group within our organization access a SQL Table that I have created to populate Epic Department Data within our environment and came across the ability to use SQL Seach REST Interface using iKnow.

However, I am having issues trying to get it to work via POSTMAN before I hand off the solution...

the POST URL... https://<servername>/api/iKnow/latest/TESTCLIN/table/osuwmc_Epic_Clarity.DepartmentMaster/search

where osuwmc_Epic_Clarity.DepartmentMaster is the table

In the body...

{"query":SELECT ID, Abbr, Name, ExternalName, PhoneNumber, ApptPhone, FaxNumber, Address1, Address2, City, Zip, Specialty, RevLocID, RevLocName, BuildingCategoryID, BuildingName, DepCategoryTypeID, DepType, Center, EAFParent FROM osuwmc_Epic_Clarity.DepartmentMaster WHERE ID = 300000000","index":"IDKEY","option":1}

but I am receiving..

{
    "errors": [
        {
            "error": "ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''",
            "code": 5035,
            "domain": "%ObjectErrors",
            "id": "GeneralException",
            "params": [
                "Parsing error",
                "3",
                ""
            ]
        }
    ],
    "summary": "ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''",
    "warnings": [
        {
            "warning": "You are not accessing the latest version of this REST API. Use /api/iKnow/latest/* to access the most up-to-date version"
        }
    ]
}

Am I using this wrong? What might be the magic chant to get this to work without having to create a REST service?