RE: Fetching Accounts using suiteQL Select * not working for REST API call


I am trying to fetch all the accounts using the suiteql query using rest api call, here is my request


“q”: ” select * from account “
Response :
“type”: “”,
“title”: “An unexpected error occurred. Error ID: kdxa7kha192fnko9t9eju”,
“status”: 500,
“o:errorCode”: “UNEXPECTED_ERROR”
Is this operation, Select * from <Record> working for anyone using REST api calls,
kindly let me know.
sreenath Rookie Asked on August 16, 2020 in SuiteTalk.
Add Comment
2 Answers

I will second the other statement about “SELECT * …”  queries being problematic. Even via SuiteScript N/query module I was running into errors as well, simply fixed by specifying columns to retrieve.

I believe even in once instance running query with .runSuiteQL() worked whereas .runSuiteQLPaged() did not … definitely seeing some inconsistencies.

Intermediate Answered on August 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.