• Replies 6 replies
  • Subscribers 0 subscribers
  • Views 43 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

iSheet Audit History REST APIs

Mark Salamon
27312

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?

Parents

  • Mark Salamon.

    Unfortunately you would need to take backups of the data and then do comparisons on that. There is no way to pull out a specified version of a record - only the latest. The data exists in HighQ, we just can't leverage it. While your generic solution more configurable you could use a view to only show records where modified date is let's say within a day and you would then be able to see records that have been edited in that time frame (this would save parsing so much audit information). The advantage of audit call is that you retrieve version numbers though. I expect this functionality in the future but for now your use case will be painful you can only use imperfect workarounds. The extended audit history has no API endpoints, it is only accessible via the UI.

    As a side point, I would recommend removing your collaborate instance unique information from this thread.

Reply

  • Mark Salamon.

    Unfortunately you would need to take backups of the data and then do comparisons on that. There is no way to pull out a specified version of a record - only the latest. The data exists in HighQ, we just can't leverage it. While your generic solution more configurable you could use a view to only show records where modified date is let's say within a day and you would then be able to see records that have been edited in that time frame (this would save parsing so much audit information). The advantage of audit call is that you retrieve version numbers though. I expect this functionality in the future but for now your use case will be painful you can only use imperfect workarounds. The extended audit history has no API endpoints, it is only accessible via the UI.

    As a side point, I would recommend removing your collaborate instance unique information from this thread.

Children
No Data