Recently created or updated records

Question

Hi,&nbsp;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 filter other record based on time stamp when it was created or updated?&nbsp;To give you idea what i am trying to achieve, I have a background tools thats pulls out all the data from MYOB API then store it on local database for faster processing. The flow is loop thru all record then compare it with locally stored data to see if the data is recently created or updated. It is completely working fine but as time goes, more and more data are being created and it is taking longer and longer to process. As a fix to this, I need to look for a timestamp to be able to compare with the latest stored on database and only process the recently created or updated but other end points doesnt that kind of data, thats where the LastModifed timestamp will be a really great help for this.&nbsp;If this needs to be requested from the development team of MYOB, may we know how to file this request? Thank you in advance.

jeremyf · Answer

Hi,You can do this using odata queries on most endpointshttps://developer.myob.com/api/myob-business-api/api-overview/retrieving-data/#FILTER&nbsp;&nbsp;LastModified ge datetime'2024-04-02'&nbsp;Just need to append it to your request uri&nbsp;CheerJF&nbsp;&nbsp;

nocturnal · Answer

Hi&nbsp;JeremyF&nbsp;,&nbsp;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).&nbsp;Looks like LastModified data needed to be added on Purchases endpoints.

mike_james · Answer

Hi&nbsp;Nocturnal&nbsp;, the Rowversion value can also be stored and compared. We do this where lastmodified is not available.&nbsp;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.

nocturnal · Answer

Hi&nbsp;Mike_James,&nbsp;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.

gavin12345 · Answer

Hi&nbsp;Nocturnal&nbsp;&nbsp;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&nbsp;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.&nbsp;RegardsGavin

Forum Discussion

Recently created or updated records

Looking for something else?

Related content

PAYG Not calculating in payruns as of recent update

Where are my recent invoices

A SECOND PAGE ON INVOICES HAS AUTOMATICALLY STARTED PRINTING SINCE RECENT UPDATE IN ACCOUNTRIGHT

Unable to View Recent MYOB Invoices

Fetch recently created budget thrugh API

SUBSCRIPTION UPDATE REQUIRED

Update Superannuation details

Business unavailable due to updates