Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Querying Custom Records with REST API
Hello,
Is there a way to use the /query/v1/suiteql endpoint in the REST API to query custom records of a particular type? I can get the information about the custom type itself using this in the request body:
{
"q": "SELECT * FROM CustomRecordType"
}
However, if I try:
{
"q": "SELECT * FROM CustomRecord"
}
I get this message: Invalid search query. Detailed unprocessed description follows. Invalid search type: CustomRecord
Viewing the schema browser at https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/schema/record/customrecord.html, it looks like that should be a valid table name. The user tied to the token I'm using for my test requests is in the admin role, so I don't think it's a permissions issue.