• Replies 6 replies
  • Subscribers 0 subscribers
  • Views 37 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 - One other point I forgot to mention. You aren't able to access the "Import Template" data via the API, you can only access the export data (i.e you can only pull down relevant data).

    If a user originally selected "Yes" which displayed 10 columns(each column populated) and then changed it to "No", which hid those 10 columns and/or showed new ones, the data in those now hidden columns and so they be exported as BLANK.That would be interpreted by a comparison that the user deleted the information. While this is technically correct (data is now considered fallback) it would make your comparisons perhaps quite complicated when in fact the person changed 1 pivot data point and that change just had consequences.

Reply

  • Mark Salamon - One other point I forgot to mention. You aren't able to access the "Import Template" data via the API, you can only access the export data (i.e you can only pull down relevant data).

    If a user originally selected "Yes" which displayed 10 columns(each column populated) and then changed it to "No", which hid those 10 columns and/or showed new ones, the data in those now hidden columns and so they be exported as BLANK.That would be interpreted by a comparison that the user deleted the information. While this is technically correct (data is now considered fallback) it would make your comparisons perhaps quite complicated when in fact the person changed 1 pivot data point and that change just had consequences.

Children
No Data