|
Thanks Ed! I changed my statement as follows, as you suggested, and this time I got an error message (13 HTTP/1.1 500 Internal Server Error): HTTPAPI URL('http://ghp.ghin.com/ghponline/dataservices/golfermethods.asmx/ClubRoster?username=*****&password=*****&association=*****&club=*****&service=*****&lastName=%20&firstName=%20&gender=%20&activeOnly=*****&includeLowHandicapIndex=*****&includeCombinedClubs=*****&returnDistinctMembers=*****&type3Only=*****')
DOWNLOAD('/meskerr/GHPClubData_Test_04-18-2017_3H.xml')
REQTYPE(*GET) TYPE('text/xml')
DEBUG('/meskerr/xmldebug3H')
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 Roger, I found the documentation for the service here: This is part of your URL: /GHPOnline/DataServices/golferMethods.asmx?op=ClubRoster&username The documentation for the HTTP GET shows that same section looking like this: /ghponline/dataservices/golfermethods.asmx/ClubRoster?username The way they specify the ClubRoster method is different from yours. Try it their way and see if it helps. Also, and I don't know if this will matter, you may
want to make your URL match the same case as shown in the documentation. Ed From:
ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Mesker, Roger [Roger.Mesker@xxxxxxxxxxxxxxxxxx] 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