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

Hi,

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

POST  https://ACCOUNT_ID.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

{
“q”: ” select * from account “
}
Response :
{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1”,
“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.