Hi everyone,
I'm encountering an issue while trying to access specific transaction records in NetSuite through the SuiteQL REST web service. I'm unable to fetch data for records like sales orders, purchase orders, journal entries, and vendors.
Here's the scenario:
POST Request:
URL:
https://abcd.netsuite.com/services/rest/query/v1/suiteql
Body:
{
"q": "SELECT * FROM journalentry"
}
Error:
"Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'journalentry' was not found."
My question is:
Are these record types (sales orders, purchase orders, journal entries, vendors) not supported through the REST API, or is there something else causing this error?
I'd appreciate any insights or suggestions to help me resolve this issue.