posting json to netsuite for sales order.

Seeing some older examples on here for posting json to restlet but cant find anything for the current version of netsuite’s api system. I am wanting to avoid the netsuite-php integration and would rather just post directly to netsuite. My needs are not huge. just being able to post via json a sales order with userid it is going to, items, price per item, and quantity.

Anyone have anything handy I could build off of? Thanks!!!

Rookie Asked on August 17, 2021 in SuiteCloud.
Add Comment
1 Answer(s)

Ended up doing this.. saving for anyone else interested.

/**
*@NApiVersion 2.x
*@NScriptType Restlet
*/
define([‘N/record’], function (record) {

// Create a NetSuite record from request params
function post(context) {

var objResp = {};

log.audit(‘post’, ‘Context : ‘ + JSON.stringify(context));

var arrJSONItems = context.item;

try {

var recSO = record.create({
type: context.recordtype,
isDynamic: true
});

recSO.setValue(‘entity’, context.entity);
recSO.setValue(‘quantity’, context.quantity);
recSO.setValue(‘otherrefnum’, context.PurchaseOrder);
recSO.setText(‘custbody_reqd_delivery_date’, context.shipdate);
recSO.setText(‘custbodydelivery_date’, context.shipdate);
recSO.setText(‘enddate’, context.shipdate);
recSO.setValue(‘location’, 71);
recSO.setValue(‘custbody_rsm_created_by’, 26211);
var shippingAddr = recSO.getSubrecord({
fieldId: ‘shippingaddress’
});

shippingAddr.setText({
fieldId: ‘city’,
text: context.shipcity || ”
});
shippingAddr.setText({
fieldId: ‘state’,
text: context.state || ”
});
shippingAddr.setText({
fieldId: ‘zip’,
text: context.zip || ”
});
shippingAddr.setText({
fieldId: ‘addr1’,
text: context.addr1 || ”
});
shippingAddr.setText({
fieldId: ‘addr2’,
text: context.addr2 || ”
});

for (var ji in arrJSONItems) {

recSO.selectNewLine(‘item’);
recSO.setCurrentSublistValue(‘item’, ‘item’, arrJSONItems[ji].item);

var lineQty = arrJSONItems[ji].quantity;
if (arrJSONItems[ji].item == ‘561’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 54;
}
if (arrJSONItems[ji].item == ‘667’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 75;
}
if (arrJSONItems[ji].item == ‘559’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 54;
}
if (arrJSONItems[ji].item == ‘558’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 55;
}
if (arrJSONItems[ji].item == ‘666’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 75;
}
if (arrJSONItems[ji].item == ‘560’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 91;
}
if (arrJSONItems[ji].item == ‘687’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 48;
}
if (arrJSONItems[ji].item == ‘684’)
{
lineQty = Number(arrJSONItems[ji].quantity) * 60;
}
recSO.setCurrentSublistValue(‘item’, ‘quantity’, lineQty);
recSO.setCurrentSublistValue(‘item’, ‘price’, arrJSONItems[ji].plvl);
//recSO.setCurrentSublistValue(‘item’, ‘amount’, arrJSONItems[ji].amount);
recSO.commitLine(‘item’);
}

var recordId = recSO.save({
enableSourcing: true,
ignoreMandatoryFields: true
});

log.audit(‘post’, ‘Created Sales Order | id : ‘ + recordId);

objResp = {
status: ‘Success’,
description: ‘Created Sales Order record | internal id : ‘ + recordId
};

} catch (error) {

log.error(‘post’, ‘ERROR : ‘ + error);

objResp = {
status: ‘Failed’,
description: error.message
};
}

return objResp;
}

return {
post: post
};
});

Rookie Answered on May 25, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor