Hi everyone, I'm encountering an issue while tryi...
# integrations
r
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.
l
Hi Rahul, these records will be on Transactions table then you filter by transaction type = Journal
r
Thank you