URL Logger how to trigger ETL

Running AETL from url_logger






The script

const execFileSync = require('child_process').execFileSync;
try {
  // This script might hung so always specify a timeout
  const fileToExecute = '"C:\\Program Files (x86)\\DB Software Laboratory\\Advanced ETL Processor Enterprise\\aetlcl.exe"'
  const objectId = 7158; 
  const parameters = [objectId,logId];
  const timeout = 60; //seconds
  const stdout = execFileSync(fileToExecute, parameters, { shell: true, timeout: timeout*1000 });
} catch (e) {
  logger.error(e.message);
  return 500;
}
return 200;
 

Thank you for the ETL one , I will verify and revert. 

Python would be appreciated too  

I also tried my luck at modifying scripts with chatGPT but URL logger code pages refuses to 'save' this , no errors are given , well you can see the loom video

This is because the maximum size of script is 255 characters.

Let me have a look at it for you

Please install the latest version and follow the upgrade procedure
EG: Set run sql scripts to 1

Also Run

update meta_data set text_field_01 = char_field_02
This will copy "code definition" to new field

 

update meta_data set text_field_01 = char_field_02
This will copy "code definition" to new field

DONE . 

This makes script size bigger than 255? 

Yes, text_field_01 can hold more than 255 characters