Hey everyone, I am using suiteconnect to pull data from netsuite via a rest webservice connection. I am trying to pull data from the Subscription Line Revision table, and getting some error on it. When I run the following query:

SELECT * from COUNT(id) AS i FROM SubscriptionLineRevision WHERE ROWNUM <= 50;

I get the following error:

{
  "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616sec10.html#sec10.4.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Invalid search query. Detailed unprocessed description follows. Search error occurred: Invalid or unsupported search.",
      "o:errorQueryParam": "q",
      "o:errorCode": "INVALID_PARAMETER"
    }
  ]
}

But when I change

ROWNUM

to

ROWNUM <= 40

, the query seems to work fine. What is the cause of this issue when I try to get more than 40 rows?

SEELCT

?

Sorry that was a typo 😅 I did have SELECT

Seems there might be another typo?

SELECT * from COUNT(id) AS i FROM

? Perhaps you just want

SELECT *

and don’t want

COUNT(id) AS i

?

Thank you so much! When I did ROWNUM between a certain range it worked.