Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

------------------------------
Michael Soucy
Sr Midrange Engineer
Bangor Savings Bank
Bangor ME
------------------------------


Original Message:
Sent: Thu April 09, 2026 02:04 PM
From: Daniel Gross
Subject: REST call from IBMi to a MS SQL Server database

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I think I'm getting closer. The error is saying I need an SSL certificate.  I put the SSL cert into DCM following the instructions here:

Configuring IBM i DB2 QSYS2 HTTP Functions for TLS/HTTPS Secure Communications

When I run this RPG code it creates a file on the IFS, but it's empty.  Could our Firewall be blocking me from connecting to ofac.treas.gov?

ctl-opt dftactgrp(*no);                                                     
                                                                            
dcl-s ifs_file sqltype(CLOB_FILE);                                          
dcl-c url 'https://sanctionslistservice.ofac.treas.gov/api/download/-       
cons_add.csv';                                                              
                                                                            
ifs_file_fo = SQFOVR; // overwrite file contents                            
ifs_file_name = '/JHA/JHAOFAC/cons_add.csv';                            
ifs_file_nl = %len(%trimr(ifs_file_name));                                  
                                                                            
exec sql set :ifs_file =                                                    
http_get(:url,'{"sslTolerate":"true"}');                                    
                                                                            
if sqlcode <> *zero;                                                        
 // error                                                                   
endif;                                                                      
                                                                            
*inlr = *on;                                                                

Thank you!

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I think I'm getting closer. The error is saying I need an SSL certificate.  I put the SSL cert into DCM following the instructions here:

Configuring IBM i DB2 QSYS2 HTTP Functions for TLS/HTTPS Secure Communications

When I run this RPG code it creates a file on the IFS, but it's empty.  Could our Firewall be blocking me from connecting to ofac.treas.gov?

ctl-opt dftactgrp(*no);                                                     
                                                                            
dcl-s ifs_file sqltype(CLOB_FILE);                                          
dcl-c url 'https://sanctionslistservice.ofac.treas.gov/api/download/-       
cons_add.csv';                                                              
                                                                            
ifs_file_fo = SQFOVR; // overwrite file contents                            
ifs_file_name = '/JHA/JHAOFAC/cons_add.csv';                            
ifs_file_nl = %len(%trimr(ifs_file_name));                                  
                                                                            
exec sql set :ifs_file =                                                    
http_get(:url,'{"sslTolerate":"true"}');                                    
                                                                            
if sqlcode <> *zero;                                                        
 // error                                                                   
endif;                                                                      
                                                                            
*inlr = *on;                                                                

Thank you!

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I ended up opening a case with IBM.  We were able to figure out what the issues were by looking at some logs. The items I was missing was I had to add "redirect":"5" to the call parameters and that did it. I updated the RPG code you provided and was able to prove that I could download all 7 files to the IFS.  This is my RPG code.  I'm going to clean it up, and change the IFS folder to where it actually needs to go to for the Jack Henry OFAC process.  Thank you for your help with this!

**FREE
       ctl-opt dftactgrp(*no);

       dcl-s ifs_file sqltype(CLOB_FILE);

       ifs_file_fo = SQFOVR; // overwrite file contents
       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.xml';
       ifs_file_nl = %len(%trimr(ifs_file_name));

       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.xml',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_add.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_add.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_alt.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_alt.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_prim.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_prim.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/alt.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/alt.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/add.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/add.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

Hi Daniel,

I think I'm getting closer. The error is saying I need an SSL certificate.  I put the SSL cert into DCM following the instructions here:

Configuring IBM i DB2 QSYS2 HTTP Functions for TLS/HTTPS Secure Communications

When I run this RPG code it creates a file on the IFS, but it's empty.  Could our Firewall be blocking me from connecting to ofac.treas.gov?

ctl-opt dftactgrp(*no);                                                     
                                                                            
dcl-s ifs_file sqltype(CLOB_FILE);                                          
dcl-c url 'https://sanctionslistservice.ofac.treas.gov/api/download/-       
cons_add.csv';                                                              
                                                                            
ifs_file_fo = SQFOVR; // overwrite file contents                            
ifs_file_name = '/JHA/JHAOFAC/cons_add.csv';                            
ifs_file_nl = %len(%trimr(ifs_file_name));                                  
                                                                            
exec sql set :ifs_file =                                                    
http_get(:url,'{"sslTolerate":"true"}');                                    
                                                                            
if sqlcode <> *zero;                                                        
 // error                                                                   
endif;                                                                      
                                                                            
*inlr = *on;                                                                

Thank you!

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I ended up opening a case with IBM.  We were able to figure out what the issues were by looking at some logs. The items I was missing was I had to add "redirect":"5" to the call parameters and that did it. I updated the RPG code you provided and was able to prove that I could download all 7 files to the IFS.  This is my RPG code.  I'm going to clean it up, and change the IFS folder to where it actually needs to go to for the Jack Henry OFAC process.  Thank you for your help with this!

**FREE
       ctl-opt dftactgrp(*no);

       dcl-s ifs_file sqltype(CLOB_FILE);

       ifs_file_fo = SQFOVR; // overwrite file contents
       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.xml';
       ifs_file_nl = %len(%trimr(ifs_file_name));

       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.xml',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_add.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_add.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_alt.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_alt.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_prim.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_prim.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/alt.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/alt.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/add.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/add.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

Hi Daniel,

I think I'm getting closer. The error is saying I need an SSL certificate.  I put the SSL cert into DCM following the instructions here:

Configuring IBM i DB2 QSYS2 HTTP Functions for TLS/HTTPS Secure Communications

