Integrations
To connect NetSuite with other systems, you can use:
For a comparison of integration options, see RESTlets vs. Other NetSuite Integration Options.
CSV Import
Comma-Separated Values (CSV) import is the most common way to move small or medium-sized data sets from other applications into NetSuite. The CSV import process saves time and helps prevent errors by submitting data in a CSV file. You can add or update many records at one time, so you don't have to enter them manually.
You can use the Import Assistant for most CSV data imports. The assistant guides you through the process and verifies each step. When you're done, you can run the import immediately or save it to run later.
If you save an import, you can reuse its mapping for future jobs and share it with others. You can also import CSV data programmatically using that mapping. For SuiteScript 2.1, use the N/task Module.
For large or ongoing data migration projects, or for migrating data for record types that CSV import doesn't support, use REST web services.
For more information, see CSV Imports Overview.
SuiteTalk REST Web Services
NetSuite REST web services provide an integration channel that extends the capabilities of SuiteTalk. REST web services provide a REST-based interface for interacting with NetSuite.
The main benefits of REST web services include the following:
-
Access to record metadata, including user and company-specific metadata. For more information about working with records metadata, see Working with Resource Metadata.
-
Effective handling of custom records and custom fields.
-
Understandable API navigation.
-
Unlike RESTlets, you do not need to write, deploy, or run custom scripts.
For more information, see Overview of SuiteTalk REST Web Services.
RESTlets
The RESTlet script type lets you create custom logic and make it available to external applications over HTTP. The RESTful integration supports stateless communication between client and server.
A RESTlet deployed in your account can't be accessed without authentication, letting you control which external clients can use it. External clients can authenticate with token-based authentication in the HTTP header. Any application that can communicate over HTTP can access a RESTlet. RESTlet requests can also be sent with JSON, which integrates well with browsers and JavaScript.
RESTlets are quickly adopted by developers familiar with SuiteScript. With a RESTlet, you can perform any action achievable with server-side SuiteScript. RESTlets are also more secure than Suitelets, which can be made available to users without login. For more information, see SuiteScript 2.x RESTlet Script Type.
SuiteTalk SOAP Web Services
Oracle NetSuite is gradually removing SOAP web services in favor of more modern integration channels. SuiteTalk REST web services with OAuth 2.0 authentication is the preferred technology for new integrations.