File audit trailing
To enable audit logs for files
1. Open the properties panel and click on the Data Connections section
You need to set up a connection before enabling logs
2. Go to the Enable audit logs option
3. Click on the switch control to enable audit logs
Once you start adding data, a folder with the name Audit\[File name]\ will be created under the path related to the connection. (e.g. if your connection points to C:\test\writeback folder and the file name is Customers, the audit logs will be stored in the C:\test\writeback\Audit\Customers folder)
A new log file will be created per day to avoid performance issues in reading big files.
The audit log files contain a similiar structure as the original file with 3 additional XML nodes: ActionAt, ActionBy and ActionType.
XML Node
Description
ActionAt
Date and time when the action was performed
ActionBy
Which user performed the action (UserDirectory\UserId)
ActionType
What action was performed ( C = create, U = update, D= delete )
In the example below you can see an entry for the Customers audit log XML file.
<Row>
<Id xsi:type="string">ABC001</Id>
<Name xsi:type="string">Micheal Smith</Name>
<Date/>
<ActionAt xsi:type="dateTime">2021-04-22T11:58:25.684+00:00</ActionAt>
<ActionBy xsi:type="string">QOM\jdean</ActionBy>
<ActionType xsi:type="string">C</ActionType>
</Row>Last updated
Was this helpful?