Published on January 26, 2025.

I'm excited to announce that I've just released a new version of SuiteAPI.

SuiteAPI is an open source, alternative Web API for the NetSuite platform. It's designed to make integrating with NetSuite easy, regardless of whether a developer is familiar with NetSuite or not. With SuiteAPI, you can easily get the results of SuiteQL queries, return entire records, get data from saved searches, generate PDFs, upload and download files from the file cabinet, and more. And because it's open source, NetSuite developers that have SuiteScript experience can extend SuiteAPI to do all sorts of things, including creating, updating, and deleting things transactions, items, entities, and so on.

I had been using SuiteAPI for my client projects for several years, and decided to release it as an open source solution in November 2022. Since then, I've received a lot of very positive feedback from other NetSuite developers.

SuiteAPI v2025.1 is the result of changes that I've made to the core RESTlet over the past few years, as well as feedback and requests from developers that are using SuiteAPI.

Here's a summary of the changes in SuiteAPI v2025.1.

queryRun returnAllRows parameter

The "queryRun" procedure now supports an optional boolean "returnAllRows" parameter.

When set to true, SuiteAPI returns all of the rows that meet the query's filter criteria. This is designed to help get beyond query.runSuiteQL's 5,000 row limit.

When using this option, additional information is returned, including detailed error information, and an analysis of the process (the number of query loop iterations that were involved, usageUnits that were used, etc).

The default value for returnAllRows is false.

recordGet returnDetailedSublists parameter

The "recordGet" procedure now supports an optional boolean "returnDetailedSublists" parameter.

When set to true, SuiteAPI returns all of the record's sublists, and all of the sublist lines.

The default value for returnAllRows is false.

searchRun searchType parameter

The "searchRun" procedure now supports an optional "searchType" parameter, which can be used to specify the search type of the saved search to load. For details, see the search.load documentation.

Next Steps

For more information about SuiteAPI, please visit:
https://suiteapi.com

SuiteAPI can be downloaded here:
https://suiteapi.com/download/

If you are interested in learning about some of the projects on which I've used SuiteAPI, check out these previous blog posts:
• Develop An Order Status Web App With SuiteQL, SuiteAPI, and Xojo
• NetSuite Integration with SuiteAPI and Xojo
• Palladium: A Hybrid Desktop App Powered by ColdFusion, Xojo, NetSuite, and SuiteAPI