MYOBCommunity
Partner Zone
|
|
Partner Zone

Get all Debtors (Get all records)

10 REPLIES
Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Accepted Solution Solved Solution

Re: Get all Debtors (Get all records)

@KeranM @Mike_James

 

Setting the page size worked something like this for example

 

https://exo.api.myob.com/debtor?pagesize=25

 

http://developers.myob.com/api/exo/exo-api-overview/retrieving-data/ 

Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Re: Get all Debtors (Get all records)

Thanks have sent an email to that address

API Evangelist KeranM
265 Posts
API Evangelist
Australia
KeranM
API Evangelist

265Posts

80Kudos

53Solutions

Re: Get all Debtors (Get all records)

Hi there

 

Sorry, I had sent this through to the EXO developer support team to help you with. I sent you off on the wrong path sorry, thinking you were working with different APIs.

 

If you drop an email to the EXO API Developers  on exoapidevelopers@myob.com they will be able to help you

Keran McKenzie
Futurist in residence @MYOB

Are you a developer? Check out http://developer.myob.com
Looking for an Add-on? Check out http://myob.com/addons/

Twitter: @myobapi | @keranm
Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Re: Get all Debtors (Get all records)

Bump? Do you have an answer to my question regarding any limitation or solution to this question??

Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Re: Get all Debtors (Get all records)

Regarding using $top:

 

/Debtor/?$top=1000

 

Still getting 10 records, is there some limitation with the API?

Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Re: Get all Debtors (Get all records)

We are using:

MYOB Exo.

http://developer.myob.com/api/exo/endpoints/debtor/

 

I am only getting 10 records currently out of 340 when using {URI}/debtor/ on the MYOB Exo

API Evangelist KeranM
265 Posts
API Evangelist
Australia
KeranM
API Evangelist

265Posts

80Kudos

53Solutions

Re: Get all Debtors (Get all records)

Oh wait - /debtor/  ?

Which API are you using? 

 

MYOB Essentials

MYOB AccountRight

MYOB Exo

MYOB Advanced

 

Mike and I were talking about AccountRight - but there is no debtor endpoint, you get debtors differently in AccountRight (sorry I miss read your original post)

Keran McKenzie
Futurist in residence @MYOB

Are you a developer? Check out http://developer.myob.com
Looking for an Add-on? Check out http://myob.com/addons/

Twitter: @myobapi | @keranm
Contributing User leonard_xenia
7 Posts
Contributing User
New Zealand
leonard_xenia
Contributing User

7Posts

0Kudos

1Solutions

Re: Get all Debtors (Get all records)

Thanks for the quick response you would not happen to be able to show an example of this for the endpoint: {URI}/debtor/

 

In the mean time Ill look into that.

API Evangelist KeranM
265 Posts
API Evangelist
Australia
KeranM
API Evangelist

265Posts

80Kudos

53Solutions

Re: Get all Debtors (Get all records)

Yes Mike is right you need to explore using TOP and SKIP to get the results. There is also a URI in the body that gives you the call for the next page of results to make it easier for you Smiley Happy

 

One clarification on Mike's comment, 1,000 is the maximum returned PER PAGE, not total. You can get all results, but they will be paged, to a maximum of 1,000 per page 

 

Hope that helps

Keran McKenzie
Futurist in residence @MYOB

Are you a developer? Check out http://developer.myob.com
Looking for an Add-on? Check out http://myob.com/addons/

Twitter: @myobapi | @keranm
Ultimate Partner Mike_James
3,717 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

3717Posts

1518Kudos

453Solutions

Re: Get all Debtors (Get all records)

Hi @leonard_xenia, by default you will only get the first 400 results; you need to include TOP and SKIP in your url, and note that the maximum number of results you can get is 1000.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post