W3BGUY

// Author - Danial Fields
$command = "cmd";
$arguments = '/c powershell -ExecutionPolicy ByPass -File "C:\\directory\\RunCommand Test.ps1" -p1 ' + $p1 + ' -p2 ' + $p2 + ' -p3 '+ $p3 + '"';

W3BGUY

Add to Jitterbit.conf file
[LogSync]
# Max number of records at once to sync - This is the initial batch size only! After retries it goes
#back to MinRecordsToSync!
MaxRecordsToSync=500
#Max sleep between retries
MaxRetryDelaySec=60
#It's actually the maximum after retries have kicked in!
MinRecordsToSync=500

W3BGUY

# Connect to PostgreSQL from Linux
/opt/jitterbit/pgsql/bin/psql -d postgres -U jitterbit -p 46914

# List databases
\l

# list tables
\dt

# Connect to TranDb database

W3BGUY

function getItemType(itemID){
  var itemData={};
  try{
    itemData=search.lookupFields({type:search.Type.ITEM,id:itemID,columns:['type','externalid','price','displayname']});
    log.debug('itemData',JSON.stringify(itemData));
  }catch(err01){
    log.error('getItemType('+itemID+').err01',JSON.stringify(err01));
  }finally{
    return itemData;
  }

W3BGUY

<?php
/**
 * @Author        w3bguy
 * @Created       2021-09-08
 *  
 * Description:
 *  Basic PHP NetSuite OAuth1.0 (SHA256) authentication to call RESTlet script.
 *
 * @modifications
 *  Date          Author    Version     Remarks

W3BGUY

$countryCodeDict=Dict();
AddToDict('countryCodeDict','AF','_afghanistan');
AddToDict('countryCodeDict','AX','_alandIslands');
AddToDict('countryCodeDict','AL','_albania');
AddToDict('countryCodeDict','DZ','_algeria');
AddToDict('countryCodeDict','AS','_americanSamoa');
AddToDict('countryCodeDict','AD','_andorra');
AddToDict('countryCodeDict','AO','_angola');
AddToDict('countryCodeDict','AI','_anguilla');
AddToDict('countryCodeDict','AQ','_antarctica');

W3BGUY

01> Create transformation operation with script 01 as the first step.
02> Create script operation with step 02 as teh script (called by script 01 script).
03> Create JavaScript with contents from step 03 (called by Step 02 script).

W3BGUY

01> Create transformation operation with script 01 as the first step.
02> Create script operation with step 02 as teh script (called by script 01 script).
03> Create JavaScript with contents from step 03 (called by Step 02 script).

W3BGUY

/**
 * @NApiVersion 2.1
 * @NScriptType Restlet
 * @NModuleScope SameAccount
 * @Author        Charles.Bastian (Technocrat Consulting Inc)
 * @Created       2022-00-00
 * @ScriptName    TCI_RS_Create_Invoice_PDF
 * @Filename      TCI_RS_Create_Invoice_PDF.js
 * @ScriptID      customscript_tci_rs_create_invoice_pdf
 * @SandBox       

W3BGUY

01> Create transformation operation with script 01 as the first step.
02> Create script operation with step 02 as teh script (called by script 01 script).
03> Create JavaScript with contents from step 03 (called by Step 02 script).