NetSuite Search Operation through MuleSoft — Part 4

In our last blog we have seen how to perform Update Operation using NetSuite Connector in MuleSoft by updating a Customer record as an example. In this blog we will see how to perform Search Operation using NetSuite Connector in MuleSoft by searching a Customer record as an example.

Business Use-Case:

Here are some examples of how the NetSuite Search connector can be used in MuleSoft:

Inventory management: You can use the NetSuite Search connector to search for inventory data that meets certain criteria, such as inventory that is low in stock or inventory that is overstocked.

Human resources (HR): You can use the NetSuite Search connector to search for HR data that meets certain criteria, such as employees that are eligible for a promotion or employees that have a certain skill set.

Search Operation:

The search operation is used to execute a search on a specific record type based on a set of criteria. You can search by defining search filter fields on the record, joined fields on an associated record, search return columns, or joined search return columns from an associated record. The results of the search can be complete records, or a select set of fields specified through search return columns. Lets see the Search operation with a sample POC.

In the search-customer-flow as shown in the screenshot, NetSuite Search Connector searches a customer record from the NetSuite system.

First, set up a HTTP Listener with a path and configure connection. and then add a NetSuite Search connector into the flow. In the Search connector, select the key as CustomerSearch and provide payload in the Message as shown in the below screenshot.

Then add a Transform message before the Search operation and metadata will be generated automatically as shown in the below screenshot.

Select the required fields from the metadata and fill in the values that need to be added, now xsi schema needs to be defined in the code to make the operation work. Here is the example mapping with sample internalId provided for searchvalue key for Customer search record as shown in the below screenshot

And at the end of the flow add a Transform message and convert the output to JSON. Once the flow is triggered, NetSuite Search Connector will search the Customer record of the corresponding internalId.

Conclusion

In this blog, we have seen how to perform Search Operation using NetSuite connector in MuleSoft.