Writing an image to NetSuite with Base64 data?

Integrator.io
, ,
1

As part of a custom integration that fetches a report from Workday using an HTTPS connector and creates vendor records in NetSuite, I'm told that my flow is about to begin receiving base64 data for workers' avatars, to be used as the NetSuite vendor records.

It occurs to me that the "Create transfer" modal does not allow any image file types. Can Celigo be used to write image files to the file cabinet?

2

@geofftipley1615 you'll need to use a suitescript hook for now. You'll need to change the suitescript a bit to reference your specific field mappings.

5301043caa20740200000001-0436b43bd0e54b6dbe647f50c1464475.png
5301043caa20740200000001-0436b43bd0e54b6dbe647f50c1464475.png1576×420 18.5 KB

/**
 * Called from integrator.io prior to mapping the data
 * @param  {Object} options The data sent to the hook.  See SampleOptionsData.json for format
 * @return {Array}         Array containing the data sent to the mapper
 */
var preMapHook = function(options){

//The array that will be returned from this hook to be processed by the mappings
var response = [];

for (var i = 0; i < options.data.length; i++) {
	/* The response object contains of a data array and an error array
	The data array is the elements that will be passed on to the mappings
	The errors array will show up as failed records on the integrator.io dashboard.  
	Each element in the array may consist of one or more errors
	*/
	
	try {
		if (options.data[i].package_data.LabelImageFormat == 'JPEG' || options.data[i].package_data.LabelImageFormat == 'JPG') {
			options.data[i].package_data.LabelImageFormat = 'JPGIMAGE';
		} else if (options.data[i].package_data.LabelImageFormat == 'PNG') {
			options.data[i].package_data.LabelImageFormat = 'PNGIMAGE';
		}
		var fileName = options.data[i].document_number + '-' + options.data[i].package_data.Packages[0].TrackingNumber + '.' + options.data[i].package_data.LabelImageFormat.toLowerCase();
		var file = nlapiCreateFile(fileName,options.data[i].package_data.LabelImageFormat,options.data[i].package_data.LabelImages);
		file.setFolder(options.data[i].netsuite_folder_id);
		file.setName(fileName);
		var fileId = nlapiSubmitFile(file);
		nlapiAttachRecord('file',fileId,options.data[i].record_type,options.data[i].internal_id);

		response.push({
			data : JSON.parse(JSON.stringify(options.data[i])),
			errors : []
		});
	} catch (e) {
		nlapiLogExecution('ERROR', e.name, e.message);
		response.push({
			data : null,
			errors : [{
				code : e.name,
				message : e.message
			}]
		});
	}
}

try {
	logOptions(options, response);
} catch (e) {
	nlapiLogExecution('ERROR', e.name, e.message);
	/*In the case of a high level failure all records should be marked as failed
	If there is a single record failure the individual error should be logged in the function called
	within the try-catch block
	*/
	for (var i = 0; i < response.length; i++) {
		response[i].data = null;
		response[i].errors.push({
			code : e.name,
			message : e.message
		});
	}
}

//Send the data to the mappings
return response;



};


/**


    

  • Log the data passed into the hook into the SuiteScript logs of the RESTlet
    • 

  • @param  {Object} options  Data passed into the PreMap hook
    • 

  • @param  {Array} response The object that is passed on to the mappings
    • 

  • @return null
    
*/
    
var logOptions = function(options, response){
    
nlapiLogExecution(‘AUDIT’, ‘PreMap Options’, JSON.stringify(options));
    
};