Searching for and loading an invoice object using NetSuite Restlet Searching for and loading an invoice object using NetSuite Restlet

This article assumes that you have some NetSuite experience and have created a NetSuite Restlet. I have written a previous article that describes how to authenticate with NetSuite for calling a Restlet using token based authentication that should help you get up-to-speed.

To search for objects using NetSuite's JavaScript Restlet implementation I will be using nlapiSearchRecord. Once the record has been found it will then be retrieved using nlapiLoadRecord.


To perform a search, you first need to define your filters (how you want to find your invoice) using nlobjSearchFilter. You will also need to define what columns should be returned in your search with nlobjSearchColumn. Let's take a look at an example:


var my_custom_field_id = 1;
var filters = [];
filters.push(new nlobjSearchFilter('my_custom_field', null, 'equalto', my_custom_field_id));
var columns = [];
columns.push(new nlobjSearchColumn('internalid'));
var searchResults = nlapiSearchRecord('invoice', null, filters, columns);
if (searchResults == null || searchResults == '' || searchResults.length == 0) {
return "Error, there's no invoice record corresponding to " + my_custom_field_id);
}
var invoiceId = searchResults[0].getId();

In this example there are a few hard-coded elements that would need updating to match your exact use-case. The first variable is my_custom_field_id, this is the value being used to find the invoice. I typically would pass this in as input to my Restlet call. The second is a magic string for a custom field that I have defined on the NetSuite invoice object called: my_custom_field. If you're just getting started be sure to read Netsuite API Developer's Guide first.

These should be updated to match what you are searching.

Next up is creating the filter. Line 2 and 3 create a JavaScript array of filters and add one filter that will search for the custom field matching the input value. After this a columns array is created and I am asking for the NetSuite's internal ID of the invoice record.

These two variables then execute the aforementioned nlapiSearchRecord and stores in a variable. The results are then checked to see if any invoices were found. If none were found I've returned an error that can be read from the process calling the Restlet.

And finally, I store the internal ID into a variable that I will use in the next example to retrieve the invoice:


var invoiceId = searchResults[0].getId();
var invoiceRecord = nlapiLoadRecord('invoice', invoiceId);
var invoiceString = JSON.stringify(invoiceRecord);
nlapiLogExecution('DEBUG', "Invoice object:", invoiceString);
return invoiceRecord;

Using the ID retrieved earlier I execute the nlapiLoadRecord and store this in a variable. The next line is not required, but I like to trace out the results in NetSuite's debug log in case I need to inspect the results. And finally I return the full invoice record.

Similar to the error message, the process executing the Restlet call will now receive a JSON object of the NetSuite invoice.

Published on Jan 18, 2020

Tags: NetSuite | nlapiLoadRecord | nlapiSearchRecord

Related Posts

Did you enjoy this article? If you did here are some more articles that I thought you will enjoy as they are very similar to the article that you just finished reading.

Tutorials

Learn how to code in HTML, CSS, JavaScript, Python, Ruby, PHP, Java, C#, SQL, and more.

No matter the programming language you're looking to learn, I've hopefully compiled an incredible set of tutorials for you to learn; whether you are beginner or an expert, there is something for everyone to learn. Each topic I go in-depth and provide many examples throughout. I can't wait for you to dig in and improve your skillset with any of the tutorials below.