Recently created or updated records
Hi, I am looking for a way to get the recently created or updated record via API but looks like only Sale Invoice and Order on have a "LastModified" record on it, is there anyone found a way to f...
Forum Discussion
Hi,
You can do this using odata queries on most endpoints
https://developer.myob.com/api/myob-business-api/api-overview/retrieving-data/#FILTER
LastModified ge datetime'2024-04-02'
Just need to append it to your request uri
Cheer
JF
Hi JeremyF ,
Yup, I can do this on Sales Invoice and Orders because they have the LastModified data available on those end points, but for Purchase Orders and Bills I cant do this because they dont have the same columns and they are returning empty dataset when addind that filter (see image below).
Looks like LastModified data needed to be added on Purchases endpoints.
Hi Nocturnal , the Rowversion value can also be stored and compared. We do this where lastmodified is not available.
We also find that larger files generally take longer to process, although the API's performance is usually very good. We did find it necessary to compress the API result in one endpoint (item purchases), due to a case where the client had very lengthy purchases.
Hi Mike_James,
Yes, thats the same flow I am using but my client is looking for solution to make it even faster yet wont cause bigger cost for the infra side. I was thinking firing multiple thread that can process multiple pages but this will cause bigger cause for infra side thats why I am thinking if its possible to request for the "LastModified" data to be availble on all endpoints.
Hi Nocturnal
Not sure if I understood what you are trying to do and exactly what the issue is, however I know that as transactions/records accumulate in the MYOB file, processing slows. As you seem to be adding those transactions to your local database, perhaps consider getting the MYOB file purged from time to time. This can significantly reduce the number of transactions in the MYOB file and means less transactions for you to keep checking. MYOX Services offer a purge service to help keep MYOB file sizes down.
Regards
Gavin
