Retrieving a List of Customers from NetSuite

Learn how to retrieve a list of customers from your NetSuite account

Screenshot of the main flow in Anypoint Studio, view full image here

Description

Anypoint Connector for NetSuite synchronizes data and automates business processes between NetSuite and third party applications, either on-premise or in the cloud. This example shows you how to use the NetSuite connector in an Anypoint integration application.

Example Use Case

Though a simple example, this application connects to NetSuite to retrieve a list of customers based on a predefined criteria (all customers that have a last name that starts with 'a'). The data is then parsed and formatted to improve readability for the end user.

Set Up and Run the Example

Complete the following procedure to create, then run this example in your own instance of Anypoint Studio.

1. Open the Example project in Anypoint Studio from Anypoint Exchange. Do not run the application.
2. Replace http.port parameter in http:listener-config element with the valid value (For example:8081).
3. Log in to your NetSuite account. You will need the login email (netsuite.email) and the password (netsuite.password) to connect to NetSuite using the connector later on.
4. Choose Setup > Integration > Web Services Preferences from the main menu. Store the value ACCOUNT ID that will be used as a netsuite.account parameter.
5. On the same page, if not present, insert a row into the table with your Name and a Web Services Default Role. Store the Role ID that will be used as a netsuite.roleId parameter.
6. In your application in Studio, click the Global Elements tab.

7. Double-click the NetSuite global element to open its Global Element Properties panel. Configure it as follows:

    Email            netsuite.email
    Password        netsuite.password
    Account            netsuite.account
    Role Id            netsuite.roleId

You should verify the configuration by clicking Test Connection... button. Alternatively, you can also configure the global element in the XML Editor.

1. In the Package Explorer, right-click the get-customer-list-from-netsuite project name, then select Run As > Mule Application. Studio runs the application on the embedded server.
2. Hit your web browser with the following url: http://localhost:8081/customers?lastName=a to retrive a list of all customers having a last name starting with a. The data is stored in the HTML table.
3. Stop the Mule application by clicking the square, red terminate button in the Console.

Documentation

Read full documentation in GitHub

Examples to Try Next