with this netsuite custom record suiteql query, I ...
# ask-stanley-ai
p
with this netsuite custom record suiteql query, I get this: { "q": "SELECT * FROM customrecord_csegcostcode WHERE ROWNUM < 20" } INFO : 400 BadRequest Error: System.InvalidOperationException: {"type":"https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1","title":"Bad Request","status":400,"o:errorDetails":[{"detail":"Invalid search query. Detailed unprocessed description follows. Invalid search type: customrecord_csegcostcode.","o:errorQueryParam":"q","o:errorCode":"INVALID_PARAMETER"}]}
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that the error you're encountering is due to an invalid search query. The error message indicates that the search type
customrecord_csegcostcode
is invalid. This could be due to a few reasons: 1. The custom record
customrecord_csegcostcode
does not exist. Please ensure that the custom record you're trying to query exists in your NetSuite account. 2. The custom record
customrecord_csegcostcode
is not exposed for SuiteQL queries. Not all custom records are exposed for SuiteQL queries. You can check this in the Records Catalog in your NetSuite account. 3. The syntax of the query is incorrect. Please ensure that your SuiteQL syntax is correct. The correct syntax for querying a custom record is
SELECT * FROM customrecord_<customrecordid>
. Please verify these points and try your query again. If the issue persists, you may need to further investigate the cause of the error. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.869359136
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.867447317
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.865758657
Please provide your feedback on this answer.