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?
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 ago
I 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 reason
As to the heaches caused by the suppliers making these random changhes I agree very painful
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
Hi Matthew
Thanks for you comments.
I have this issue with one client using Local Library as well. The issue in this case is not random, As I have a log that records the api call made and result, and have had constant results over the last week.
As it's month end I think I will just do my own Nextpage url generation, and move on.
I will log a support call and hope ...
Hi
I have done a whole lot more testing on the API NextPageLink issue and found another strange result
Anybodu else having issues still?
MWC20221130 API Sales data retrieval notes and errors
Tests done on Item and Service Sales
Tests done on Cloud and Library files.
NB results of json returned every call saved to a text file saved in a folder
2 Main Issues:
1 - NexPage url not being created
2 - NextPage Url correct but pattern of small set of transactions returned.
3 - Different results based on different Filters used
1 - NexPage url not being created
Tested on Library and Cloud file with same result
Sale Invoice Service on Library file returned no NexPage url
I added my own code to generate NextPAgeUrl and data was returned correctly, so workaround solution ok.
URLs used :
1) Dates between
sUrl = Replace(dwrcompany.dwrMYXUri,"localhost",dwrcompany.dwrMYXServer) + "/Sale/Invoice/Service?$top=1000&$filter=Date ge datetime'"+ DateToString(gdDateFrom,"YYYY-MM-DD") + " and Date le datetime'" + DateToString(gdDateTo,"YYYY-MM-DD") + "'"
2) Date equal and greater than
sUrl = Replace(dwrcompany.dwrMYXUri,"localhost",dwrcompany.dwrMYXServer) + "/Sale/Invoice/Service?$filter=Date ge datetime'"+ DateToString(gdDateFrom,"YYYY-MM-DD") + "'"
I added my own code to generate NextPAgeUrl and data was returned correctly, so workaround solution ok.
2 - Sale Invoice Item
Url's Used
Test results below on large Cloud file
In both tests exact copies of my code used with only diffrence being url
1) Filter based on "Modified" field ( Transaction modified date)
Worked perfectly collecting data correctly as shown in logs below
Below is result of "Modified" call which worked fine for 1,5 hours untill it was stopped at the stikjee of midnight. ( presumably deliberately by some MYOB process)
start sale item_modified
400 of 60979 SKIP: 400 NextPageSkip: 400 PageSkip: 400
800 of 60979 SKIP: 800 NextPageSkip: 800 PageSkip: 400
1200 of 60979 SKIP: 1200 NextPageSkip: 1200 PageSkip: 400
1600 of 60979 SKIP: 1600 NextPageSkip: 1600 PageSkip: 400
2000 of 60979 SKIP: 2000 NextPageSkip: 2000 PageSkip: 400
2400 of 60979 SKIP: 2400 NextPageSkip: 2400 PageSkip: 400
2800 of 60979 SKIP: 2800 NextPageSkip: 2800 PageSkip: 400
3200 of 60979 SKIP: 3200 NextPageSkip: 3200 PageSkip: 400
3600 of 60979 SKIP: 3600 NextPageSkip: 3600 PageSkip: 400
4000 of 60979 SKIP: 4000 NextPageSkip: 4000 PageSkip: 400
4400 of 60979 SKIP: 4400 NextPageSkip: 4400 PageSkip: 400
4800 of 60979 SKIP: 4800 NextPageSkip: 4800 PageSkip: 400
5200 of 60979 SKIP: 5200 NextPageSkip: 5200 PageSkip: 400
5600 of 60979 SKIP: 5600 NextPageSkip: 5600 PageSkip: 400
6000 of 60979 SKIP: 6000 NextPageSkip: 6000 PageSkip: 400
6400 of 60979 SKIP: 6400 NextPageSkip: 6400 PageSkip: 400
6800 of 60979 SKIP: 6800 NextPageSkip: 6800 PageSkip: 400
... middle lines excluded for brevity
50800 of 60979 SKIP: 50800 NextPageSkip: 50800 PageSkip: 400
51200 of 60979 SKIP: 51200 NextPageSkip: 51200 PageSkip: 400
51600 of 60979 SKIP: 51600 NextPageSkip: 51600 PageSkip: 400
52000 of 60979 SKIP: 52000 NextPageSkip: 52000 PageSkip: 400
52400 of 60979 SKIP: 52400 NextPageSkip: 52400 PageSkip: 400
52800 of 60979 SKIP: 52800 NextPageSkip: 52800 PageSkip: 400
53200 of 60979 SKIP: 53200 NextPageSkip: 53200 PageSkip: 400
53600 of 60979 SKIP: 53600 NextPageSkip: 53600 PageSkip: 400
54000 of 60979 SKIP: 54000 NextPageSkip: 54000 PageSkip: 400
54400 of 60979 SKIP: 54400 NextPageSkip: 54400 PageSkip: 400
54800 of 60979 SKIP: 54800 NextPageSkip: 54800 PageSkip: 400
55200 of 60979 SKIP: 55200 NextPageSkip: 55200 PageSkip: 400
Retry 1<\r><\n>{"message": "Network error communicating with endpoint"}1
JSON error: 0 Skipped
Note below that all returned file sizes or similar and differe based on number of lines per invoice
Name Date modified Type Size
i. api_N1yJson_0.txt 29/11/202211:59 pm TXTFile 1 KB
il api_SalelnvoiceltemMod_55200.txt 29/11/202211:59 pm TXTFile 1 KB
il api_SalelnvoiceltemMod_54800.txt 29/11/2022 11:58 pm TXTFile 2,150 KB
il api_SalelnvoiceltemMod_54400.txt 29/11/202211:57 pm TXTFile 1,992 KB
il api_SalelnvoiceltemMod_54000.txt 29/11/202211:57 pm TXTFile 2,234 KB
il api_SalelnvoiceltemMod_53600.txt 29/11/202211:57 pm TXTFile 2,277 KB
il api_SalelnvoiceltemMod_53200.txt 29/11/202211:56 pm TXTFile 2,293 KB
il api_SalelnvoiceltemMod_52800.txt 29/11/202211:56 pm TXTFile 2,291 KB
il api_SalelnvoiceltemMod_52400.txt 29/11/202211:55 pm TXTFile 1,914 KB
il api_SalelnvoiceltemMod_52000.txt 29/11/202211:55 pm TXTFile 2,201 KB
il api_SalelnvoiceltemMod_51600.txt 29/11/202211:54 pm TXTFile 2,181 KB
il api_SalelnvoiceltemMod_51200.txt 29/11/202211:54 pm TXTFile 2,276 KB
il api_SalelnvoiceltemMod_50800.txt 29/11/2022 11:53 pm TXTFile 2,262 KB
... middle lines excluded for brevity
il api_SalelnvoiceltemMod_6800.txt 29/11/2022 10:57 pm TXTFile 2,167 KB
il api_SalelnvoiceltemMod_6400.txt 29/11/2022 10:56 pm TXTFile 2,245 KB
il api_SalelnvoiceltemMod_6000.txt 29/11/2022 10:56 pm TXTFile 2,328 KB
il api_SalelnvoiceltemMod_5600.txt 29/11/2022 10:55 pm TXTFile 2,120 KB
il api_SalelnvoiceltemMod_5200.txt 29/11/2022 10:55 pm TXTFile 2,024 KB
il api_SalelnvoiceltemMod_4800.txt 29/11/2022 10:54 pm TXTFile 2,125 KB
il api_SalelnvoiceltemMod_4400.txt 29/11/2022 10:54 pm TXTFile 2,254 KB
il api_SalelnvoiceltemMod_4000.txt 29/11/2022 10:53 pm TXTFile 1,977 KB
il api_SalelnvoiceltemMod_3600.txt 29/11/2022 10:53 pm TXTFile 1,712 KB
il api_SalelnvoiceltemMod_3200.txt 29/11/2022 10:52 pm TXTFile 1,839 KB
il api_SalelnvoiceltemMod_2800.txt 29/11/2022 10:52 pm TXTFile 2,033 KB
il api_SalelnvoiceltemMod_2400.txt 29/11/2022 10:51 pm TXTFile 2,180 KB
il api_SalelnvoiceltemMod_2000.txt 29/11/2022 10:51 pm TXTFile 1,852 KB
il api_SalelnvoiceltemMod_1600.txt 29/11/2022 10:50 pm TXTFile 1,473 KB
il api_SalelnvoiceltemMod_1200.txt 29/11/2022 10:50 pm TXTFile 1,750 KB
il api_SalelnvoiceltemMod_800.txt 29/11/2022 10:49 pm TXTFile 1,954 KB
il api_SalelnvoiceltemMod_400.txt 29/11/2022 10:49 pm TXTFile 2,072 KB
il api_SalelnvoiceltemMod_0.txt 29/11/2022 10:48 pm TXTFile 1,787 KB
il api_TestCompany.txt 29/11/2022 10:47 pm TXTFile 1 KB
2) Url based on "Date" field (Transaction Date)
https://ar2.api.myob.com/accountright/49ff204f-cf26-4fd0-9748-9acab9071154/Sale/Invoice/Item?$top=400&$skip=18400&$filter=Date%20ge%20datetime%272021-04-01T00%3A00%3A00.000%27
Note very carefully the sizes of the returned data and see how it follows a pattern of small returns of 30 transactions to 400 and back to 70 and then back to 400 every 8 or so calls
YOu have to see this to believe it!
The nextpage link was generated in the json in each case with a slkip value of 400
I have put blank lines to show the "waves"
The suffix on th efile name shows actual number of records processed as a running total
Name Date modified Type Size
il api_Salelnvoiceltem_0.txt 29/11/2022 4:09 pm TXTFile 174 KB processed 33 invoices
il api_Salelnvoiceltem_33.txt 29/11/2022 4:09 pm TXTFile 162 KB processed 32invoices
il api_Salelnvoiceltem_65.txt 29/11/2022 4:09 pm TXTFile 153 KB processed 30 invoices
il api_Salelnvoiceltem_95.txt 29/11/2022 4:09 pm TXTFile 2,750 KB processed 368 invoices
il api_Salelnvoiceltem_463.txt 29/11/2022 4:09 pm TXTFile 3,098 KB processed 400 invoices
il api_Salelnvoiceltem_863.txt 29/11/2022 4:09 pm TXTFile 2,939 KB processed 400 invoices
il api_Salelnvoiceltem_1263.txt 29/11/2022 4:10 pm TXTFile 3,017 KB processed 400 invoices
il api_Salelnvoiceltem_1663.txt 29/11/2022 4:10 pm TXTFile 2,949 KB processed 400 invoices
il api_Salelnvoiceltem_2063.txt 29/11/2022 4:10 pm TXTFile 822 KB processed 110 invoices
il api_Salelnvoiceltem_2173.txt 29/11/2022 4:10 pm TXTFile 262 KB processed 44 invoices
il api_Salelnvoiceltem_2218.txt 29/11/2022 4:10 pm TXTFile 20 KB processed 4 invoices
il api_Salelnvoiceltem_2222.txt 29/11/2022 4:10 pm TXTFile 73 KB processed 7 invoices
il api_Salelnvoiceltem_2229.txt 29/11/2022 4:10 pm TXTFile 1,506 KB processed 227 invoices
il api_Salelnvoiceltem_2456.txt 29/11/2022 4:10 pm TXTFile 2,901 KB processed 400 invoices
il api_Salelnvoiceltem_2856.txt 29/11/2022 4:10 pm TXTFile 2,967 KB processed 400 invoices
il api_Salelnvoiceltem_3256.txt 29/11/2022 4:10 pm TXTFile 2,956 KB processed 400 invoices
il api_Salelnvoiceltem_3656.txt 29/11/2022 4:10 pm TXTFile 2,965 KB processed 400 invoices
il api_Salelnvoiceltem_4056.txt 29/11/2022 4:10 pm TXTFile 2,138 KB processed 400 invoices
il api_Salelnvoiceltem_4352.txt 29/11/2022 4:10 pm TXTFile 314 KB etc etc
il api_Salelnvoiceltem_4405.txt 29/11/2022 4:11 pm TXTFile 82 KB
il api_Salelnvoiceltem_4421.txt 29/11/2022 4:20 pm TXTFile 631 KB
il api_Salelnvoiceltem_4510.txt 29/11/2022 4:20 pm TXTFile 3,022 KB
il api_Salelnvoiceltem_4910.txt 29/11/2022 4:20 pm TXTFile 2,910 KB
il api_Salelnvoiceltem_5310.txt 29/11/2022 4:20 pm TXTFile 3,045 KB
il api_Salelnvoiceltem_5710.txt 29/11/2022 4:20 pm TXTFile 3,064 KB
il api_Salelnvoiceltem_6110.txt 29/11/2022 4:20 pm TXTFile 2,941 KB
il api_Salelnvoiceltem_6510.txt 29/11/2022 4:20 pm TXTFile 401 KB
il api_Salelnvoiceltem_6572.txt 29/11/2022 4:20 pm TXTFile 72 KB
il api_Salelnvoiceltem_6586.txt 29/11/2022 4:20 pm TXTFile 5 KB
il api_Salelnvoiceltem_6587.txt 29/11/2022 4:20 pm TXTFile 9 KB
il api_Salelnvoiceltem_6589.txt 29/11/2022 4:21 pm TXTFile 2,640 KB
il api_Salelnvoiceltem_6923.txt 29/11/2022 4:21 pm TXTFile 2,884 KB
il api_Salelnvoiceltem_7323.txt 29/11/2022 4:21 pm TXTFile 2,991 KB
il api_Salelnvoiceltem_7723.txt 29/11/2022 4:21 pm TXTFile 2,891 KB
il api_Salelnvoiceltem_8123.txt 29/11/2022 4:21 pm TXTFile 3,017 KB
il api_Salelnvoiceltem_8523.txt 29/11/2022 4:21 pm TXTFile 1,477 KB
il api_Salelnvoiceltem_8721.txt 29/11/2022 4:21 pm TXTFile 130 KB
il api_Salelnvoiceltem_8744.txt 29/11/2022 4:21 pm TXTFile 55 KB
il api_Salelnvoiceltem_8754.txt 29/11/2022 4:21 pm TXTFile 1,085 KB
il api_Salelnvoiceltem_8912.txt 29/11/2022 4:21 pm TXTFile 3,024 KB
il api_Salelnvoiceltem_9312.txt 29/11/2022 4:21 pm TXTFile 2,929 KB
il api_Salelnvoiceltem_9712.txt 29/11/2022 4:21 pm TXTFile 2,999 KB
il api_Salelnvoiceltem_10112.txt 29/11/2022 4:21 pm TXTFile 3,164 KB
il api_Salelnvoiceltem_10512.txt 29/11/2022 4:21 pm TXTFile 2,805 KB
il api_Salelnvoiceltem_10896.txt 29/11/2022 4:21 pm TXTFile 313 KB
il api_Salelnvoiceltem_10947.txt 29/11/2022 4:21 pm TXTFile 131 KB
il api_Salelnvoiceltem_10970.txt 29/11/2022 4:21 pm TXTFile 12 KB
il api_Salelnvoiceltem_10972.txt 29/11/2022 4:22 pm TXTFile 1,470 KB
il api_Salelnvoiceltem_11160.txt 29/11/2022 4:22 pm TXTFile 2,887 KB
il api_Salelnvoiceltem_11560.txt 29/11/2022 4:22 pm TXTFile 2,936 KB
il api_Salelnvoiceltem_11960.txt 29/11/2022 4:22 pm TXTFile 2,861 KB
il api_Salelnvoiceltem_12360.txt 29/11/2022 4:22 pm TXTFile 2,944 KB
il api_Salelnvoiceltem_12760.txt 29/11/2022 4:22 pm TXTFile 2,719 KB
il api_Salelnvoiceltem_13113.txt 29/11/2022 4:22 pm TXTFile 326 KB
il api_Salelnvoiceltem_13171.txt 29/11/2022 4:22 pm TXTFile 91 KB
il api_Salelnvoiceltem_13189.txt 29/11/2022 4:22 pm TXTFile 258 KB
