Forum Discussion

AnthRamDF's avatar
AnthRamDF
User
3 years ago
Solved

MS Access VBA MSXML2.ServerXMLHTTP Response Unreadable

Hi,   I have the API working in PHP, but I now need to add functionality to an Access Database. I have spent the last day searching and have found no solution, I am hoping someone here is able to ...
  • AnthRamDF's avatar
    AnthRamDF
    3 years ago

    For anyone who may have this issue in the future, after more searching I have found a solution.

     

    In VBA the ResponseText is giving the compressed information.

     

    When I remove the line:

    .setRequestHeader "Accept-Encoding", "gzip, deflate"

     

    The response is then displayed correctly.

     

Hannah_B's avatar
Hannah_B
MYOB Moderator
3 years ago

Hi AnthRamDF,

 

Thanks for reaching out, There are a couple of reasons that can cause the error OAuthTokenIsInvalid.

 

I recommend having a look at the support articles below. If this does not resolve the error can you please create a support request with us HERE, And we can have a more in-depth look into what is causing this. 

 

Oauth token is invalid: https://apisupport.myob.com/hc/en-us/articles/360000500035-I-m-getting-the-OAuthTokenIsInvalid-error

 

Refreshing the Access Token: https://apisupport.myob.com/hc/en-us/articles/360000477416-Refreshing-access-tokens-using-the-refresh-tokens

 

 

  • AnthRamDF's avatar
    AnthRamDF
    User
    3 years ago

    Hi Hannah_B ,

     

    Thank you for your reply.

     

    The OAuthTokenIsInvalid is not the problem I am having. I put that in to illustrate I am receiving clear messages when an error is thrown.

     

    My issue is when I try to retreive data eg, company list , with the correct token, I receive garbage returned eg:

    ?  ?`I?%&/m?J?t??`$?@????G#)?*??Ve]f@????????N'?\fdl??!????~|?"???~t6?t?O??Ov?????:??G#}?????YV??"K? ....Shortened.

     

     

     

    • AnthRamDF's avatar
      AnthRamDF
      User
      3 years ago

      For anyone who may have this issue in the future, after more searching I have found a solution.

       

      In VBA the ResponseText is giving the compressed information.

       

      When I remove the line:

      .setRequestHeader "Accept-Encoding", "gzip, deflate"

       

      The response is then displayed correctly.

       

Related content