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] Sent: Tuesday, April 18, 2017 12:54 PM To: FTPAPI/HTTPAPI mailing list Subject: Re: [Ftpapi] HTTPAPI from an IBM i command line? 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