Hello - We have been able to successfully pull audit history of a main table. But we have deleted records on a subtable of that main table. The change list will tell me that the subtable was updated, but I cant seem to to pull the difference JSON object anywhere. Is there anyway I can obtain that information to fix deleted records?
The Difference panel when viewing audit history should show you removals of rows from a subtable. It might be on the preceding audit history record compared to the one you’re looking at?
Hi @ian.p - I am able to get that information if i drill into each record one by one and view the detail. Im wondering if there is a way to export all the difference fields for changes to records into a CSV or get them all consolidated so I can do a mass update. Is that possible? The audit table says it hits an endpoint to get that data?
Sorry - I did not explain this properly in my first post!
As far as I’m aware, there isn’t a good way to export all that difference data. You can do a summarized export of audit data from the Audit History Viewer after having used Audit History Generation Utility (requires SYS - Record Audit) but I don’t think it’ll export the granular json diffs you can see in the detail view of an audit record.
Thanks @ian.p. Do you know if there is a way we can get to that data by opening a ticket? Our use case is this: a customer deleted several subtable records (for different header ID’s). And they would like them restored if possible. But I need a list of all the detail to do so, which it looks like is available in the diff json.
Thanks!