Are you aware of library called SYSTOOLS ? Can execute web service call from SQLRPGLE program, the SQL statement can also be run from STRSQL, Surveyor, IBM I Access run SQL script The beauty is call web service, XMLTABLE, XMLPARSE, parse result set with minimum coding effort Example calling BBC News
ctl-opt Option(*SrcStmt:*NoDebugIO)
CCSID(*CHAR:37) ;
dcl-ds BBCNewsData qualified dim(50) inz ;
Title varchar(128) ;
Description varchar(1024) ;
Link varchar(255) ;
Published varchar(20) ;
end-ds ;
EXEC SQL
DECLARE BBC_Cur CURSOR FOR
SELECT * FROM XMLTABLE('$result/rss/channel/item'
PASSING XMLPARSE(
DOCUMENT
SYSTOOLS.HTTPGETCLOB( 'http://feeds.bbci.co.uk/news/world/rss.xml?edition=uk','')
) as "result"
COLUMNS
title varchar(128) PATH 'title' ,
description varchar(1024) PATH 'description' ,
link varchar(255) PATH 'link' ,
pubDate varchar(20) PATH 'substring(pubDate,1,16) '
) AS RESULT ; EXEC SQL OPEN BBC_Cur ;
EXEC SQL
FETCH NEXT FROM BBC_Cur
FOR 50 ROWS INTO :BBCNewsData ;
EXEC SQL CLOSE BBC_Cur ;
*inlr = *on ;
return ;
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx]
On Behalf Of Mesker, Roger Hello again Ed! I made the additional modifications you had suggested for using the HTTPAPI Command on the IBM i command line, and it still does not seem to recognize the Parameters. Any additional help you can offer will be greatly appreciated. HTTPAPI URL('http://ghp.ghin.com/GHPOnline/DataServices/golferMethods.asmx?op=ClubRoster&username=*********&password=**********&association=*****&club=*****&service=*****&lastName=%20&firstName=%20&gender=%20&activeOnly=**********&includeLowHandicapIndex=**********&includeCombinedClubs=**********&returnDistinctMembers=**********&type3Only=***********') DOWNLOAD('/meskerr/GHPClubData_Test_04-18-2017_3F.xml')
REQTYPE(*GET) TYPE('text/xml') DEBUG('/meskerr/xmldebug3F')
Roger Mesker IBM i Programmer / Analyst | The Villages® Technology Solutions Group Direct: 352.674.1562 | Support: 352.674.1530 -----Original Message----- Ed, Thank you very much, I will modify my process accordingly, and let you all know how it comes out.
Roger ______________________________________ From:
ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] on behalf of Ed DeRyder [EDeRyder@xxxxxxxxxxxxxxxxxxxxxxxx] Sent: Thursday, April 13, 2017 5:27 PM To: FTPAPI/HTTPAPI mailing list Subject: Re: [Ftpapi] HTTPAPI from an IBM i command line? As Kevin said in his other email, if you need spaces, they should be URL-encoded: %20 It's my experience that parameters are typically separated by ampersands like this, though: golferMethods.asmx?/op=ClubRoster&username=**********&password=**********&association=***&club=*** You should have some way of seeing this in documentation from the website, possibly even in the response you're getting back. Ed ________________________________ From:
ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Mesker, Roger [Roger.Mesker@xxxxxxxxxxxxxxxxxx] Sent: Thursday, April 13, 2017 4:11 PM To: FTPAPI/HTTPAPI mailing list Subject: Re: [Ftpapi] HTTPAPI from an IBM i command line? Ed, Yes, I do have spaces, and not ampersands. Should I be using ampersands in between the parameters? Roger Mesker IBM i Programmer / Analyst | The Villages® Technology Solutions Group Direct: 352.674.1562 | Support: 352.674.1530 From:
ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx]
On Behalf Of Ed DeRyder Sent: Thursday, April 13, 2017 3:46 PM To: FTPAPI/HTTPAPI mailing list Subject: Re: [Ftpapi] HTTPAPI from an IBM i command line? Roger, I'm a relative newbie to this, but one thing I see is that you have spaces between your parameters, not ampersands. Is that how you're sending the URL or was that just how you edited it for your email? Ed ________________________________ From:
ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx<mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx> [ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Mesker, Roger [Roger.Mesker@xxxxxxxxxxxxxxxxxx] Sent: Thursday, April 13, 2017 2:07 PM To: 'ftpapi@xxxxxxxxxxxxxxxxxxxxxx' Subject: Re: [Ftpapi] HTTPAPI from an IBM i command line? Hello Scott! Thank you so much for all of your contributions to the world. Your generosity in sharing your knowledge and time are a tremendous asset to everyone. We are huge fans of yours here at The Villages. I have been working on invoking the HTTPAPI command from an IBM I command line, and while I can get it to make the connection to the outside server, it is only returning a listing of the available Methods, and not the .xml data I am
looking for. I have tried multiple ways, and so far, all I get is the same result. Here is an example of a “get” I have been running. Any advice, and/or help you can offer will be GREATLY appreciated. HTTPAPI URL('http://ghp.ghin.com/GHPOnline/DataServices/golferMethods.asmx?/op=ClubRoster username=********** password=********** association=*** club=*** service=*** activeOnly=***** includeLowHandicapIndex=***** includeCombinedClubs=*****
returnDistinctMembers=***** type3Only=*****') DOWNLOAD('/meskerr/GHPClubData_Test_04-13-2017_17.xml') REQTYPE(*GET) TYPE('text/xml') PROXYUSER('**********') PROXYPASS('**********') DEBUG('/meskerr/xmldebug1H/') Everything in the URL between the ClubRoster? and the DOWNLOAD are parameters required to access and return the xml data to the IBM I IFS folder. I asterisked out all of the sensitive data within the URL string. Do the parameters
within the URL string have to be single or double quoted? I have tried multiple variations of the command, using both Get & Post, and so far, I have not been successful in getting any of them to return the actual data. NOTE: I even tried SoapUI tool, and still received the same results there. Best regards, [tsg-color (003)] Roger Mesker IBM i Programmer/Analyst | The Villages® Technology Solutions Group 1026 Canal Street | The Villages, FL 32162 Main: 352.750.1515 | Support: 352.674.1530 Direct: 352.674.1562 | Fax: 352.750.1616
Roger.mesker@xxxxxxxxxxxxxxxxxx<mailto:Roger.mesker@xxxxxxxxxxxxxxxxxx> |
http://www.TheVillagesTSG.com<http://www.thevillagestsg.com/> |
-- _______________________________________________ Ftpapi mailing list Ftpapi@xxxxxxxxxxxxxxxxxxxxxx http://scottklement.com/mailman/listinfo/ftpapi