Integration between Netsuite and Hive for order and IF details

Proposal summary

This proposal covers the  integration between Netsuite and Hive. The solution covers the fetching of order details from Netsuite and retrieving the shipment details and this creates item fulfillment in Netsuite.

Requirement 

Connect Netsuite and hive to sync orders and fulfillment information.

Our Solution

As we understood Hive is performing the logistical operations including the shipping. So we need an API to connect between Netsuite and Hive for integrating order and fulfill details.

Action 1: Order integration

As we understand, the order is initially created in Netsuite. So we will provide you with a Restlet API that is generated from Netsuite. So you can initiate a GET request using Restlet URL from the Hive system, which will initiate the Restlet script in Netsuite and return the open SO(Pending fulfillment status) details as a response in JSON format. So the sales order will be returned if the status is open only.

You Can request Restlet  API from the Hive system in a specific interval of time. So while requesting the API, you have to provide parameters like date and time. Then only we can return the data from Netsuite without duplication.

We can return the standard order details, available in Netsuite as a response. If you have any preferred JSON format with details please let us know. Otherwise we can provide you a sample JSON response format using the standard available details in Netsuite for the order.

Action 2: Item Shipment integration

Once you have retrieved the order details from Netsuite, the shipment will process in the Hive System. So you can again initiate a POST request using Restlet URL from the Hive system, with order number and inventory  details in the JSON format. Once the request initiates we will create item fulfillment in Netsuite for the specific order.

While posting the data to Netsuite Restlet url it should contain all the necessary/mandatory details that are required to create item fulfillment in Netsuite.
So we can provide you with a sample JSON request format using the standard required details in Netsuite to create item fulfillment.

We will also create a custom record in the Netsuite to save the request when it comes. So in case of any error, we will maintain the error details also in the custom record.

Restlet

How to initiate Restlet URL from an Hive – TBA – OAuth 1.0

The Restlet URL(Which will be provided from Jobin and jismi IT services LLP) needs to be initiated with OAuth signature from Hive. 

Currently Netsuite recommended to use the Token-based Authentication (TBA – OAuth 1.0) or the OAuth 2.0 , as the User Credentials methods are depreciating.

The OAuth signature needs to be created from the user who is initiating the Restlet URL and it can be created based on the credentials provided from the Netsuite (Which will also be provided from Jobin and jismi IT services LLP). The credentials will contains the following details:

Credentials can be generated from Netsuite by creating integration records and Access tokens.

Credential details:-

• CONSUMER KEY
• CONSUMER SECRET
• TOKEN ID
• TOKEN SECRET
• SCRIPT ID
• SCRIPT DEPLOYMENT

The sample GET action is provided below: (This is a sample request. The finalized request with proper parameter can be given later)

GET: https://tstdrv1584391.restlets.api.netsuite.com/app/site/hosting/restlet.nl (Restlet URL)

Authorization: OAuth oauth_signature=”SIGNATURE”

Content-Type:  application/json

Hive needs to generate the signature using the above credentials. The signature can be generated as per the provided document.

Attached : Signature Construction – TBA using OAuth 1.0

Assumptions

• We can provide the sample JSON request for the following. If you have specific details or format that you are expecting as per your system preferences please let us know, so that we can create the JSON format accordingly.
  • JSON response sample for the order GET request
  • JSON request sample for the fulfillment POST request

Risks 

• If the shipment request doesn’t contain the necessary details to create item fulfillment in Netsuite, its creation will fail in the system. Also if users set up anything as mandatory in their specific Netsuite system for any custom/standard field and if the data is not available item fulfillment will fail. Users can refer to the custom record to see the error details.

As per the account service tier and licenses, there is a limit for the maximum Restlet requests can be initiated on the same instant. For the standard tier, the maximum requests that can be initiated at the same moment is limited to 5. If more than 5 requests are received at the same time , it will fail the requests from 6th.
Concurrency limit can be increased by adding extra suitecloud license to the account.