@jcribb That definitely works (BigQuery is funny about automatic schemas) - I guess it was the parse int I'm interest in. I've got:

var mySearch = search.load({
    			id :'customsearch_salesorderheaders'
    		});
    		   	
      		var myResults = mySearch.run().getRange(0,1000);
    		
    		var salesOrders = new Array();
    		
    		for ( var i = 0; myResults != null && i < myResults.length; i++ )
    		{
    			//Load the current result
    			var result = myResults[i];
    			
    			//Assign the fields to local variables.    			
    			var internalid = result.getValue('internalid');
    			var tranid = result.getValue('tranid');
    			var trandate = result.getValue('trandate');
    			var clientinternalid = result.getValue({name:'internalid', join:'customerMain'});
    			var salesrep = result.getText('salesrep');
    			var netamount = result.getValue('netamount');
    			var currency = result.getText('currency');
    			var fxamount = result.getValue('fxamount');
    					
    			salesOrders[salesOrders.length++] = new data(internalid,tranid,trandate,clientinternalid,salesrep,netamount,currency,fxamount);
    
    		};

I'll try parseInt on

var internalid = result.getValue('internalid')