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

1. Configuration2. Service data setup3. Output Data

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

1. Configuration2. Service data setup3. Output Data

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

1. Configuration2. Service data setup3. Output Data

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

1. Configuration2. Service data setup3. Output Data

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
    }
}