Home

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.
Rookie Asked on August 16, 2020 in SuiteTalk.
Add Comment
Cancel
2 Answer(s)

I’ve found it to be quite common to get an unexpected error when using “SELECT * …” with various records, especially transactions. It seems you need to be a little more selective with the current version of REST Web Services.

Cancel
Intermediate Answered on August 16, 2020.
Add Comment
Cancel

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.

Cancel
Intermediate Answered on August 17, 2020.
Add Comment
Cancel

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   Become a Sponsor