• Replies 6 replies
  • Subscribers 0 subscribers
  • Views 39 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, their iSheet audit history is extremely limited and it is something we have asked to be improved.

    ../showSwaggerUI.action#/ISheet%20Module/getISheetLevelAuditHistory

    This feeds back last modified by , time and the version of the record it is basically the same data contained in "more actions" -> "Audit history". There is currently no way (that I certainly know of) to check what has been changed.This feature only exists in the UI as a comparison.

    While you could export the data and do your own comparison based on the information you would still have to go the UI and check to see who made which changes. (I.e I compare data, v1 v v3 , I can see person X and Y edited the record but I can't tell from this who changed what).I also wouldn't be able to tell if person Y changed what person X did , only that person Y saved a record that was different to my base comparison.

    Hope this is useful to you

Reply

  • Mark Salamon, their iSheet audit history is extremely limited and it is something we have asked to be improved.

    ../showSwaggerUI.action#/ISheet%20Module/getISheetLevelAuditHistory

    This feeds back last modified by , time and the version of the record it is basically the same data contained in "more actions" -> "Audit history". There is currently no way (that I certainly know of) to check what has been changed.This feature only exists in the UI as a comparison.

    While you could export the data and do your own comparison based on the information you would still have to go the UI and check to see who made which changes. (I.e I compare data, v1 v v3 , I can see person X and Y edited the record but I can't tell from this who changed what).I also wouldn't be able to tell if person Y changed what person X did , only that person Y saved a record that was different to my base comparison.

    Hope this is useful to you

Children
No Data