Fetching Base64 from an Image URL in Celigo

Integrator.io
4

@nuriensing there isn't currently a way to natively do this in the platform, but it is on the roadmap. In the meantime, there are a couple ways you could do this.

If you have a NetSuite instance you can work with, then what I've done in the past is have IO drop the file into NetSuite's file cabinet then have another flow or a lookup afterwards to run a saved search of the file, then run a SuiteScript hook to convert the file to base64 string before it passes back to IO in the saved search response. This sample script is a preMap SuiteScript, but you would probably need to convert it to preSend SuiteScript.

https://docs.celigo.com/hc/en-us/articles/360050485392-SuiteScript-hooks-overview

https://github.com/CeligoServices/SuiteScript-Hooks

/**
 * 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));
    
};

You could use a lambda function. @youssefzouhairi wrote up post a couple months back on how to do this.
https://connective.celigo.com/t/faq-convert-a-blob-key-to-base64-string-for-import/358