Forum Discussion

AnthRamDF's avatar
AnthRamDF
4 years ago

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
    4 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
4 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
    4 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
      4 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.

       

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content