About Rest Web Service

REST is a modern easy-to-use application program interface (API) based on a widely adopted architectural style. The services provide users with seamless access to NetSuite record metadata, support API discoverability, offer link-based navigation and give users a uniform approach to interacting with both custom and standard records.

Key Points of the REST Web Service

• Pre-build endpoint
• NetSuite schema can be obtained via Metadata integration
• Fast development and easy deployment of integration
• Execution speed of the requests
• Human readable data in body: JSON format
• Supporting SuiteAnalytics workbooks
• Still some records and features in Beta
• Limitation of data query service to 1 000 records
• Searches are not available for use
• No further processing is possible (like in case of Restlet)
• No support of Legacy tax codes

The latest integration features using Rest WS offer 3 main operations:

• Metadata
• REST Record Service
• REST Query service

About REST Query Service

The NetSuite 2020.1 version of REST web services introduced powerful new query functionality, an area in which provides users with direct access to SuiteQL, a highly performant SQL-like query language. You can even execute advanced ad-hoc queries to perform actions such as multi-level joins, filtering, sorting, aliasing and paging. Logical, relational and equality operators are supported and make it possible to execute Saved Workbooks data sets. The Rest Query Service Tool offers an option how to extract data out of the NetSuite. 

Lot of mentioned features are available out of the box, and only Feature needs to be enabled. But as the feature is still quite new, couple of features is available as Beta and access to such features needs requested by NetSuite Umbrella Beta Program.