Avatar of Jeff Collins
Jeff Collins
Flag for Australia asked on

VB6 Web Service MSXML Returning ERROR CODE 400 in response text.

Trying to get a session code response from the Betfair site using VB6. My software, which I've written and been using in a particular industry for 20 years, therefore huge amount of code, so trying to do it through VB6, and I've done other XML feeds using the Web Service, which are working really well.

So.... the issue is, i make a call to the site, and the return I get is HTTP ERROR CODE 400 through the response text.

Part of the process, required I create a certificate, using OPENSSL , which worked fine, and the certificate uploaded to my test account on Betfair, and the account has been enabled for access. I've also sent the P12 Key to my certificate store on my local Windows 7 (32 Bit) development computer, which allowed the call to go through without any "Certificate Required" prompts, so appears to get through that part. However, once through the response coming back is "HTTP ERROR CODE 400", in the response text. So it's not making my code fall over in any way, just not returning a session key, which is obviously required to proceed further.

The code is as follows, of which a username and password string is passed to the function from a login form.

Public Function GetBetfairSessionID(sUserName As String, sPassword As String) As BetfairSessionInfo
    Dim myMSXML As MSXML2.XMLHTTP60
    
    Dim AuthURL As String

    AuthURL = "https://identitysso.betfair.com/api/certlogin"
    Set myMSXML = CreateObject("MSXML2.ServerXMLHTTP")
    
    'myMSXML.setTimeouts 30000, 30000, 0, 0
    
    myMSXML.open "POST", AuthURL, False
    myMSXML.setRequestHeader "Accept", "application/json"
    myMSXML.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    myMSXML.setRequestHeader "X-Application", [MY APPLICATION KEY AS GENERATED THROUGH BETFAIR]
    
    myMSXML.send "userName=" & sUserName & "&password=" & sPassword
            
    MsgBox myMSXML.responseText

   ............ More code follows, but not valid as Response Text not returning Session ID etc...

End Function

Open in new window


Documentation for the Non-Interactive Login is available at:

https://docs.developer.betfair.com/display/1smk3cen4v3lu3yomq5qye0ni/Non-Interactive+%28bot%29+login

Regards
SoftwareWindows OSWeb ServicesXMLVisual Basic Classic

Avatar of undefined
Last Comment
Joe Howard

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Joe Howard

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: ste5an (https:#a42663947)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes