SuiteScript Testing & Validation Framework — Automating Integration QA in NetSuite

/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
define(['N/search','N/record','N/https','N/log'], (search,record,https,log) => {

  const execute = () => {
    runTest('Customer Count Match', validateCustomerCount);
    runTest('API Health Check', testExternalAPI);
    runTest('Recent SO Status Validation', validateSalesOrders);
  };

  const runTest = (name, fn) => {
    let status='PASS', msg='', count=0;
    try {
      const res = fn();
      msg = res.message;
      count = res.count || 0;
      status = res.status || 'PASS';
    } catch (e) {
      status='FAIL';
      msg=e.message;
    }
    record.create({type:'customrecord_integration_qa_log'})
      .setValue('custrecord_test_name', name)
      .setValue('custrecord_result', status)
      .setValue('custrecord_message', msg)
      .setValue('custrecord_record_count', count)
      .save();
    log.audit(`${name}: ${status}`, msg);
  };

  const validateCustomerCount = () => {
    const count = search.create({type:'customer',columns:['internalid']}).runPaged().count;
    const expected = 500; // Example baseline
    return { status: count === expected ? 'PASS' : 'FAIL', message:`Found ${count} customers`, count };
  };

  const testExternalAPI = () => {
    const res = https.get({ url: 'https://api.myshop.com/health' });
    const ok = res.code === 200;
    return { status: ok ? 'PASS' : 'FAIL', message:`API returned ${res.code}` };
  };

  const validateSalesOrders = () => {
    const count = search.create({
      type:'salesorder',
      filters:[['status','anyof','SalesOrd:B']],
      columns:['internalid']
    }).runPaged().count;
    return { message:`${count} open Sales Orders`, count };
  };

  return { execute };
});

email.send({
  author: -5,
  recipients: ['admin@company.com'],
  subject: 'NetSuite QA Validation Summary',
  body: '3 tests passed, 1 failed. See QA Log for details.'
});