This integration is for creating a customer in the front app. Using this plugin we can create a customer in NetSuite. We can add the Integration by going to settings → Plugins and APIs → Add a Plugin → give a name for plugin → add the endpoint URL.
End point URL: https://forms.netsuite.com/app/site/hosting/scriptlet.nl?script=1177&deploy=1&compid=TSTDRV1584391&h=c88bbbbe9ff30b892d7c
/**
* @NApiVersion 2.x
* @NScriptType Suitelet
* @NModuleScope SameAccount
*/
/**
* Script Description
* This suitelet is to load HTML and recive post request
* HTML consists A form
*/
/*******************************************************************************
*
* Support Files
*
* *****************************************************************************
*
*
*
* $Author: Jobin & Jismi IT Services LLP $
*
* DESCRIPTION
* Frontapp Integereation
*
* REVISION HISTORY Update:
*
*
*
******************************************************************************/
define(['N/file', 'N/url', 'N/search', 'N/runtime', 'N/record', 'N/https'],
function paypal(file, url, search, runtime, record, https) {
var main = {
attachMessage: function(type, transactionId, transactionType, frontObj) {
var messageObj = record.create({ type: "message" });
var authorId = main.findAuthor(frontObj.message.from.handle);
log.debug("authorId", authorId);
if (authorId == false) {
//return "No Author Found"
} else {
messageObj.setValue({ fieldId: "author", value: authorId });
}
// var recipientId = main.findRecipient(frontObj.message.recipients[1].handle);
for (var i = 1; i < frontObj.message.recipients.length; i++) {
var recipientId = main.findRecipient(frontObj.message.recipients[i].handle);
if (recipientId != false) {
break;
}
}
log.debug("recipientId", recipientId);
if (recipientId == false) {
//return "No Recipient Found"
messageObj.setValue({ fieldId: "recipientemail", value: frontObj.message.recipients[1].handle });
} else {
messageObj.setValue({ fieldId: "recipient", value: recipientId });
}
messageObj.setValue({ fieldId: "subject", value: frontObj.message.subject });
messageObj.setValue({ fieldId: "message", value: frontObj.message.body });
log.debug("transactionId", transactionId);
if (transactionType != "customerattach")
messageObj.setValue({ fieldId: "transaction", value: transactionId });
var messageId = messageObj.save();
log.debug("messageId", messageId);
return messageId;
},
findAuthor: function(email) {
log.debug("findAuthor", email);
var customerObj = main.findCustomer(email);
if (customerObj == false) {
var empId = main.findEmployee(email);
return empId
} else {
return customerObj.internalid
}
return false;
},
findRecipient: function(email) {
log.debug("findRecipient", email);
var empId = main.findEmployee(email);
if (empId == false) {
var customerObj = main.findCustomer(email);
if (customerObj == false) {
return false
}
return customerObj.internalid;
} else {
return empId;
}
return false;
},
createCustomer: function(data) {
var customerEmail = data.message.from.handle;
var customerName = data.message.from.display_name;
var recordObj = record.create({ type: "customer" });
recordObj.setValue({ fieldId: "email", value: customerEmail });
recordObj.setValue({ fieldId: "firstname", value: customerName });
recordObj.setValue({ fieldId: "category", value: 7 });
var recId = recordObj.save({
enableSourcing: true,
ignoreMandatoryFields: true
});
log.debug("customerCreated", recId);
return customerEmail;
// recordObj.setValue({ fieldId: "firstname", customerName.split(" ",)[0] });
},
onRequest: function(context) {
if (context.request.method === 'POST') {
var customer = context.request.parameters.customer;
var type = context.request.parameters.type;
var transactionId = context.request.parameters.internal;
var transactionType = context.request.parameters.tranType;
var data = context.request.parameters.data;
var searchKey = context.request.parameters.search;
log.debug("data", data);
if (type == "primarySearch") {
data = JSON.parse(data);
var fileid = 3197;
var newhtml = main.gethtml(fileid, customer, data);
context.response.write(newhtml);
} else if (type == "message") {
data = JSON.parse(data);
var response = main.attachMessage("message", transactionId, transactionType, data);
if (response) {
context.response.write("Message Attached To the Record");
} else {
context.response.write("Couldnt Find Enough Netsuite Records Related");
}
} else if (type == "createcustomer") {
data = JSON.parse(data);
var fileid = 3197;
var customer = main.createCustomer(data);
var newhtml = main.gethtml(fileid, customer, data);
context.response.write(newhtml);
} else if (type == "recordSearch") {
var customer = main.recordSearch(searchKey);
var newhtml = main.getSearchhtml(customer);
log.debug("newhtml", newhtml);
context.response.write(newhtml);
}
} else {
var customer = context.request.parameters.customer;
if (customer == "" || customer == undefined) {
var fileid = 3199;
var fileObj = file.load({
id: fileid
});
if (fileObj.size < 10485760) {
var newhtml = fileObj.getContents();
}
}
context.response.write({
output: newhtml
});
}
},
gethtml: function(fileid, customer, data) {
var fileObj = file.load({
id: fileid
});
if (fileObj.size < 10485760) {
var html = fileObj.getContents();
}
/*Check For primary email*/
var customerObj = main.findCustomer(customer);
if (customerObj == false) {
/*Check For recipent email*/
for (var i = 0; i < data.message.recipients.length; i++) {
var customerObj = main.findCustomer(data.message.recipients[i].handle);
if (customerObj != false) {
break;
}
}
/*No Customer found in both primary and recipient emails*/
if (customerObj == false) {
var newhtml = main.getTemplatehtml("", false, html);
} else {
var newhtml = main.getTemplatehtml(customerObj, true, html);
}
} else {
var newhtml = main.getTemplatehtml(customerObj, true, html);
}
return newhtml;
},
getTemplatehtml: function(customerObj, status, html) {
log.debug("customerObj", customerObj);
if (status == false) {
var customerRow = '<tr> <td colspan="3"> <div class="alert alert-primary alert-dismissible fade show" role="alert" style=" text-align: center; "> No Results <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> </td> </tr>';
var newhtml = html.replace("ReplacewithCustomerROW", customerRow);
newhtml = newhtml.replace("Replacewithcustnum", 0);
newhtml = newhtml.replace(/ReplacewithNum/g, '0').replace("ReplacewithSearchResults", " ");
} else {
var customerRow = '<tr> <td> <input type="radio" align="center" value="ReplacewithCustomerID" class="customerattach" onchange="checkboxEvent(this)" id="checkbox" /> </td> <td> <div> <div class="lead" style=" font-weight: 600; ">*ReplacewithCustomer*</div> <div>*Replacewithemail*</div> </div> </td> <td> <div> <a href="javascript:Front.openUrl(replaceurl);"> <img align="center" src="https://system.na3.netsuite.com/core/media/media.nl?id=3829&c=5210448&h=9c99f454f63b3ae8469c" style="width:20px;height:20px;border:0;" /> </a> </div> </td> </tr> <tr> <td colspan="3" style=" color: grey; font-weight: 400; font-size: small; "> CUSTOMER NOTES</td> </tr> <tr> <td colspan="3" style=" font-size: small; "> ReplacewithCustomercomments</td> </tr>'
var newhtml = html.replace("ReplacewithCustomerROW", customerRow);
newhtml = newhtml.replace("*ReplacewithCustomer*", customerObj.name);
newhtml = newhtml.replace("ReplacewithCustomercomments", customerObj.comments);
newhtml = newhtml.replace("Replacewithcustnum", 1);
newhtml = newhtml.replace(/ReplacewithCustomerID/g, customerObj.internalid);
newhtml = newhtml.replace("*Replacewithemail*", customerObj.email);
newhtml = newhtml.replace("replaceurl", "'https://system.na3.netsuite.com/app/common/entity/custjob.nl?id=" + customerObj.internalid + "&whence='");
newhtml = main.createRelated(newhtml, customerObj);
}
return newhtml;
},
createRelated: function(newhtml, customerObj) {
var relatedRecords = customerObj.related;
var count = 0;
var tablecontents = "";
for (var key in relatedRecords) {
if (key != "") {
// var rowTag = '<tr height="10" style="border-bottom-style: solid; border-bottom-color: darkgray;"><td height="30" class="addressheader"> <input type="checkbox" value="Replacewithinternal" class="ReplacewithType" onchange="checkboxEvent(this)" id="checkbox" /> <b> ReplacewithTranid </b><a href="javascript:Front.openUrl(replaceurl);"><img align="center" src="https://system.na3.netsuite.com/core/media/media.nl?id=3829&c=5210448&h=9c99f454f63b3ae8469c"style="width:30px;height:30px;border:0;"></a></td></tr>'
var rowTag = '<tr> <td> <input type="radio" value="Replacewithinternal" class="ReplacewithType" onchange="checkboxEvent(this)" id="checkbox"> </td> <td> <div class="search-results"> <div class="" style="font-weight: 600; "> ReplacewithTranid </div> <div>Replacewithtrantype | Replacewithtrancustomer | Replacewithtrandate</div> </div> </td> <td> <div> <a href="javascript:Front.openUrl(replaceurl);"><img align="center" src="https://system.na3.netsuite.com/core/media/media.nl?id=3829&c=5210448&h=9c99f454f63b3ae8469c" style="width:20px;height:20px;border:0;"> </a> </div> </td> </tr>'
count = count + 1;
rowTag = rowTag.replace("ReplacewithTranid", key);
var type = relatedRecords[key].type.toLowerCase();
rowTag = rowTag.replace("replaceurl", "'https://system.na3.netsuite.com/app/accounting/transactions/" + type + ".nl?id=" + relatedRecords[key].internalid + "&whence='");
rowTag = rowTag.replace("Replacewithinternal", relatedRecords[key].internalid);
rowTag = rowTag.replace("ReplacewithType", relatedRecords[key].type);
rowTag = rowTag.replace("Replacewithtrantype", relatedRecords[key].type);
rowTag = rowTag.replace("Replacewithtrancustomer", customerObj.name);
rowTag = rowTag.replace("Replacewithtrandate", relatedRecords[key].trandate);
tablecontents += rowTag;
} else {
var rowTag = '<tr> <td colspan="3"> <div class="alert alert-primary alert-dismissible fade show" role="alert" style=" text-align: center; "> No Results <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> </td> </tr>'
tablecontents += rowTag;
}
}
newhtml = newhtml.replace("ReplacewithSearchResults", tablecontents);
newhtml = newhtml.replace(/ReplacewithNum/g, count);
return newhtml;
},
findCustomer: function(customer) {
var customerSearchObj = search.create({
type: "customer",
filters: [
["email", "is", customer]
],
columns: [
search.createColumn({
name: "companyname",
sort: search.Sort.ASC,
label: "name"
}),
search.createColumn({ name: "comments", label: "comments" }),
search.createColumn({
name: "tranid",
join: "transaction",
label: "tranid"
}),
search.createColumn({
name: "internalid",
join: "transaction",
label: "internalid"
}),
search.createColumn({
name: "type",
join: "transaction",
label: "Type"
}),
search.createColumn({ name: "internalid", label: "internalid" }),
search.createColumn({ name: "email", label: "email" }),
search.createColumn({
name: "trandate",
join: "transaction",
label: "trandate"
})
]
});
var searchResultCount = customerSearchObj.runPaged().count;
var columns = customerSearchObj.columns;
log.debug("Customer Found", searchResultCount);
if (searchResultCount < 1) {
return false;
}
var dataObj = {};
dataObj["related"] = {}
customerSearchObj.run().each(function(result) {
dataObj["name"] = result.getValue(columns[0]);
dataObj["internalid"] = result.getValue(columns[5]);
dataObj["email"] = result.getValue(columns[6]);
dataObj["comments"] = result.getValue(columns[1]).substring(0, 120);
dataObj["related"][result.getValue(columns[2])] = {};
dataObj["related"][result.getValue(columns[2])]["internalid"] = result.getValue(columns[3]);
dataObj["related"][result.getValue(columns[2])]["type"] = result.getValue(columns[4]);
dataObj["related"][result.getValue(columns[2])]["trandate"] = result.getValue(columns[7]);
return true;
});
return dataObj;
},
findEmployee: function(email) {
var employeeSearchObj = search.create({
type: "employee",
filters: [
["email", "is", email]
],
columns: [
search.createColumn({ name: "internalid", label: "Internal ID" })
]
});
var searchResultCount = employeeSearchObj.runPaged().count;
log.debug("employeeSearchObj result count", searchResultCount);
if (searchResultCount < 1) {
return false
}
var internalid;
employeeSearchObj.run().each(function(result) {
internalid = result.getValue({ name: "internalid", label: "Internal ID" })
return true;
});
return internalid;
},
recordSearch: function(searchKey) {
var transactionSearchObj = search.create({
type: "transaction",
filters: [
["numbertext", "haskeywords", searchKey],
"AND",
["mainline", "is", "T"]
],
columns: [
search.createColumn({ name: "internalid", label: "Internal ID" }),
search.createColumn({ name: "tranid", label: "Document Number" }),
search.createColumn({ name: "type", label: "Type" }),
search.createColumn({ name: "trandate", label: "Date" }),
search.createColumn({ name: "trandate", label: "Date" }),
search.createColumn({
name: "entityid",
join: "customerMain",
label: "Name"
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug("transactionSearchObj result count", searchResultCount);
var tranObj = {};
transactionSearchObj.run().each(function(result) {
tranObj.internalid = result.getValue({ name: "internalid", label: "Internal ID" });
tranObj.tranid = result.getValue({ name: "tranid", label: "Document Number" });
tranObj.type = result.getValue({ name: "type", label: "Type" });
tranObj.trandate = result.getValue({ name: "trandate", label: "Date" });
tranObj.customer = result.getValue({
name: "entityid",
join: "customerMain",
label: "Name"
});
// .run().each has a limit of 4,000 results
return true;
});
return tranObj;
},
getSearchhtml: function(customerObj) {
var rowTag = '<tr> <td> <input type="radio" value="Replacewithinternal" class="ReplacewithType" onchange="checkboxEvent(this)" id="checkbox"> </td> <td> <div> <div class="" style=" font-weight: 600; "> ReplacewithTranid </div> <div>Replacewithtrantype | Replacewithtrancustomer | Replacewithtrandate</div> </div> </td> <td> <div> <a href="javascript:Front.openUrl(replaceurl);"><img align="center" src="https://system.na3.netsuite.com/core/media/media.nl?id=3829&c=5210448&h=9c99f454f63b3ae8469c" style="width:20px;height:20px;border:0;"> </a> </div> </td> </tr>'
rowTag = rowTag.replace("ReplacewithTranid", customerObj.tranid);
var type = customerObj.type.toLowerCase();
rowTag = rowTag.replace("replaceurl", "'https://system.na3.netsuite.com/app/accounting/transactions/" + type + ".nl?id=" + customerObj.internalid + "&whence='");
rowTag = rowTag.replace("Replacewithinternal", customerObj.internalid);
rowTag = rowTag.replace("ReplacewithType", customerObj.type);
rowTag = rowTag.replace("Replacewithtrantype", customerObj.type);
rowTag = rowTag.replace("Replacewithtrancustomer", customerObj.customer);
rowTag = rowTag.replace("Replacewithtrandate", customerObj.trandate);
return rowTag;
}
}
for (var key in main) {
if (typeof main[key] === 'function') {
main[key] = trycatch(main[key], key);
}
}
function trycatch(myfunction, key) {
return function() {
try {
return myfunction.apply(this, arguments);
} catch (e) {
log.debug("e in " + key, e);
}
}
};
return main;
});<div id="accordion">
<div class="card">
<div class="card-header" id="headingOne">
<h5 class="mb-0">
<button class="btn btn-link" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">▾ Customer <span class="badge badge-pill badge-dark">Replacewithcustnum</span>
</button>
</h5>
</div>
<div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordion">
<div class="card-body table-responsive">
<table class="" style="width: 100%;">
ReplacewithCustomerROW
</table>
</div>
</div>
</div>
<div class="card">
<div class="card-header" id="headingTwo">
<h5 class="mb-0">
<button class="btn btn-link" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">▾ Search <span class="badge badge-pill badge-dark">ReplacewithNum</span>
</button>
</h5>
</div>
<div id="collapseTwo" class="collapse show" aria-labelledby="headingTwo" data-parent="#accordion">
<div class="card-body table-responsive">
<div>
<div class="input-group">
<input class="form-control" onchange="searchnull()" id="searchs" style="" type="text" placeholder="Search Netsuite Records" aria-label="Recipient's username" aria-describedby="search-in-netsuite">
<div class="input-group-append">
<button class="btn btn-outline-secondary" onclick="searchRecord();" type="button">Search</button>
</div>
</div>
</div>
<table class="table table-striped table-hover" id="customerrecord" style="width: 100%;">
<thead>
<th colspan="3">
<div>
<div class="searchresults" style=" color: grey; font-weight: 400; font-size: small; ">
SEARCH RESULTS <span class="badge badge-pill badge-dark">ReplacewithNum</span>
</div>
</div>
</th>
</thead>
<tbody>
ReplacewithSearchResults
</tbody>
</table>
<table class="table table-striped table-hover" id="transrecord" style="width: 100%;display: none">
</table>
</div>
</div>
</div>
</div>