SuiteQL query with ORDER BY clause returns no data

I’ve been using SuiteQL and the NetSuite Rest Services in a custom integration project.  Everything works fine with the queries except when I use the “ORDER BY” clause.  When I add it to a query, it returns no data (without it, the query works perfectly)

Executing this simple query: “SELECT id,email,firstname,lastname FROM Customer” returns the corresponding items.  But executing this query: “SELECT id,email,firstname,lastname FROM Customer ORDER BY id” returns nothing

I’m wondering if this is either a limitation on the Rest Web Services API or a missing permission.

Thank you very much in advance for your replies!

Add Comment
2 Answer(s)

Specify the order by direction using ASC or DESC

Intermediate Answered 5 days ago.
Add Comment

That made the trick! Thank you!

Rookie Answered 5 days ago.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor