Skip to content

Netsuite REST Service

Before you begin

In order to use the features in this section you need to have an active Spojit account. If you don't have an account you can checkout out the pricing and register here. If you already have an account you can login here.


NetSuite is the leading integrated cloud business software suite, including business accounting, ERP, CRM and ecommerce software. This service can facilitate the bilateral transfer of resources within the Netsuite RESTful web service.

Tip

Full documentation of Netsuite resources and configuration is available in the Netsuite Help Center.


Netsuite Authorization

This service uses the Token Based Authentication (TBA) approach outlined in the Netsuite Help Center. The following authorization configuration needs to filled out in order to connect with Netsuite:

Option Description Default Required
Company URL The company endpoint for your Netsuite instance (i.e. https://****.suitetalk.api.netsuite.com). - TRUE
Account ID Your account ID. - TRUE
Consumer Key A consumer key for your Netsuite instance. - TRUE
Consumer Secret A consumer secret for your Netsuite instance. - TRUE
Token ID A token ID for your Netsuite instance. - TRUE
Token Secret A token secret for your Netsuite instance. - TRUE

The following example configuration shows you how to configure the authorziation for Netsuite:

Netsuite Authorization Configuration

Important

This service uses Version 1 (v1) of the Netsuite REST API by default and will append this to the path automatically. Please add the paths accordingly without the reference to /services/rest/record/v1:

Correct Incorrect
/salesOrder /services/rest/record/v1/salesOrder

Important

  • This service has a built in JSON parser and will automatically convert to the proper format. Requests will automatically contain required headers and authorization configuration so they do not need to be added.
  • The following (below) is a general guide on how to use the methods for this service. The examples use the JSONPlaceholder fake online REST API. Please refer to the system documentation above for full path and schema information.

GET

When the GET configuration is selected the service will retrieve a resource from a given URL.

Option Description Default Required
Method Select "get" to retrieve a resource. - TRUE
API Url The full URL of the resource . - TRUE
Headers The request headers are not required as a request can be made without them. If added the Header Key and Header Value is required for each. - FALSE
Header Key The name of the header key. - TRUE
Header Value The value of the header. - TRUE
Example configuration and mapping

The following example shows you how to configure the Rest Service to get data from a resource. It also contains an example header for an OAuth authorization bearer token.

Rest Service GET Configuration

The GET method doesn't require any service data setup.

In this example the following output will be generated automatically by this service after it is run:

{
    "data": {
        "userId": 1,
        "id": 1,
        "title": "delectus aut autem",
        "completed": false
    },
    "metadata": {
        "statusCode": 200
    }
}

POST

When the POST configuration is selected the service will create a resource at a given location.

Option Description Default Required
Method Select "post" to create a resource. - TRUE
API Url The full URL of the resource . - TRUE
Headers The request headers are not required as a request can be made without them. If added the Header Key and Header Value is required for each. - FALSE
Header Key The name of the header key. - TRUE
Header Value The value of the header. - TRUE
Example configuration and mapping

The following example shows you how to configure the Rest Service to create a resource.

Rest Service POST Configuration

The schema can be whatever the resource excepts and for this example we are going to create an OBJECT schema with the specified fields:

Rest Service POST Schema

Given the following source data from another service:

{
  "data": {
      "user_id": 1,
      "my_id": 1,
      "the_title": "delectus aut autem",
      "finished": false
  }
}

We can map the applicable fields with the schema object:

Rest Service POST Mapping

In this example the following output will be generated automatically by this service after it is run:

{
    "data": {
        "userId": 1,
        "id": 1,
        "title": "delectus aut autem",
        "completed": false
    },
    "metadata": {
        "statusCode": 201
    }
}

PUT

When the PUT configuration is selected the service will update a resource at a given location.

Option Description Default Required
Method Select "put" to update a resource. - TRUE
API Url The full URL of the resource . - TRUE
Headers The request headers are not required as a request can be made without them. If added the Header Key and Header Value is required for each. - FALSE
Header Key The name of the header key. - TRUE
Header Value The value of the header. - TRUE
Example configuration and mapping

The following example shows you how to configure the Rest Service to update a resource.

Rest Service PUT Configuration

The schema can be whatever the resource excepts and for this example we are going to create an OBJECT schema with the specified fields:

Rest Service PUT Schema

Given the following source data from another service:

{
  "data": {
      "user_id": 1,
      "my_id": 1,
      "the_title": "delectus aut autem",
      "finished": false
  }
}

We can map the applicable fields with the schema object:

Rest Service PUT Mapping

In this example the following output will be generated automatically by this service after it is run:

{
    "data": {
        "userId": 1,
        "id": 1,
        "title": "delectus aut autem",
        "completed": false
    },
    "metadata": {
        "statusCode": 200
    }
}

DELETE

When the DELETE configuration is selected the service will delete a resource from a given URL.

Option Description Default Required
Method Select "delete" to delete a resource. - TRUE
API Url The full URL of the resource . - TRUE
Headers The request headers are not required as a request can be made without them. If added the Header Key and Header Value is required for each. - FALSE
Header Key The name of the header key. - TRUE
Header Value The value of the header. - TRUE
Example configuration and mapping

The following example shows you how to configure the Rest Service to delete a resource:

Rest Service DELETE Configuration

The DELETE method doesn't require any service data setup.

Many services will not return any data after a resource is deleted but if data is returned it could possiblly look like this:

{
    "data": {
        "userId": 1,
        "id": 1,
        "title": "delectus aut autem",
        "completed": false
    },
    "metadata": {
        "statusCode": 204
    }
}