Can a sqlquey API request return record fileds or is limited by API

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that a SQL query API request can indeed return record fields. However, there are certain limitations to consider. In the context of SuiteScript, you can use SuiteQL to run SQL-like queries. Here's a sample code provided in the conversation:

const resultSet = query.runSuiteQL({
            query: "SELECT * FROM CustomField where scriptid = '" + billFields[2].id.toUpperCase() + "'",
        });

This code is used to get custom field data. The

toUpperCase()

function is used to match the case of the script ID. However, when it comes to returning all records, there are limitations. SuiteScript has a limit of 5000 records per request. If you need to return more than this, you may need to implement paging or use multiple requests. For SuiteQL, there's a limit of 1000 results per query. To get more results, you can use the

offset

parameter in your query string. For example,

offset=2

would get the next set of results after the first 1000. If you want to return all records in a single REST API call, you may run into limitations with the size of the response or the number of records. Depending on the size of the result set, a RESTlet might run out of governance or time limit. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

The problem is that, only return a few fields , but if you do the query in netsuite is possible to get all the fields.