Accessing custom reports with API

GunveenSingh · October 2020

Hi MYOB Team/Helen,

I'm trying to access custom reports in MYOB via api and i'm unable to figure out the correct url for this. Kindly help with this.

Tried using this URL:

url = "https://ar2.api.myob.com/accountright/*************/Report/MyCustomReports/SOH"

Below was the response:

b'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>\r\n<title>404 - File or directory not found.</title>\r\n<style type="text/css">\r\n<!--\r\nbody{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}\r\nfieldset{padding:0 15px 10px 15px;} \r\nh1{font-size:2.4em;margin:0;color:#FFF;}\r\nh2{font-size:1.7em;margin:0;color:#CC0000;} \r\nh3{font-size:1.2em;margin:10px 0 0 0;color:#000000;} \r\n#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;\r\nbackground-color:#555555;}\r\n#content{margin:0 0 0 2%;position:relative;}\r\n.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}\r\n-->\r\n</style>\r\n</head>\r\n<body>\r\n<div id="header"><h1>Server Error</h1></div>\r\n<div id="content">\r\n <div class="content-container"><fieldset>\r\n  <h2>404 - File or directory not found.</h2>\r\n  <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3>\r\n </fieldset></div>\r\n</div>\r\n</body>\r\n</html>\r\n'

Is there a way to figure out what are the correct names of all the reports stored in the backend so that I can use the correct URL for this request. I checked out sample requests on "https://developer.myob.com/api/accountright/v2/report/" but couldn't figure this.

PFA the screenshot of the Reports window.

GunveenSingh · October 2020

Hi MYOB Team,

Can I get some help on this query? This is impacting development of my business application.

Haydes · October 2020

Hi @GunveenSingh

To preface this post; While I am an employee of MYOB, I do not work with the API Team and am not a direct point of contact for MYOB API support.

However with this, I do not believe that there is currently an endpoint to utilise cutomised reports. Right now these are the only endpoints that can be used to generate reports for you are documented here: https://developer.myob.com/api/accountright/v2/report/

If you're looking at fetching data for a report that isn't a. pre-built one there, it looks like you will need to make a calls to several endpoints in order to correlate the data in your application.

GunveenSingh · October 2020

Thanks for sharing this @Haydes