Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

generate csv file

GPavanKumK
Tera Contributor

 hi 

i'm trying to generate through flow designer as flow it working but it not generate through rtask 

 

var rowsFromRequest = [];
var row = '';
var returnBox = new GlideRecord('sc_req_item');
if(returnBox.get(fd_data.trigger.request_item.sys_id)){
 
     var ordernum = returnBox.getDisplayValue("request");
 
    var equipment_req = fd_data._1__get_catalog_variables.select_the_primary_device;
    var str = JSON.stringify(equipment_req);
    var dataarray = JSON.parse(str);
    gs.info("Pavan285 : "+ dataarray);
   
   if (dataarray && dataarray.length > 0 && dataarray[0]) {
    gs.info("Pavan285 : " + dataarray[0].display_name);
   }
    for(var i = 0; i < dataarray.length; i++){
   gs.info("Pavan285 : er  "+ dataarray[i].display_name + "RD "+ dataarray[i].replacement_device);
         
    //Construct row for CSV
    var row = escapeCSV(returnBox.getValue('number')) + ',' + //RITMNumber
    escapeCSV(fd_data._1__get_catalog_variables.select_device) + ',' + //Select device
    escapeCSV(fd_data._1__get_catalog_variables.who_is_currently_using_the_device.getDisplayValue()) + ',' + //who is currently using device
    escapeCSV(fd_data._1__get_catalog_variables.carrier) + ',' + //Carrier
//'"",' + //Carrier
    escapeCSV(fd_data._1__get_catalog_variables.cellular_number_found_in_device_settings) + ',' +  //Phone
    escapeCSV(fd_data._1__get_catalog_variables.imei_1_imei_2_number_found_in_device_settings.toString()) + ',' + //Address2
    escapeCSV(fd_data._1__get_catalog_variables.street_address) + ',' + // Street Address   
    escapeCSV(fd_data._1__get_catalog_variables.city) + ',' + //City
    escapeCSV(fd_data._1__get_catalog_variables.state_ref) + ',' + //State
    escapeCSV(fd_data._1__get_catalog_variables.zip_code) + ',' + //Zip 
    escapeCSV(getAssetName(dataarray[i].replacement_device,'Replacement Device')) + ','+ //IMEI
    escapeCSV(dataarray[i].display_name,'Display Name');//
    
   
  //  '"",' + //IMEI
    //'""' //IMEI2;
 
rowsFromRequest.push(row);
    }
}
 
 
 
var json = {
    headers: 'RITMNumber,Device Type,Who is currently using the device?,carrier,Cellular Number (found in device settings),IMEI 1/ IMEI 2 Number (found in device settings),Street Address,City,State,Zip Code,Replacement Device(SerialNumber),Display Name\r\n',
    rows: rowsFromRequest
}
 
return json;
 
 
 
function escapeCSV(raw) {
   var value = (raw + '').replace(/"/g,'""');   // escape all double quotes
   value = '"' + value + '"';   // if value has special characters, enclose in double quotes
   return value;
}
function getAssetName(sysID){
var alm = new GlideRecord("alm_asset");
if (alm.get(sysID))
return alm.getDisplayValue();
return "";
 
}                                                                                                                                                                                       
0 REPLIES 0