in netsuite rest api calls. I have a user attempting to use rest suiteql. however they can not query custom records. They can see them but the suiteql fails

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the user is having trouble querying custom records using SuiteQL via the NetSuite REST API. This could be due to a number of reasons, but the most common one is related to permissions. In order to execute SuiteQL queries through REST Web Services, the user must have the necessary permissions set up in their role. This includes permissions for REST Web Services, SuiteQL, and the specific records they are trying to access. Here are the steps to ensure the correct permissions are set: 1. Navigate to Setup > Users/Roles > Manage Roles > Edit Role. 2. In the Setup tab, ensure that the 'REST Web Services' permission is set to Full. 3. In the Transactions tab, add all the necessary records with Full permission. 4. Make sure the 'SuiteQL' permission is also set to Full. If the user has all these permissions and is still unable to query custom records, it could be due to the specific syntax of the SuiteQL query. The user should ensure that they are using the correct syntax for querying custom fields. For example, if the custom field internal ID is 'custbody_sta_einvoicin#_20', the SuiteQL query should look something like this:

sql
SELECT custbody_sta_einvoicin#_20 FROM transaction

If the user is still having trouble, they may need to check the REST Web Services Prerequisites and Setup in the NetSuite Help Center to ensure they have completed all necessary steps. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******