Innov-AI
    Documentation | MentDB Weak Server
Generate MQL to DOWNLOAD files from a remote sFTP connection

  • To generate MQL to DOWNLOAD files from a remote sFTP connection:
  • Right click on 'demo_cm_sftp' and select 'GEN > DOWNLOAD FILES'
  • script create post "demo.file.sftp.download" false 1 
      (param
      	(var "[remoteDirectory]" {true} "The remote directory" is_null:false is_empty:false "/Users/jimmitry/Desktop")
      	(var "[filter]" {true} "The file filter from the remote directory" is_null:false is_empty:false "*png")
      	(var "[localDirectory]" {true} "The local directory" is_null:false is_empty:false "/Users/jimmitry/Desktop/ftp")
      ;) 
      "Download file through SFTP" 
    {
    
    	try {
    
    		#Connect to the SFTP server;
    		sftp connect "session1" {cm get "demo_cm_sftp";};
    
    		#Move to the remote directory;
    		sftp cd "session1" [remoteDirectory];
    
    		#Get all remote files;
    		json load "files" (sftp ls "session1" [filter]);
    
    		#Get all files;
    		-> "[nbFiles]" (json count "files" "/");
    		for (-> "[i]" 0) (< [i] [nbFiles]) (++ "[i]") {
    
    			-> "[filename]" (json select "files" (concat "/[" [i] "]/name"));
    		
    			sftp get "session1" [filename] (concat [localDirectory] "/" [filename]);
    		
    		};
    
    		sftp disconnect "session1";
    	
    	} {
    	
    		#Close objects;
    		try {sftp disconnect "session1";} {} "[sub_err]";
    
    		#Generate an error;
    		exception (1) ([err]);
    	
    	} "[err]";
    	
    	
    } "Return nothing";
  • Update the script and save
  • Execute buttons
Services     Supporters     Contact     About     Legal notice © 2024