Searching for and loading an invoice object using NetSuite Restlet

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