Share with colleagues and friends who could benefit from our webinars too!
Querying Custom Records with REST API
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.