Hi All. We are getting

{
  "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1>",
  "title": "Internal Server Error",
  "status": 500,
  "o:errorDetails": [
    {
      "detail": "An unexpected error occurred. Error ID: l4x122fi1sxr06df8c9ts",
      "o:errorCode": "UNEXPECTED_ERROR"
    }
  ]
}

whenever we try to run any advanced suiteQL using the REST services API. We are trying the following payload:

{
  "q": "SELECT TOP 1 id FROM transaction UNION SELECT TOP 1 id FROM transaction"
}

Please help.

@Prashant Kala When using SuiteTalk REST, sometimes wrapping a SuiteQL query like this helps:

SELECT * FROM ( SELECT TOP 1 id FROM transaction UNION SELECT TOP 1 id FROM transaction )

@tdietrich thanks a lot. It is working. It is a great tip.