Forum Discussion
Hi everyone,
Is this fixed? just experience the same issue just right now, I've been calling API for the following but only API under sales invoice having issue with null NextPageLink value
- Sale/Invoice/Item (NextPageLink = null)
- Sale/Invoice/Service (NextPageLink = null)
- Purchase/Bill/Service (NextPageLink = GOOD)
- GeneralLedger/GeneralJournal (NextPageLink = GOOD)
Hoping that this issue will be fixed soon as we need to generate report. Thank you
- SamJiang3 years agoContributing User
Hi,
This issue was fixed by MYOB in the last weekend. But now it's back. I checked my ETL program and I have the same problem, NextPageLink is null.
I have a solution to this issued. I modified my ETL, if NextPageLink is null, my program assembles the NextPageLink for the next request by adding ?$top=400&$skip=xxxx to the end of the request URL, until the returned items is empty.
xxxx is the amount items that have already been processed.
- Nocturnal01073 years agoExperienced Cover User
My work arround is I forced the program to continue calling API until it reached page 30 which is not really ideal if we have tons of records, but i just found another issue
Endpoint Sale/Invoice/Item seems providing different number of Items than the record i requested. My program is always requesting for 1000 records and the Count value can see it but when i count the records on Items, it is not 1000(see item count.png)
But the Endpoint Sale/Invoice/Service is providing the correct record count(see service count.png)
- SamJiang3 years agoContributing User
Hi ,
In my program, only "Sale/Invoice/Item" has this issue, and in some responses , the number of actual returned items is not equal to the count value. But whole returned items is the same as before.
- 3 years ago
Hi All
Just discovered this issue yesterday. 24th November with service invoices Build 2022.10
This gave my clients a lot of headeaches.
Has MYOB confirmed that this will be fixed and if so when?
- MatthewMalcolm3 years agoExperienced User
Hi Mark,
The issue from my perspective is transient. I am randomly getting notifications that random Invoices are no longer in Myob when I run my application. The next time it runs they are there.
As for Myob, have they confirmed this will be fixed. Nope.
They have told us that they have fixed it aover a week agoI will try to re open the case again but with a "This randomly returns the wrong details" type error they will most likely not do much about it.
If you have a hard repeatable issue I suggest that you place a support ticket in the Dev support area for your self and get them to look at that
I personally wish that I was not forced to use the Database in the cloud. The On Premisis API was sooo much more reliable, and did not randomly change for no logged reasonAs to the heaches caused by the suppliers making these random changhes I agree very painful
- The_Doc3 years agoUltimate Cover User
I agree your sentiments re API local file - client only went cloud with their file because of STP2 - since I upgraded my program to do that they get intermittent - 'No Sales' info.
i.e. we noticed there is no sales information on the report - but I am sure it was there last week.
And when I went to check in the weekend - they were there.
I don't use MYOB's code and have my own VBA code - downloading SALES has never been a problem but a quick check looked like my ssytem was looking at an old file and downloading old invoices.
It happened when I initially upgraded their file to online I did my testing on an older version of their file in the cloud - hence older sales - changed the file URI and all fixed - I thought that had magically rehappened.
And then the problem vanished.
hmm - an intermittent problem with the API is not desirable.
regards The Doc
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.