When I run this RPG code it creates a file on the IFS, but it's empty.  Could our Firewall be blocking me from connecting to ofac.treas.gov?

ctl-opt dftactgrp(*no);                                                     
                                                                            
dcl-s ifs_file sqltype(CLOB_FILE);                                          
dcl-c url 'https://sanctionslistservice.ofac.treas.gov/api/download/-       
cons_add.csv';                                                              
                                                                            
ifs_file_fo = SQFOVR; // overwrite file contents                            
ifs_file_name = '/JHA/JHAOFAC/cons_add.csv';                            
ifs_file_nl = %len(%trimr(ifs_file_name));                                  
                                                                            
exec sql set :ifs_file =                                                    
http_get(:url,'{"sslTolerate":"true"}');                                    
                                                                            
if sqlcode <> *zero;                                                        
 // error                                                                   
endif;                                                                      
                                                                            
*inlr = *on;                                                                

Thank you!

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

One more thing I wanted to share with you regarding this process.  When went to run the Jack Henry process that uses these files it failed.  It said it could not read the file. What I discovered was that the character set ID was 1208.  I checked the character set of what the files were when I downloaded them manually via Postmam they were 437.  I created a sub procedure in the RPG program to change the character set ID and that fixed the problem.  

Here's my code:

       // --------------------------------------------------
       // Procedure name: ChangeCharSet
       // Purpose:        Change the IFS file to the correct character set
       // Returns:
       // Parameter:      p1_ifs_file_name
       // --------------------------------------------------
       dcl-proc ChangeCharSet;
         dcl-pi *N;
           p1_ifs_file_name CHAR(255);
         end-pi;

         // Local fields
         dcl-c CHGATR 'CHGATR OBJ(''%IFS_FILE%'') ATR(*CCSID) VALUE(437)';

         // Calculation specifications
         CmdString = CHGATR;
         CmdString = %scanrpl('%IFS_FILE%':%trim(p1_ifs_file_name):CmdString);

         Monitor;
           Command(%trimr(CmdString):%len(%trimr(CmdString)));
         on-error;
         endmon;

         return;
       end-proc;        

Thank you again for all your help with this.  It has been a great learning experience for me.

Hi Daniel,

I ended up opening a case with IBM.  We were able to figure out what the issues were by looking at some logs. The items I was missing was I had to add "redirect":"5" to the call parameters and that did it. I updated the RPG code you provided and was able to prove that I could download all 7 files to the IFS.  This is my RPG code.  I'm going to clean it up, and change the IFS folder to where it actually needs to go to for the Jack Henry OFAC process.  Thank you for your help with this!

**FREE
       ctl-opt dftactgrp(*no);

       dcl-s ifs_file sqltype(CLOB_FILE);

       ifs_file_fo = SQFOVR; // overwrite file contents
       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.xml';
       ifs_file_nl = %len(%trimr(ifs_file_name));

       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.xml',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_add.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_add.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_alt.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_alt.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;

       ifs_file_name = '/SOUCYMI/JHAOFAC/cons_prim.csv';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/cons_prim.csv',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/alt.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/alt.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/add.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/add.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

       ifs_file_name = '/SOUCYMI/JHAOFAC/sdn.ff';
       ifs_file_nl = %len(%trimr(ifs_file_name));
       exec sql set :ifs_file =
         http_get('https://sanctionslistservice.ofac.treas.gov/api/download/sdn.ff',
             '{"sslTolerate":"true", "redirect":"5"}');

       if sqlcode <> *zero;
        // error
       endif;
       *inlr = *on;

Hi Daniel,

I think I'm getting closer. The error is saying I need an SSL certificate.  I put the SSL cert into DCM following the instructions here:

Configuring IBM i DB2 QSYS2 HTTP Functions for TLS/HTTPS Secure Communications

When I run this RPG code it creates a file on the IFS, but it's empty.  Could our Firewall be blocking me from connecting to ofac.treas.gov?

ctl-opt dftactgrp(*no);                                                     
                                                                            
dcl-s ifs_file sqltype(CLOB_FILE);                                          
dcl-c url 'https://sanctionslistservice.ofac.treas.gov/api/download/-       
cons_add.csv';                                                              
                                                                            
ifs_file_fo = SQFOVR; // overwrite file contents                            
ifs_file_name = '/JHA/JHAOFAC/cons_add.csv';                            
ifs_file_nl = %len(%trimr(ifs_file_name));                                  
                                                                            
exec sql set :ifs_file =                                                    
http_get(:url,'{"sslTolerate":"true"}');                                    
                                                                            
if sqlcode <> *zero;                                                        
 // error                                                                   
endif;                                                                      
                                                                            
*inlr = *on;                                                                

Thank you!

Hi Daniel Gross,

I wrote an RPG program using your code.  When I try and run it, I get a sqlcode error -443. That seems to indicate that I need a certificate to download do the HTTP_GET function. How do I save the results to a file on the IFS after the HTTP_GET?

Thank you!

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.

Hi Daniel,

I appreciate your offer to help me.  Using these HTTP calls is all new to me.  I seem to be struggling on how this works.  I was hoping to find some examples in the ACS SQL tool, but I didn't see any. 

Thank you!

Can you use HTTP_GET for something simple as downloading a file a webservice?  I had been working on a GoAnywhere project for something else I've gotten stuck. I wonder if the HTTP_GET would be easier.  I can download the files using Postman, but I would be better if I could do it directly on the IBMi.  This is what I put in for a GET operation in Postman and it worked.

https://sanctionslistservice.ofac.treas.gov/api/download/{filename}

{filename} is the OFAC file I need to download. 

Would this be simpler using HTTP_GET?  I'd like the results to put into a file on the IFS.