Forum Discussion

Lakshmi's avatar
Lakshmi
5 years ago

MYOB-Power BI Integration using APIs

I need to connect MYOB Account Right to PowerBI.As there is no direct connector,I am planning to connect using APIs. Is it possible? Please help me if someone use the same.
Lakshmi's avatar
Lakshmi

Thanks Steven_M . I havechecked with the developer team and tried to view data using postman.  I have followed this link https://developer.myob.com/api/accountright/accountright-postman-collection/  .I got access token and refresh token. But in the next step when I am trying to list out the company files, Getting below error.

{
    "Errors": [
        {
            "Name": "OAuthTokenIsMissing",
            "Message": "The supplied OAuth token is missing",
            "AdditionalDetails": "Header",
            "ErrorCode": 31002,
            "Severity": "Error",
            "LearnMore": null
        }
    ],
    "Information": "Warning, error messages have not been finalised in this release and may change"
}
 I am not sure what all details I have to give in headers and authorization. Can you help?
 
Thanks in advance.
 
Lakshmi
Hannah_B's avatar
Hannah_B
MYOB Moderator
5 years ago

Hi Lakshmi (Lakshmi)

 

Thank you for reaching out, We often see this error when you are trying to connect to an old essentials company file however the Essentials file has been upgraded to our New platform.

Once the Essentials file has been upgraded to the new platform we need to complete Oauth with the scope of la.global CompanyFile. This will cover Old Essentials, New Essentials and AccountRight. Then in order to pull the company file, we need to use the endpoint https://api.myob.com/accountright/ which will pull AccountRight and New Essentials files.

 

If this does not resolve the error you can raise a support request with us HERE. 

  • Lakshmi's avatar
    Lakshmi
    5 years ago

    Hi Hannah_B 

    I got access to the company files in postman. I took free developer access. Will it expire? Because I cannot get the access token now which I was getting till friday. 

    • Lakshmi's avatar
      Lakshmi
      5 years ago

      I am not getting the code along with redirect url. Only if i get it i can go for access token and refresh token. I was getting it till last week and i was accessing data also in postman. But now after giving access to app, I am not getting the access code in the redirected page.

      • Hannah_B's avatar
        Hannah_B
        MYOB Moderator
        5 years ago

        Hi Lakshmi,

         

        Thank you for the update, No the Open Developer Access will not expire. I can see you have also raised a developer request with us. I have just replied to this with more information around your error.

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.