I'm trying to understand what is possible with the iSheet REST APIs related to audit history.
The use case is that every month we need to show all of the records and indicate what has changed in an iSheet. There are 3 types of changes: 1 - new records, 2 - deleted records and 3 - modified records. I assume this REST call can get us that information: collaborate.highq.com/.../viewWikiPage.action There is no way to limit the results to a given time frame? Instead, we simply need to request all of the results and iterate through them for the actions made during the time period in question? I guess we could try to track the nextauditid for the last activity in each month and start the query from there for the next month?
Once we have identified the records that have changed, we would want to show which values had been updated (at the row and column level), likely limited to showing the new values. The iSheet audit comparison feature on the site is very nice for this. Can that be replicated with the collaborate.highq.com/.../viewWikiPage.action call?
The goal would likely be preparing an Excel or CSV file showing all of the records with an initial column indicating "New", "Deleted" or "Updated" and for the "Updated" records showing the changed values set off some way, perhaps in a different font color.
Has anyone undertaken an effort like this?
