NetSuite

What are Zowie capabilities to integrate with NetSuite?

Below are the different use cases Zowie can support with our NetSuite integrations:

How to connect Zowie to NetSuite API?

In order to allow Zowie to access data in NetSuite, you need to enable RESTlet support and prepare API credentials for Zowie to access APIs. Please follow the below steps:

1. Make sure that RESTlet feature is enabled in your NetSuite by accessing: Setup > Company > Enable Features > SuiteCloud > Server SuiteScript.
2. In order to securely access your data Zowie will use token-based authentication. You can enable it by accessing the following configuration page: Setup > Company > Enable Features > Suite Cloud > Manage Authentication. Select Enable Token-Based Authentication and click Save.
3. Then you will need to create an integration that Zowie is going to use. To create integration please proceed with the following steps:
   1. Navigate to Setup > Integration > Manage Integrations and select New.
   2. Provide a name for your integration in the Name field eg. Zowie.
   3. Enable Token-Based Authentication and TBA: Issuetoken Endpoint.
   4. Disable TBA: Authorization Flow and Authorization Code Grant
   5. Enable User Credentials and click Save.
4. After creating the integration you will receive a Consumer Key and Consumer Secret, you will need to share this with the Zowie Team.
5. Once the integration is created, you will need to create a new role for Zowie that will be used by a Zowie user to authenticate the API. Please proceed with the following steps:
   1. Navigate to Setup > Users/Roles > Manage Roles > New.
   2. Provide a name for a role in Name field eg. Zowie.
   3. In the Setup tab of the Permissions section please make sure to select User Access Tokens permission and any other objects that Zowie must have access to integrate eg. accessing sales order data.
   4. Click Save to accept changes.
6. As the next step, it's recommended to create a dedicated Employee account for the Zowie integration. Please proceed with the following steps:
   1. Naviagte to Lists > Employees > Employees and create a new Employee.
   2. Make sure that you assigned the Role you created in step 5.
7. For recently created Employee please generate an Access Token to authenticate the API as follows:
   1. Navigate to Setup > Users/Roles > Access Tokens > New.
   2. Select Application, Employeer and Role you created in above steps.
   3. After creating an Access Token you will receive a Token ID and Token Secret, you will need to share this with Zowie Team.
8. Share the following parameters with the Zowie Team to configure authentication with your NetSuite:
   1. Netsuite URL
   2. Consumer Key
   3. Consumer Secret
   4. Token ID
   5. Token Secret

How to expose API for Zowie with RESTlet?

NetSuite RESTlet allows you to expose an API endpoint using a RESTlet script. RESTlet scripts are specific to the business use case and will be prepared by a Zowie Solution Engineer. You will receive RESTlet script from Zowie that you can use to create a deployment according to the following steps:

1. Navigate to Customization > Scripting > Scripts > New.
2. Upload a RESTlet script received from Zowie.
3. Click Save and Deploy on the uploaded script.
4. Provide Script ID and Deployement ID to Zowie Team to configure the integration.

Example RESTlet for order status and tracking

Here is the example RESTlet script that allows Zowie to access sales order data:

/**
 *@NApiVersion 2.x
 *@NScriptType Restlet
 */
define(['N/search', 'N/error'],
    function(search, error) {        
        //Loading sales order based on saved search 4541158 and provided number
        function _get(context) {
            //Validate if we have number
            if(context.number === undefined) {
                throw error.create({
                    name: 'MISSING_REQ_ARG',
                    message: 'Missing a required argument number.'
                });
            }         

            var savedSearchId = ‘3205’; //provide your saved search ID

            try {
                //Load saved search for tranid search
                var ordersSearchForTranId = search.load(savedSearchId);

                //Copy the filters from ordersSearch into defaultFilters
                var defaultFiltersForTranId = ordersSearchForTranId.filters;

                //Create custome filter for SO number
                var customFilterForTranId = search.createFilter({
                    name: 'tranid',
                    operator: search.Operator.IS,
                    values: context.number
                })

                //Add the customFilter into defaultFilters
                defaultFiltersForTranId.push(customFilterForTranId);

                //Modify filters in loaded search
                ordersSearchForTranId.filters = defaultFiltersForTranId;

                //Run modified search
                var ordersResultSetForTranId = ordersSearchForTranId.run();


                //Take one order
                var ordersResultRangeForTranId = ordersResultSetForTranId.getRange({
                    start: 0,
                    end: 1
                });

                //Load saved search for web number search
                var ordersSearchForWebNumber = search.load(savedSearchId);

                //Copy the filters from ordersSearch into defaultFilters
                var defaultFiltersForWebNumber = ordersSearchForWebNumber.filters;

                //Create custome filter for Web Number
                var customFilterForWebNumber = search.createFilter({
                    name: 'weborder', //Customize this filter field based on your Netsuite setup
                    operator: search.Operator.IS,
                    values: context.number
                })

                //Add the customFilter into defaultFilters
                defaultFiltersForWebNumber.push(customFilterForWebNumber);

                //Modify filters in loaded search
                ordersSearchForWebNumber.filters = defaultFiltersForWebNumber;

                //Run modified search
                var ordersResultSetForWebNumber  = ordersSearchForWebNumber.run();


                //Take one order
                var ordersResultRangeForWebNumber = ordersResultSetForWebNumber.getRange({
                    start: 0,
                    end: 1
                });


                var results = ordersResultRangeForTranId.concat(ordersResultRangeForWebNumber);

                return JSON.stringify(results);
            } catch (error) {
                throw error.create({
                    name: 'EXECUTION_ERROR',
                    message: error.name + ': ' + error.message
                });
            }
            
        }       
        return {
            get: _get            
        };
    });

🚧

Please note that in the 17th line there is a need to provide a saved search ID.

To create a Saved Search follow the steps:

1. Create a Saved Search and name it eg. Zowie Order Tracking.
2. Make it Public and introduce the following Criterias:

3. Select data (columns) that Zowie should access to provide updates on order status and tracking:

4. Save the created Saved Search and update the ID in the above RESTlet script with the one you received for created Saved Search.