NetSuite Expands Integration Capabilities with new REST Web Services
Posted by Tomas Novotny, Senior Product Manager, SuiteCloud Platform – Integration
SuiteCloud SuiteTalk REST Web Services are now generally available for all Oracle NetSuite products, extending a robust set of complementary SuiteTalk SOAP web services that have been part of NetSuite’s core integration solution for several releases. Including REST web services in SuiteTalk provides developers and administrators with even more options for integrating NetSuite with external applications, environments and data sources.
REST is a modern, lightweight, easy-to-use application program interface (API) based on a widely adopted architectural style. SuiteTalk delivers a full range of REST APIs exposed via a standard web services interface, securely accessible from external client applications.
REST web 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.
Another benefit: no server-side coding or management of custom scripts is necessary as is the case with server-side RESTlet scripts used to extend SuiteScript APIs when building REST-based integrations.
Here are some of the SuiteTalk REST Web Services Highlights from the latest update:
Metadata – Web services metadata provides schema defining each contract, enabling developers to dynamically discover API endpoints. This metadata contains all available resources such as records, data formats, values for input and output fields and supports HTTP methods and query parameters. Metadata can be returned either as JSON Schema, or via OpenAPI 3.0 (Swagger) format.
CRUD Operations – Create, Read, Update and Delete operations are now supported on records, sublists and subrecords within the parent record, and developers can make use of internal and external IDs to identify and reference these records. Additionally, upsert operations are now fully supported. It’s also possible for control the level of expansion for record subresources (sublists and subrecords) as a link or a fully expanded entity, and record subresources can even be accessed directly.
Query – The NetSuite 2020 Release 1 version of REST web services introduces powerful new query functionality, an area in which NetSuite will continue to invest. The NetSuite REST API now 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.
Supported Records – All SuiteScript records available in the NetSuite 2020 Release 1 are supported in REST to maximize coverage of business objects. Please note that certain records may still be in beta status, so be sure to review the API and developer documentation to learn more.
For those who haven’t tried out these powerful new REST web services, spend some time exploring news ways to integrate NetSuite with other applications and environments managed by your organization.
To learn more, please refer to the Online Help articles available in NetSuite Help Center or SuiteAnswers, and get more specifics on the new features in the Release Notes.